contig_metadata
17 rows where bioproject = "PRJEB6097" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1400055 | 1400055 | PRJEB6097_S_NODE_2542_length_282_cov_14.599190_g2488_i0 | PRJEB6097 | 2542 | 282 | 14.59919 | 41.1697158 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 520 | 5.93e-143 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g2488 | i0 | 100 | 99.8971631205674 | 281 | 0 | 99 | 0 | 2 | 282 | 328 | 48 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 28171 | 520 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 3542810 | 3542810 | PRJEB6097_S_NODE_5663_length_192_cov_4.598726_g5609_i0 | PRJEB6097 | 5663 | 192 | 4.598726 | 8.82955392 | Poterioochromonas | 88166 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.13e-93 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g5609 | i0 | 100 | 100.807291666667 | 192 | 0 | 100 | 0 | 1 | 192 | 1537 | 1346 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 19355 | 355 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 6095436 | 6095436 | PRJEB6097_S_NODE_6245_length_165_cov_3.800000_g6191_i0 | PRJEB6097 | 6245 | 165 | 3.8 | 6.27 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 9.59e-79 | NTclustered | gi|1695780|gb|U42448.1|CAU42448 | 45110 | g6191 | i0 | 100 | 100.315151515152 | 165 | 0 | 100 | 0 | 1 | 165 | 379 | 215 | Cercomonas ATCC50316 18S ribosomal RNA gene, complete sequence | blastn | 16552 | 305 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. ATCC 50316 | |||
| 6095437 | 6095437 | PRJEB6097_S_NODE_6445_length_159_cov_2.258065_g6391_i0 | PRJEB6097 | 6445 | 159 | 2.258065 | 3.59032335 | Poterioochromonas | 88166 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 1.98e-75 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g6391 | i0 | 100 | 100.358490566038 | 159 | 0 | 100 | 0 | 1 | 159 | 1180 | 1338 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 15957 | 294 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 7369769 | 7369769 | PRJEB6097_S_NODE_506_length_434_cov_29013.070175_g452_i0 | PRJEB6097 | 506 | 434 | 29013.070175 | 125916.7245595 | root | 1 | Root_unresolved | Root_unresolved | 392 | 2.1699999999999998e-104 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g452 | i0 | 99.535 | 44.241935483871 | 215 | 1 | 50 | 0 | 220 | 434 | 8330 | 8116 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 19201 | 392 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 9052843 | 9052843 | PRJEB6097_S_NODE_4748_length_248_cov_3.389671_g4694_i0 | PRJEB6097 | 4748 | 248 | 3.389671 | 8.40638408 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 5.45e-98 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g4694 | i0 | 99.507 | 75.3266129032258 | 203 | 1 | 82 | 0 | 1 | 203 | 15712 | 15510 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 18681 | 370 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 12879228 | 12879228 | PRJEB6097_S_NODE_6631_length_154_cov_2.075630_g6577_i0 | PRJEB6097 | 6631 | 154 | 2.07563 | 3.1964702 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.2e-37 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g6577 | i0 | 95.283 | 44.7272727272727 | 106 | 5 | 69 | 0 | 3 | 108 | 3751 | 3856 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 6888 | 169 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 14153975 | 14153975 | PRJEB6097_S_NODE_192_length_505_cov_25064.421277_g138_i0 | PRJEB6097 | 192 | 505 | 25064.421277 | 126575.32744885 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 3.179999999999999e-133 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g138 | i0 | 98.556 | 54.8554455445545 | 277 | 3 | 55 | 1 | 230 | 505 | 1396 | 1120 | Vorticella sp. 4 JG-2011 clone 2 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 | 27702 | 488 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 15427984 | 15427984 | PRJEB6097_S_NODE_4873_length_245_cov_3.785714_g4819_i0 | PRJEB6097 | 4873 | 245 | 3.785714 | 9.2749993 | Helicotheca tamesis | 374047 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 2.18e-12 | NTclustered | gi|2248495790|ref|NC_063455.1| | 374047 | g4819 | i0 | 84.444 | 4.26530612244898 | 90 | 11 | 36 | 3 | 131 | 219 | 5273 | 5360 | Helicotheca tamesis isolate Qingdao in China mitochondrion, complete genome | blastn | 1045 | 86.1 | 1 | Eukaryota | Sar | Bacillariophyta | Mediophyceae | Lithodesmiales | Lithodesmiaceae | Helicotheca | Helicotheca tamesis | ||
| 16702260 | 16702260 | PRJEB6097_S_NODE_434_length_450_cov_28391.645783_g380_i0 | PRJEB6097 | 434 | 450 | 28391.645783 | 127762.4060235 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 3.759999999999999e-107 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g380 | i0 | 100 | 27.8111111111111 | 217 | 0 | 48 | 0 | 234 | 450 | 2022 | 1806 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 12515 | 401 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 17977161 | 17977161 | PRJEB6097_S_NODE_6275_length_164_cov_3.410853_g6221_i0 | PRJEB6097 | 6275 | 164 | 3.410853 | 5.59379892 | Colponema vietnamica | 1492817 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.01e-33 | NTclustered | gi|1280963088|gb|MG202006.1| | 1492817 | g6221 | i0 | 91.304 | 111.707317073171 | 115 | 9 | 70 | 1 | 51 | 164 | 11280 | 11166 | Colponema vietnamica strain Colp-7a mitochondrion | blastn | 18320 | 156 | 1 | Eukaryota | Sar | Colponemida | Colponemidia | Colponema | Colponema vietnamica | ||||
| 18843899 | 18843899 | PRJEB6097_S_NODE_515_length_432_cov_29693.395466_g461_i0 | PRJEB6097 | 515 | 432 | 29693.395466 | 128275.46841312 | root | 1 | Root_unresolved | Root_unresolved | 374 | 7.829999999999997e-99 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g461 | i0 | 98.14 | 42.6759259259259 | 215 | 2 | 49 | 2 | 1 | 213 | 8116 | 8330 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 18436 | 374 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 22669183 | 22669183 | PRJEB6097_S_NODE_458_length_445_cov_28832.412195_g404_i0 | PRJEB6097 | 458 | 445 | 28832.412195 | 128304.23426775 | Ochromonas danica | 2986 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 8.63e-30 | NR | NP_066421.1 | 2986 | g404 | i0 | 77.8 | 0.485393258426966 | 72 | 16 | 48.5 | 0 | 3 | 218 | 190 | 261 | NP_066421.1 ribosomal protein L2 [Ochromonas danica] | diamond | 216 | 119 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | Ochromonas danica | |||
| 26780547 | 26780547 | PRJEB6097_S_NODE_6661_length_153_cov_2.372881_g6607_i0 | PRJEB6097 | 6661 | 153 | 2.372881 | 3.63050793 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.0251 | NR | KAJ1425508.1 | 483371 | g6607 | i0 | 76.7 | 0.588235294117647 | 30 | 7 | 58.8 | 0 | 151 | 62 | 188 | 217 | KAJ1425508.1 ribosomal protein S6, partial [Ochromonadaceae sp. CCMP2298] | diamond | 90 | 41.6 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 28391685 | 28391685 | PRJEB6097_S_NODE_6806_length_150_cov_1.513043_g6752_i0 | PRJEB6097 | 6806 | 150 | 1.513043 | 2.2695645 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 2.85e-19 | NR | MES1911722.1 | 1215613 | g6752 | i0 | 75 | 0.96 | 48 | 12 | 96 | 0 | 146 | 3 | 1 | 48 | MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 144 | 82 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28896744 | 28896744 | PRJEB6097_S_NODE_5588_length_197_cov_2.166667_g5534_i0 | PRJEB6097 | 5588 | 197 | 2.166667 | 4.26833399 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 1.45e-12 | NR | KAJ1401815.1 | 483371 | g5534 | i0 | 84.6 | 1.18781725888325 | 39 | 6 | 59.4 | 0 | 1 | 117 | 102 | 140 | KAJ1401815.1 ubiquitin-related domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 234 | 68.2 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31582353 | 31582353 | PRJEB6097_S_NODE_5956_length_176_cov_1.602837_g5902_i0 | PRJEB6097 | 5956 | 176 | 1.602837 | 2.82099312 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 2.95e-10 | NR | KAJ1422858.1 | 483371 | g5902 | i0 | 81.8 | 0.5625 | 33 | 6 | 56.3 | 0 | 176 | 78 | 50 | 82 | KAJ1422858.1 ribosomal protein S27 [Ochromonadaceae sp. CCMP2298] | diamond | 99 | 60.5 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 |
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);;