contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1102048" and tax_phylum = "Discosea"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7864384 | 7864384 | PRJNA1102048_P_NODE_12387_length_253_cov_1.650000_g12283_i0 | PRJNA1102048 | 12387 | 253 | 1.65 | 4.1745 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 460 | 3.2199999999999996e-125 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g12283 | i0 | 99.605 | 82.4901185770751 | 253 | 0 | 100 | 1 | 1 | 253 | 493 | 242 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 20870 | 460 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 9139365 | 9139365 | PRJNA1102048_P_NODE_3368_length_462_cov_1.755784_g3264_i0 | PRJNA1102048 | 3368 | 462 | 1.755784 | 8.11172208 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 244 | 6.89e-60 | NTclustered | gi|470467440|ref|XM_004341747.1| | 1257118 | g3264 | i0 | 77.75 | 2.50865800865801 | 400 | 87 | 86 | 2 | 64 | 462 | 19 | 417 | Acanthamoeba castellanii str. Neff guanine nucleotide-binding protein beta subunit, putative (ACA1_199990), partial mRNA | blastn | 1159 | 244 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12965518 | 12965518 | PRJNA1102048_P_NODE_12671_length_251_cov_0.865169_g12567_i0 | PRJNA1102048 | 12671 | 251 | 0.865169 | 2.17157419 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 353 | 5.569999999999998e-93 | NTclustered | gi|470529577|ref|XM_004368039.1| | 1257118 | g12567 | i0 | 92.653 | 9.23505976095618 | 245 | 18 | 98 | 0 | 5 | 249 | 491 | 247 | Acanthamoeba castellanii str. Neff ribulosephosphate 3-epimerase (ACA1_291490), partial mRNA | blastn | 2318 | 353 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16788801 | 16788801 | PRJNA1102048_P_NODE_11114_length_266_cov_1.378238_g11010_i0 | PRJNA1102048 | 11114 | 266 | 1.378238 | 3.66611308 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 300 | 7.87e-77 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g11010 | i0 | 87.546 | 11.2857142857143 | 273 | 17 | 100 | 12 | 1 | 266 | 278 | 16 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 3002 | 300 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 16788807 | 16788807 | PRJNA1102048_P_NODE_12034_length_256_cov_2.333333_g11930_i0 | PRJNA1102048 | 12034 | 256 | 2.333333 | 5.97333248 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 455 | 1.52e-123 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g11930 | i0 | 98.828 | 71.81640625 | 256 | 2 | 100 | 1 | 1 | 256 | 1641 | 1895 | Vannella septentrionalis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 18385 | 455 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 18063500 | 18063500 | PRJNA1102048_P_NODE_8275_length_302_cov_1.912664_g8171_i0 | PRJNA1102048 | 8275 | 302 | 1.912664 | 5.77624528 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 180 | 1.24e-40 | NTclustered | gi|470442906|ref|XM_004339540.1| | 1257118 | g8171 | i0 | 80.252 | 2.32119205298013 | 238 | 47 | 79 | 0 | 53 | 290 | 21 | 258 | Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA | blastn | 701 | 180 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19337512 | 19337512 | PRJNA1102048_P_NODE_1476_length_635_cov_6.866548_g1376_i0 | PRJNA1102048 | 1476 | 635 | 6.866548 | 43.6025798 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 833 | 0 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g1376 | i0 | 90.379 | 99.5165354330709 | 634 | 61 | 99 | 0 | 1 | 634 | 525 | 1158 | Platyamoeba placida actin mRNA, partial cds | blastn | 63193 | 833 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 21888495 | 21888495 | PRJNA1102048_P_NODE_11438_length_262_cov_3.523810_g11334_i0 | PRJNA1102048 | 11438 | 262 | 3.52381 | 9.2323822 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 361 | 3.5e-95 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g11334 | i0 | 91.76 | 1.01908396946565 | 267 | 11 | 100 | 10 | 1 | 262 | 5925 | 5665 | Acanthamoeba castellanii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 267 | 361 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21888641 | 21888641 | PRJNA1102048_P_NODE_9718_length_281_cov_2.961538_g9614_i0 | PRJNA1102048 | 9718 | 281 | 2.961538 | 8.32192178 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 141 | 5.37e-29 | NTclustered | gi|470423488|ref|XM_004337555.1| | 1257118 | g9614 | i0 | 79.227 | 28.7686832740214 | 207 | 39 | 73 | 4 | 74 | 278 | 277 | 481 | Acanthamoeba castellanii str. Neff ribosomal protein L23, putative (ACA1_164710), partial mRNA | blastn | 8084 | 141 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;