contig_metadata
7 rows where bioproject = "PRJEB75017", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7787760 | 7787760 | PRJEB75017_P_NODE_2607_length_544_cov_195.477707_g2478_i0 | PRJEB75017 | 2607 | 544 | 195.477707 | 1063.39872608 | Amorphochlora amoebiformis | 1561963 | SAR_Eukaryotes | SAR_Eukaryotes | 73.1 | 4.11e-8 | NTclustered | gi|893150443|dbj|AB996604.1| | 1561963 | g2478 | i0 | 80.18 | 9.78860294117647 | 111 | 10 | 20 | 11 | 437 | 544 | 766 | 867 | Amorphochlora amoebiformis nucleomorph DNA, chromosome: 3, complete sequence, strain: CCMP2058 | blastn | 5325 | 73.1 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Amorphochlora | Amorphochlora amoebiformis | ||||
| 9062695 | 9062695 | PRJEB75017_P_NODE_6988_length_337_cov_2.678030_g6859_i0 | PRJEB75017 | 6988 | 337 | 2.67803 | 9.0249611 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 1.22e-135 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g6859 | i0 | 100 | 99.8456973293769 | 268 | 0 | 80 | 0 | 1 | 268 | 268 | 1 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 33648 | 496 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 17986980 | 17986980 | PRJEB75017_P_NODE_4615_length_407_cov_3.314371_g4486_i0 | PRJEB75017 | 4615 | 407 | 3.314371 | 13.48948997 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 5.920000000000001e-70 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g4486 | i0 | 81.081 | 35.3562653562654 | 370 | 51 | 90 | 11 | 1 | 368 | 3669 | 4021 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 14390 | 278 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 19260985 | 19260985 | PRJEB75017_P_NODE_4736_length_403_cov_6.466667_g4607_i0 | PRJEB75017 | 4736 | 403 | 6.466667 | 26.06066801 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 745 | 0 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g4607 | i0 | 100 | 9.35732009925558 | 403 | 0 | 100 | 0 | 1 | 403 | 305 | 707 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 3771 | 745 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 19261001 | 19261001 | PRJEB75017_P_NODE_7736_length_322_cov_1.879518_g7607_i0 | PRJEB75017 | 7736 | 322 | 1.879518 | 6.05204796 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 7.139999999999999e-118 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g7607 | i0 | 91.131 | 99.3850931677019 | 327 | 21 | 100 | 8 | 1 | 322 | 2689 | 3012 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 32002 | 436 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 28858495 | 28858495 | PRJEB75017_P_NODE_17708_length_244_cov_0.912281_g17579_i0 | PRJEB75017 | 17708 | 244 | 0.912281 | 2.22596564 | root | 1 | Root_unresolved | Root_unresolved | 110 | 2.36e-27 | NR | MES1911029.1 | 1215613 | g17579 | i0 | 66.3 | 1.77049180327869 | 80 | 27 | 98.4 | 0 | 2 | 241 | 105 | 184 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 432 | 110 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30287351 | 30287351 | PRJEB75017_P_NODE_16612_length_246_cov_0.901734_g16483_i0 | PRJEB75017 | 16612 | 246 | 0.901734 | 2.21826564 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 4.61e-12 | NR | MES1908091.1 | 1215613 | g16483 | i0 | 36 | 2.68292682926829 | 75 | 46 | 91.5 | 1 | 20 | 244 | 17 | 89 | MES1908091.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 660 | 70.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);;