contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA915212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2170542 | 2170542 | PRJNA915212_P_NODE_3362_length_343_cov_1.918367_g3325_i0 | PRJNA915212 | 3362 | 343 | 1.918367 | 6.57999881 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 1.77e-69 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g3325 | i0 | 94.886 | 43.2069970845481 | 176 | 9 | 51 | 0 | 168 | 343 | 3839 | 3664 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 14820 | 276 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 16197983 | 16197983 | PRJNA915212_P_NODE_10533_length_177_cov_1.617188_g10495_i0 | PRJNA915212 | 10533 | 177 | 1.617188 | 2.86242276 | Thaumatomonas seravini | 188939 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 2.35e-45 | NTclustered | gi|160337323|gb|EF455755.1| | 188939 | g10495 | i0 | 86.782 | 97.8135593220339 | 174 | 23 | 98 | 0 | 2 | 175 | 784 | 611 | Thaumatomonas seravini actin gene, partial cds | blastn | 17313 | 195 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas seravini | ||
| 17473300 | 17473300 | PRJNA915212_P_NODE_12114_length_166_cov_1.307692_g12076_i0 | PRJNA915212 | 12114 | 166 | 1.307692 | 2.17076872 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 2.7099999999999998e-74 | NTclustered | gi|225216798|gb|FJ176713.1| | 458884 | g12076 | i0 | 98.193 | 98.6385542168675 | 166 | 3 | 100 | 0 | 1 | 166 | 201 | 36 | Bodomorpha sp. HFCC92 18S ribosomal RNA gene, partial sequence | blastn | 16374 | 291 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 17473337 | 17473337 | PRJNA915212_P_NODE_3234_length_352_cov_1.679868_g3197_i0 | PRJNA915212 | 3234 | 352 | 1.679868 | 5.91313536 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 1.32e-115 | NTclustered | gi|302026152|gb|GQ377656.1| | 646463 | g3197 | i0 | 88.636 | 99.8465909090909 | 352 | 40 | 100 | 0 | 1 | 352 | 85 | 436 | Gymnophrys sp. ATCC 50923 beta-tubulin (Btub) gene, partial cds | blastn | 35146 | 429 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 20021837 | 20021837 | PRJNA915212_P_NODE_4836_length_273_cov_1.352679_g4798_i0 | PRJNA915212 | 4836 | 273 | 1.352679 | 3.69281367 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 3.75e-80 | NTclustered | gi|1389527545|dbj|LC383945.1| | 1928728 | g4798 | i0 | 87.179 | 83.1868131868132 | 273 | 35 | 100 | 0 | 1 | 273 | 1071 | 799 | Paulinella micropora gene for actin, complete cds | blastn | 22710 | 311 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 20377336 | 20377336 | PRJNA915212_P_NODE_8756_length_197_cov_1.168919_g8718_i0 | PRJNA915212 | 8756 | 197 | 1.168919 | 2.30277043 | root | 1 | Root_unresolved | Root_unresolved | 204 | 4.449999999999999e-48 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g8718 | i0 | 99.115 | 58.8781725888325 | 113 | 1 | 57 | 0 | 1 | 113 | 2454 | 2342 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 11599 | 206 | 0.990291262135922 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 22572223 | 22572223 | PRJNA915212_P_NODE_4518_length_285_cov_1.131356_g4480_i0 | PRJNA915212 | 4518 | 285 | 1.131356 | 3.2243646 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.86e-68 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g4480 | i0 | 84.727 | 78.3017543859649 | 275 | 39 | 96 | 3 | 1 | 275 | 1273 | 1544 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 22316 | 272 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa |
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);;