contig_metadata
17 rows where bioproject = "PRJNA674048", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 642992 | 642992 | PRJNA674048_P_NODE_19861_length_198_cov_1.348993_g19658_i0 | PRJNA674048 | 19861 | 198 | 1.348993 | 2.67100614 | Phytocercomonas venanatans | 2065209 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 7.65e-31 | NTclustered | gi|1315527750|gb|MF034900.1| | 2065209 | g19658 | i0 | 81.081 | 33.7575757575758 | 185 | 33 | 92 | 2 | 16 | 198 | 9745 | 9561 | Phytocercomonas venanatans 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 6684 | 147 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Phytocercomonas | Phytocercomonas venanatans | |||
| 8296383 | 8296383 | PRJNA674048_P_NODE_20667_length_193_cov_5.340278_g20464_i0 | PRJNA674048 | 20667 | 193 | 5.340278 | 10.30673654 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 1.48e-87 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g20464 | i0 | 97.927 | 82.6891191709845 | 193 | 4 | 100 | 0 | 1 | 193 | 1480 | 1288 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 15959 | 335 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 8819338 | 8819338 | PRJNA674048_P_NODE_9847_length_301_cov_1.801587_g9644_i0 | PRJNA674048 | 9847 | 301 | 1.801587 | 5.42277687 | Guttulinopsis | 1144921 | SAR_Eukaryotes | SAR_Eukaryotes | 505 | 1.79e-138 | NTclustered | gi|1402550487|gb|MH488773.1| | 2231167 | g9644 | i0 | 97.01 | 32.3554817275747 | 301 | 7 | 100 | 2 | 1 | 301 | 1240 | 942 | Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence | blastn | 9739 | 505 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis sp. | ||||
| 10094758 | 10094758 | PRJNA674048_P_NODE_3088_length_644_cov_1.917647_g2912_i0 | PRJNA674048 | 3088 | 644 | 1.917647 | 12.34964668 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 1.69e-37 | NTclustered | gi|83034973|gb|DQ211602.1| | 188950 | g2912 | i0 | 78.707 | 32.1568322981366 | 263 | 50 | 41 | 6 | 170 | 430 | 152 | 410 | Bodomorpha minima strain HFCC55 28S ribosomal RNA gene, partial sequence | blastn | 20709 | 171 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 12122345 | 12122345 | PRJNA674048_P_NODE_16650_length_218_cov_1.846154_g16447_i0 | PRJNA674048 | 16650 | 218 | 1.846154 | 4.02461572 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.06e-64 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g16447 | i0 | 88.732 | 3.45412844036697 | 213 | 23 | 97 | 1 | 7 | 218 | 2126 | 1914 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 753 | 259 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 13397302 | 13397302 | PRJNA674048_P_NODE_8331_length_335_cov_1.269231_g8128_i0 | PRJNA674048 | 8331 | 335 | 1.269231 | 4.25192385 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 6.06e-84 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g8128 | i0 | 86.139 | 0.904477611940299 | 303 | 39 | 90 | 2 | 22 | 321 | 25686 | 25384 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 303 | 324 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 14672098 | 14672098 | PRJNA674048_P_NODE_19052_length_202_cov_2.843137_g18849_i0 | PRJNA674048 | 19052 | 202 | 2.843137 | 5.74313674 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 3.3e-99 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g18849 | i0 | 100 | 98.7227722772277 | 202 | 0 | 100 | 0 | 1 | 202 | 341 | 140 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 19942 | 374 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 15945738 | 15945738 | PRJNA674048_P_NODE_17333_length_213_cov_2.365854_g17130_i0 | PRJNA674048 | 17333 | 213 | 2.365854 | 5.03926902 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 5.8499999999999996e-102 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g17130 | i0 | 99.061 | 85.9342723004695 | 213 | 2 | 100 | 0 | 1 | 213 | 1725 | 1937 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 18304 | 383 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 17221265 | 17221265 | PRJNA674048_P_NODE_9854_length_301_cov_1.611111_g9651_i0 | PRJNA674048 | 9854 | 301 | 1.611111 | 4.84944411 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 5.41e-79 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g9651 | i0 | 89.879 | 57.5348837209302 | 247 | 13 | 82 | 6 | 1 | 246 | 3681 | 3916 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 17318 | 307 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 19017553 | 19017553 | PRJNA674048_P_NODE_13975_length_241_cov_1.958333_g13772_i0 | PRJNA674048 | 13975 | 241 | 1.958333 | 4.71958253 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 435 | 1.84e-117 | NTclustered | gi|1915672533|emb|LR866146.1| | 1937813 | g13772 | i0 | 99.17 | 98.7136929460581 | 241 | 2 | 100 | 0 | 1 | 241 | 47 | 287 | uncultured Allapsidae partial 18S rRNA gene | blastn | 23790 | 435 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | uncultured Allapsidae | ||||
| 19770024 | 19770024 | PRJNA674048_P_NODE_30256_length_165_cov_0.896552_g30053_i0 | PRJNA674048 | 30256 | 165 | 0.896552 | 1.4793108 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.4899999999999995e-72 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g30053 | i0 | 98.148 | 0.981818181818182 | 162 | 3 | 98 | 0 | 1 | 162 | 21 | 182 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 162 | 283 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 19770071 | 19770071 | PRJNA674048_P_NODE_5596_length_436_cov_7.581395_g5393_i0 | PRJNA674048 | 5596 | 436 | 7.581395 | 33.0548822 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 806 | 0 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g5393 | i0 | 100 | 23.4266055045872 | 436 | 0 | 100 | 0 | 1 | 436 | 333 | 768 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 10214 | 806 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 21045627 | 21045627 | PRJNA674048_P_NODE_20337_length_195_cov_2.136986_g20134_i0 | PRJNA674048 | 20337 | 195 | 2.136986 | 4.1671227 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 8.87e-95 | NTclustered | gi|1402550485|gb|MH488771.1| | 2231170 | g20134 | i0 | 100 | 74.2564102564103 | 194 | 0 | 99 | 0 | 2 | 195 | 1979 | 1786 | Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 14480 | 359 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 22320418 | 22320418 | PRJNA674048_P_NODE_23918_length_180_cov_1.183206_g23715_i0 | PRJNA674048 | 23918 | 180 | 1.183206 | 2.1297708 | Cercomonas sp. HFCC549 | 458874 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 1.05e-83 | NTclustered | gi|161015714|gb|EF681948.1| | 458874 | g23715 | i0 | 98.889 | 12.9611111111111 | 180 | 2 | 100 | 0 | 1 | 180 | 465 | 286 | Cercomonas sp. HFCC549 28S ribosomal RNA gene, partial sequence | blastn | 2333 | 322 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC549 | |||
| 23596031 | 23596031 | PRJNA674048_P_NODE_33539_length_157_cov_2.407407_g33336_i0 | PRJNA674048 | 33539 | 157 | 2.407407 | 3.77962899 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 9.2e-64 | NTclustered | gi|1402550486|gb|MH488772.1| | 2231170 | g33336 | i0 | 96.178 | 38.9171974522293 | 157 | 4 | 100 | 1 | 1 | 157 | 1419 | 1573 | Guttulinopsis rogosa isolate T1 small subunit ribosomal RNA gene, partial sequence | blastn | 6110 | 255 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 26796955 | 26796955 | PRJNA674048_P_NODE_14861_length_233_cov_1.000000_g14658_i0 | PRJNA674048 | 14861 | 233 | 1 | 2.33 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 6.31e-20 | NR | MES1909310.1 | 1215613 | g14658 | i0 | 55.4 | 0.836909871244635 | 65 | 28 | 82.4 | 1 | 231 | 40 | 161 | 225 | MES1909310.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 195 | 89.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 26923619 | 26923619 | PRJNA674048_P_NODE_20422_length_195_cov_1.390411_g20219_i0 | PRJNA674048 | 20422 | 195 | 1.390411 | 2.71130145 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 1.16e-10 | NR | MES1909841.1 | 1215613 | g20219 | i0 | 51.6 | 0.984615384615385 | 64 | 30 | 96.9 | 1 | 191 | 3 | 22 | 85 | MES1909841.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 192 | 65.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;