contig_metadata
10 rows where bioproject = "PRJNA415636", tax_clade = "Sar" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5522882 | 5522882 | PRJNA415636_S_NODE_25_length_1226_cov_9.717557_g19_i0 | PRJNA415636 | 25 | 1226 | 9.717557 | 119.13724882 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 1282 | 0 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g19 | i0 | 85.692 | 11.3319738988581 | 1258 | 132 | 100 | 37 | 1 | 1226 | 105 | 1346 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 13893 | 1282 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 6796856 | 6796856 | PRJNA415636_S_NODE_1026_length_404_cov_13.459384_g979_i0 | PRJNA415636 | 1026 | 404 | 13.459384 | 54.37591136 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 2.0199999999999996e-99 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g979 | i0 | 85.34 | 54.5 | 382 | 34 | 93 | 13 | 1 | 377 | 3675 | 4039 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 22018 | 375 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 13172879 | 13172879 | PRJNA415636_S_NODE_131_length_794_cov_11.133869_g106_i0 | PRJNA415636 | 131 | 794 | 11.133869 | 88.40291986 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 1018 | 0 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g106 | i0 | 89.668 | 1.0919395465995 | 813 | 65 | 100 | 11 | 1 | 794 | 18440 | 17628 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 867 | 1018 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 13172885 | 13172885 | PRJNA415636_S_NODE_631_length_473_cov_4.497653_g586_i0 | PRJNA415636 | 631 | 473 | 4.497653 | 21.27389869 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 1.38e-131 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g586 | i0 | 85.714 | 2.2093023255814 | 462 | 61 | 97 | 4 | 1 | 458 | 25679 | 25219 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 1045 | 483 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 15721781 | 15721781 | PRJNA415636_S_NODE_5333_length_222_cov_1.674286_g5286_i0 | PRJNA415636 | 5333 | 222 | 1.674286 | 3.71691492 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 405 | 1.31e-108 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g5286 | i0 | 99.55 | 92.6126126126126 | 222 | 1 | 100 | 0 | 1 | 222 | 1609 | 1830 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 20560 | 405 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 19544932 | 19544932 | PRJNA415636_S_NODE_256_length_636_cov_12.604414_g226_i0 | PRJNA415636 | 256 | 636 | 12.604414 | 80.16407304 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 2.53e-105 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g226 | i0 | 92.446 | 0.860062893081761 | 278 | 20 | 74 | 1 | 359 | 636 | 18795 | 19071 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 547 | 396 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 22095528 | 22095528 | PRJNA415636_S_NODE_2998_length_278_cov_2.064935_g2951_i0 | PRJNA415636 | 2998 | 278 | 2.064935 | 5.7405193 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 1.51e-14 | NTclustered | gi|302026200|gb|GQ377710.1| | 323453 | g2951 | i0 | 79.412 | 0.784172661870504 | 136 | 24 | 48 | 4 | 14 | 147 | 152 | 285 | Heteromita sp. PRA-74 40S ribosomal protein-like mRNA, partial sequence | blastn | 218 | 93.5 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 22760246 | 22760246 | PRJNA415636_S_NODE_7598_length_176_cov_5.728682_g7551_i0 | PRJNA415636 | 7598 | 176 | 5.728682 | 10.08248032 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 7.92e-85 | NTclustered | gi|33309627|gb|AF411270.1| | 100933 | g7551 | i0 | 100 | 99.9375 | 176 | 0 | 100 | 0 | 1 | 176 | 1634 | 1459 | Cercomonas longicauda 18S ribosomal RNA gene, complete sequence | blastn | 17589 | 326 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas longicauda | |||
| 23371222 | 23371222 | PRJNA415636_S_NODE_259_length_630_cov_9.656947_g229_i0 | PRJNA415636 | 259 | 630 | 9.656947 | 60.8387661 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 837 | 0 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g229 | i0 | 91.011 | 2.62539682539683 | 623 | 52 | 99 | 4 | 9 | 630 | 1988 | 1369 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 1654 | 837 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 26917376 | 26917376 | PRJNA415636_S_NODE_4522_length_237_cov_2.147368_g4475_i0 | PRJNA415636 | 4522 | 237 | 2.147368 | 5.08926216 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 3.49e-9 | NR | YP_009118062.1 | 372086 | g4475 | i0 | 90.3 | 0.392405063291139 | 31 | 3 | 39.2 | 0 | 108 | 200 | 283 | 313 | YP_009118062.1 NADH dehydrogenase subunit 1 [Paracercomonas marina] | diamond | 93 | 62.4 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina |
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);;