contig_metadata
5 rows where bioproject = "PRJNA1180292", tax_clade = "Discoba" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13071513 | 13071513 | PRJNA1180292_P_NODE_6891_length_269_cov_1.193878_g6759_i0 | PRJNA1180292 | 6891 | 269 | 1.193878 | 3.21153182 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 87.4 | 9.89e-18 | NR | XP_015664491.1 | 157538 | g6759 | i0 | 50 | 2.73234200743494 | 80 | 40 | 89.2 | 0 | 267 | 28 | 705 | 784 | XP_015664491.1 putative threonyl-tRNA synthetase [Leptomonas pyrrhocoris] | diamond | 735 | 87.8 | 0.995444191343964 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 14346929 | 14346929 | PRJNA1180292_P_NODE_6132_length_283_cov_1.461905_g6000_i0 | PRJNA1180292 | 6132 | 283 | 1.461905 | 4.13719115 | Rhynchobodo sp. Hamilton Lake | 266815 | Euglenozoa | other_Eukaryota | 425 | 1.34e-114 | NTclustered | gi|45739055|gb|AY490213.1| | 266815 | g6000 | i0 | 93.706 | 98.3710247349823 | 286 | 14 | 100 | 4 | 1 | 283 | 408 | 124 | Rhynchobodo sp. Hamilton Lake 18S ribosomal RNA gene, partial sequence | blastn | 27839 | 425 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Rhynchobodo | Rhynchobodo sp. Hamilton Lake | |||
| 29207313 | 29207313 | PRJNA1180292_P_NODE_4229_length_336_cov_1.186312_g4097_i0 | PRJNA1180292 | 4229 | 336 | 1.186312 | 3.98600832 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 108 | 2.8400000000000003e-27 | NR | XP_044557709.1 | 5763 | g4097 | i0 | 54.1 | 4.51785714285714 | 111 | 49 | 99.1 | 1 | 335 | 3 | 41 | 149 | XP_044557709.1 uncharacterized protein FDP41_008660 [Naegleria fowleri] | diamond | 1518 | 108 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29851185 | 29851185 | PRJNA1180292_P_NODE_2431_length_436_cov_2.366391_g2299_i0 | PRJNA1180292 | 2431 | 436 | 2.366391 | 10.31746476 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 100 | 7.88e-24 | NR | KAL0487807.1 | 1008807 | g2299 | i0 | 56.4 | 0.536697247706422 | 78 | 34 | 53.7 | 0 | 241 | 8 | 2 | 79 | KAL0487807.1 helicase with zinc finger domain [Acrasis kona] | diamond | 234 | 100 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32253886 | 32253886 | PRJNA1180292_P_NODE_9598_length_249_cov_1.187500_g9466_i0 | PRJNA1180292 | 9598 | 249 | 1.1875 | 2.956875 | Andalucia godoyi | 505711 | Root_unresolved | Root_unresolved | 55.1 | 1.76e-6 | NR | KAF0852990.1 | 505711 | g9466 | i0 | 62.9 | 1.2289156626506 | 35 | 13 | 42.2 | 0 | 106 | 2 | 11 | 45 | KAF0852990.1 mitochondrial Hsp60 (chaperonin GroEL) [Andalucia godoyi] | diamond | 306 | 55.1 | 1 | Eukaryota | Discoba | Jakobida | Andaluciidae | Andalucia | Andalucia godoyi |
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);;