contig_metadata
15 rows where bioproject = "PRJNA309466", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1651613 | 1651613 | PRJNA309466_P_NODE_1742_length_537_cov_19.860656_g1690_i0 | PRJNA309466 | 1742 | 537 | 19.860656 | 106.65172272 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 544 | 7.14e-150 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g1690 | i0 | 85.932 | 0.97951582867784 | 526 | 55 | 95 | 11 | 6 | 515 | 554 | 32 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 526 | 544 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 1651641 | 1651641 | PRJNA309466_P_NODE_3942_length_293_cov_5.959016_g3886_i0 | PRJNA309466 | 3942 | 293 | 5.959016 | 17.45991688 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 1.88e-83 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g3886 | i0 | 88.192 | 0.924914675767918 | 271 | 30 | 92 | 2 | 14 | 284 | 1421 | 1689 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 271 | 322 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 4204000 | 4204000 | PRJNA309466_P_NODE_18124_length_162_cov_0.920354_g18067_i0 | PRJNA309466 | 18124 | 162 | 0.920354 | 1.49097348 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 9.85e-44 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g18067 | i0 | 88.125 | 66.141975308642 | 160 | 18 | 98 | 1 | 3 | 161 | 2658 | 2817 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 10715 | 189 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 4204016 | 4204016 | PRJNA309466_P_NODE_2804_length_380_cov_19.425982_g2748_i0 | PRJNA309466 | 2804 | 380 | 19.425982 | 73.8187316 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 2.3e-143 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g2748 | i0 | 91.733 | 3.7 | 375 | 31 | 99 | 0 | 6 | 380 | 2078 | 1704 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 1406 | 521 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 5480306 | 5480306 | PRJNA309466_P_NODE_2365_length_434_cov_73.979221_g2309_i0 | PRJNA309466 | 2365 | 434 | 73.979221 | 321.06981914 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 1e-107 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g2309 | i0 | 86.772 | 49.5990783410138 | 378 | 30 | 86 | 11 | 56 | 429 | 4018 | 3657 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 21526 | 403 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 6754567 | 6754567 | PRJNA309466_P_NODE_9526_length_203_cov_1.279221_g9469_i0 | PRJNA309466 | 9526 | 203 | 1.279221 | 2.59681863 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.68e-37 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g9469 | i0 | 86.842 | 0.748768472906404 | 152 | 19 | 75 | 1 | 3 | 154 | 25370 | 25220 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 152 | 169 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 7441061 | 7441061 | PRJNA309466_P_NODE_3546_length_314_cov_2.569811_g3490_i0 | PRJNA309466 | 3546 | 314 | 2.569811 | 8.06920654 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 7.109999999999998e-54 | NR | YP_009118054.1 | 372086 | g3490 | i0 | 92.8 | 0.926751592356688 | 97 | 7 | 92.7 | 0 | 311 | 21 | 93 | 189 | YP_009118054.1 cytochrome c oxidase subunit 1 and subunit 2 fusion protein [Paracercomonas marina] | diamond | 291 | 189 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 7441093 | 7441093 | PRJNA309466_P_NODE_5186_length_254_cov_2.765854_g5129_i0 | PRJNA309466 | 5186 | 254 | 2.765854 | 7.02526916 | Phaeophyceae | 2870 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 2.58e-20 | NR | YP_009118060.1 | 372086 | g5129 | i0 | 61 | 24.2125984251969 | 82 | 32 | 96.9 | 0 | 253 | 8 | 79 | 160 | YP_009118060.1 cytochrome c oxidase subunit 3 [Paracercomonas marina] | diamond | 6150 | 93.2 | 0.991416309012876 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 9991339 | 9991339 | PRJNA309466_P_NODE_4668_length_266_cov_170.304147_g4612_i0 | PRJNA309466 | 4668 | 266 | 170.304147 | 453.00903102 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 1.63e-103 | NTclustered | gi|33309627|gb|AF411270.1| | 100933 | g4612 | i0 | 100 | 79.1278195488722 | 210 | 0 | 79 | 0 | 42 | 251 | 1440 | 1649 | Cercomonas longicauda 18S ribosomal RNA gene, complete sequence | blastn | 21048 | 388 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas longicauda | |||
| 13130617 | 13130617 | PRJNA309466_P_NODE_171_length_1538_cov_18.081934_g156_i0 | PRJNA309466 | 171 | 1538 | 18.081934 | 278.10014492 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 1345 | 0 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g156 | i0 | 88.317 | 0.993498049414824 | 1147 | 101 | 89 | 20 | 397 | 1514 | 18657 | 17515 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 1528 | 1345 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 18228531 | 18228531 | PRJNA309466_P_NODE_1815_length_522_cov_32.221987_g1760_i0 | PRJNA309466 | 1815 | 522 | 32.221987 | 168.19877214 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 695 | 0 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g1760 | i0 | 93.249 | 33.9003831417625 | 474 | 28 | 90 | 4 | 4 | 475 | 1380 | 909 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 17696 | 695 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 19502844 | 19502844 | PRJNA309466_P_NODE_2076_length_474_cov_12.049412_g2021_i0 | PRJNA309466 | 2076 | 474 | 12.049412 | 57.11421288 | Cercomonas sp. HFCC549 | 458874 | SAR_Eukaryotes | SAR_Eukaryotes | 833 | 0 | NTclustered | gi|161015714|gb|EF681948.1| | 458874 | g2021 | i0 | 99.78 | 41.7257383966245 | 454 | 1 | 96 | 0 | 21 | 474 | 661 | 208 | Cercomonas sp. HFCC549 28S ribosomal RNA gene, partial sequence | blastn | 19778 | 833 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC549 | |||
| 20778367 | 20778367 | PRJNA309466_P_NODE_18317_length_161_cov_19.714286_g18260_i0 | PRJNA309466 | 18317 | 161 | 19.714286 | 31.74000046 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 9.98e-29 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g18260 | i0 | 84.892 | 0.863354037267081 | 139 | 19 | 85 | 2 | 4 | 140 | 25352 | 25490 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 139 | 139 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 22053372 | 22053372 | PRJNA309466_P_NODE_3558_length_313_cov_31.378788_g3502_i0 | PRJNA309466 | 3558 | 313 | 31.378788 | 98.21560644 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 1.9e-128 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g3502 | i0 | 98.148 | 51.8306709265176 | 270 | 5 | 86 | 0 | 2 | 271 | 1946 | 2215 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 16223 | 472 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 26852998 | 26852998 | PRJNA309466_P_NODE_16461_length_166_cov_1.760684_g16404_i0 | PRJNA309466 | 16461 | 166 | 1.760684 | 2.92273544 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 8.06e-25 | NR | YP_009118062.1 | 372086 | g16404 | i0 | 100 | 0.957831325301205 | 53 | 0 | 95.8 | 0 | 165 | 7 | 214 | 266 | YP_009118062.1 NADH dehydrogenase subunit 1 [Paracercomonas marina] | diamond | 159 | 103 | 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);;