contig_metadata
22 rows where bioproject = "PRJEB36940" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56822 | 56822 | PRJEB36940_P_NODE_3681_length_443_cov_2.902703_g3552_i0 | PRJEB36940 | 3681 | 443 | 2.902703 | 12.85897429 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.08e-33 | NR | AAY21202.1 | 227086 | g3552 | i0 | 62.5 | 1.30022573363431 | 96 | 36 | 65 | 0 | 297 | 10 | 18 | 113 | AAY21202.1 Rpl7A, partial [Bigelowiella natans] | diamond | 576 | 126 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 3882871 | 3882871 | PRJEB36940_P_NODE_1944_length_603_cov_2.758491_g1822_i0 | PRJEB36940 | 1944 | 603 | 2.758491 | 16.63370073 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 269 | 3.6099999999999986e-87 | NR | MES1911029.1 | 1215613 | g1822 | i0 | 67.7 | 2.95024875621891 | 201 | 61 | 98 | 2 | 12 | 602 | 1 | 201 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1779 | 269 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 6434891 | 6434891 | PRJEB36940_P_NODE_10306_length_273_cov_1.940000_g10177_i0 | PRJEB36940 | 10306 | 273 | 1.94 | 5.2962 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.7099999999999997e-93 | NTclustered | gi|302026152|gb|GQ377656.1| | 646463 | g10177 | i0 | 90.11 | 100.304029304029 | 273 | 27 | 100 | 0 | 1 | 273 | 373 | 101 | Gymnophrys sp. ATCC 50923 beta-tubulin (Btub) gene, partial cds | blastn | 27383 | 355 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 6434909 | 6434909 | PRJEB36940_P_NODE_11826_length_256_cov_4.486339_g11697_i0 | PRJEB36940 | 11826 | 256 | 4.486339 | 11.48502784 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.2599999999999995e-125 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g11697 | i0 | 99.216 | 100.49609375 | 255 | 2 | 99 | 0 | 1 | 255 | 711 | 965 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 25727 | 460 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 7366561 | 7366561 | PRJEB36940_P_NODE_2366_length_550_cov_5.283019_g2240_i0 | PRJEB36940 | 2366 | 550 | 5.283019 | 29.0566045 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 4.759999999999999e-85 | NR | MES1911029.1 | 1215613 | g2240 | i0 | 70.9 | 7.89272727272727 | 179 | 52 | 97.6 | 0 | 12 | 548 | 1 | 179 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 4341 | 263 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 10259456 | 10259456 | PRJEB36940_P_NODE_11269_length_262_cov_3.671958_g11140_i0 | PRJEB36940 | 11269 | 262 | 3.671958 | 9.62052996 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 2.7400000000000002e-86 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g11140 | i0 | 89.474 | 101.629770992366 | 266 | 22 | 100 | 6 | 1 | 262 | 2721 | 2984 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 26627 | 331 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 10259511 | 10259511 | PRJEB36940_P_NODE_2209_length_570_cov_2.167002_g2084_i0 | PRJEB36940 | 2209 | 570 | 2.167002 | 12.3519114 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 258 | 1.12e-83 | NR | ADK26624.1 | 323453 | g2084 | i0 | 74.1 | 0.894736842105263 | 170 | 44 | 89.5 | 0 | 570 | 61 | 107 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 510 | 258 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 10259557 | 10259557 | PRJEB36940_P_NODE_4049_length_424_cov_5.313390_g3920_i0 | PRJEB36940 | 4049 | 424 | 5.31339 | 22.5287736 | Bodomorpha sp. HFCC55 | 624126 | SAR_Eukaryotes | SAR_Eukaryotes | 761 | 0 | NTclustered | gi|225216790|gb|FJ176705.1| | 624126 | g3920 | i0 | 99.054 | 11.7405660377358 | 423 | 4 | 99 | 0 | 1 | 423 | 289 | 711 | Bodomorpha sp. 28S ribosomal RNA gene, partial sequence | blastn | 4978 | 761 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC55 | |||
| 11534971 | 11534971 | PRJEB36940_P_NODE_3270_length_469_cov_5.333333_g3142_i0 | PRJEB36940 | 3270 | 469 | 5.333333 | 25.01333177 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 822 | 0 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g3142 | i0 | 98.294 | 23.1748400852878 | 469 | 8 | 100 | 0 | 1 | 469 | 713 | 245 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 10869 | 822 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 11535027 | 11535027 | PRJEB36940_P_NODE_6190_length_345_cov_4.426471_g6061_i0 | PRJEB36940 | 6190 | 345 | 4.426471 | 15.27132495 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 616 | 9.229999999999999e-172 | NTclustered | gi|225216798|gb|FJ176713.1| | 458884 | g6061 | i0 | 99.123 | 99.7246376811594 | 342 | 3 | 99 | 0 | 1 | 342 | 342 | 1 | Bodomorpha sp. HFCC92 18S ribosomal RNA gene, partial sequence | blastn | 34405 | 616 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 14085012 | 14085012 | PRJEB36940_P_NODE_1452_length_693_cov_1.493548_g1332_i0 | PRJEB36940 | 1452 | 693 | 1.493548 | 10.35028764 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 312 | 4.11e-104 | NR | ADK26624.1 | 323453 | g1332 | i0 | 69.5 | 0.952380952380952 | 220 | 65 | 94.4 | 1 | 38 | 691 | 6 | 225 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 660 | 312 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 16633624 | 16633624 | PRJEB36940_P_NODE_2854_length_500_cov_4.536300_g2727_i0 | PRJEB36940 | 2854 | 500 | 4.5363 | 22.6815 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 229 | 8.91e-75 | NR | ADK26622.1 | 323453 | g2727 | i0 | 82.3 | 0.78 | 130 | 23 | 78 | 0 | 24 | 413 | 1 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 390 | 229 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 16633648 | 16633648 | PRJEB36940_P_NODE_3954_length_429_cov_11.665730_g3825_i0 | PRJEB36940 | 3954 | 429 | 11.66573 | 50.0459817 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 3.75e-72 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g3825 | i0 | 95.028 | 47.5850815850816 | 181 | 9 | 59 | 0 | 1 | 181 | 3659 | 3839 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20414 | 285 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 17908313 | 17908313 | PRJEB36940_P_NODE_10815_length_267_cov_2.592784_g10686_i0 | PRJEB36940 | 10815 | 267 | 2.592784 | 6.92273328 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.3500000000000004e-59 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g10686 | i0 | 83.146 | 85.374531835206 | 267 | 43 | 99 | 2 | 2 | 267 | 254 | 519 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 22795 | 243 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 18840655 | 18840655 | PRJEB36940_P_NODE_11735_length_257_cov_2.717391_g11606_i0 | PRJEB36940 | 11735 | 257 | 2.717391 | 6.98369487 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 3.659999999999999e-23 | NR | MES1911029.1 | 1215613 | g11606 | i0 | 60 | 0.933852140077821 | 80 | 32 | 93.4 | 0 | 256 | 17 | 196 | 275 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 240 | 100 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 26646638 | 26646638 | PRJEB36940_P_NODE_4401_length_407_cov_1.553892_g4272_i0 | PRJEB36940 | 4401 | 407 | 1.553892 | 6.32434044 | Polycystinea | 65582 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 1.32e-17 | NR | ADK26624.1 | 323453 | g4272 | i0 | 72.9 | 0.86977886977887 | 59 | 16 | 43.5 | 0 | 401 | 225 | 218 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 354 | 87.8 | 0.990888382687927 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 26653153 | 26653153 | PRJEB36940_P_NODE_13561_length_248_cov_17.097143_g13432_i0 | PRJEB36940 | 13561 | 248 | 17.097143 | 42.40091464 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 92 | 1.2e-22 | NR | MES1911722.1 | 1215613 | g13432 | i0 | 76.9 | 0.629032258064516 | 52 | 12 | 62.9 | 0 | 16 | 171 | 1 | 52 | MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 156 | 92 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28139056 | 28139056 | PRJEB36940_P_NODE_8325_length_300_cov_2.022026_g8196_i0 | PRJEB36940 | 8325 | 300 | 2.022026 | 6.066078 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.00374 | NR | MES1916909.1 | 1215613 | g8196 | i0 | 53.5 | 1.48 | 43 | 16 | 43 | 1 | 193 | 65 | 38 | 76 | MES1916909.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 444 | 43.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28959931 | 28959931 | PRJEB36940_P_NODE_12088_length_254_cov_1.287293_g11959_i0 | PRJEB36940 | 12088 | 254 | 1.287293 | 3.26972422 | Gymnochlora stellata | 67809 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 3.22e-4 | NR | ACF24561.1 | 67809 | g11959 | i0 | 40 | 0.94488188976378 | 80 | 42 | 89.8 | 4 | 228 | 1 | 1 | 78 | ACF24561.1 multiprotein bridging factor type 1 [Gymnochlora stellata] | diamond | 240 | 47.4 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata | ||||
| 29464503 | 29464503 | PRJEB36940_P_NODE_3190_length_476_cov_3.813896_g3062_i0 | PRJEB36940 | 3190 | 476 | 3.813896 | 18.15414496 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 229 | 6.49e-75 | NR | ADK26622.1 | 323453 | g3062 | i0 | 82.3 | 0.819327731092437 | 130 | 23 | 81.9 | 0 | 36 | 425 | 1 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 390 | 229 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 30222814 | 30222814 | PRJEB36940_P_NODE_10832_length_267_cov_1.932990_g10703_i0 | PRJEB36940 | 10832 | 267 | 1.93299 | 5.1610833 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 1.13e-28 | NR | MES1914773.1 | 1215613 | g10703 | i0 | 70.5 | 1.74157303370787 | 78 | 20 | 84.3 | 1 | 229 | 5 | 7 | 84 | MES1914773.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 465 | 109 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32562923 | 32562923 | PRJEB36940_P_NODE_12139_length_253_cov_1.694444_g12010_i0 | PRJEB36940 | 12139 | 253 | 1.694444 | 4.28694332 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 3.1e-17 | NR | MES1912234.1 | 1215613 | g12010 | i0 | 56.9 | 1.54150197628458 | 65 | 25 | 77.1 | 2 | 243 | 49 | 59 | 120 | MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 390 | 80.5 | 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);;