contig_metadata
8 rows where analysis = "blastn", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
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);;