contig_metadata
5 rows where bioproject = "PRJEB36940", tax_kingdom = "Fungi" and tax_phylum = "Microsporidia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6435002 | 6435002 | PRJEB36940_P_NODE_3706_length_442_cov_1.414634_g3577_i0 | PRJEB36940 | 3706 | 442 | 1.414634 | 6.25268228 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 120 | 2.05e-28 | NR | XP_013238610.1 | 1485682 | g3577 | i0 | 68.6 | 4.60180995475113 | 86 | 24 | 56.3 | 1 | 249 | 1 | 57 | 142 | XP_013238610.1 uncharacterized protein DI09_1p330 [Mitosporidium daphniae] | diamond | 2034 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 27500906 | 27500906 | PRJEB36940_P_NODE_7483_length_316_cov_1.596708_g7354_i0 | PRJEB36940 | 7483 | 316 | 1.596708 | 5.04559728 | Nematocida | 586132 | Fungi | Fungi | 159 | 1.5e-42 | NR | OAG31464.1 | 1805481 | g7354 | i0 | 69.5 | 4.98417721518987 | 105 | 32 | 99.7 | 0 | 316 | 2 | 87 | 191 | OAG31464.1 isoleucyl-tRNA synthetase [Nematocida sp. ERTm5] | diamond | 1575 | 160 | 0.99375 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. ERTm5 | ||||
| 29717204 | 29717204 | PRJEB36940_P_NODE_15970_length_242_cov_0.917160_g15841_i0 | PRJEB36940 | 15970 | 242 | 0.91716 | 2.2195272 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 50.1 | 5.17e-5 | NR | XP_013237468.1 | 1485682 | g15841 | i0 | 42.6 | 3.11157024793388 | 61 | 34 | 74.4 | 1 | 180 | 1 | 47 | 107 | XP_013237468.1 RNA recognition motif RNP 1 [Mitosporidium daphniae] | diamond | 753 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 32246622 | 32246622 | PRJEB36940_P_NODE_6698_length_333_cov_1.511538_g6569_i0 | PRJEB36940 | 6698 | 333 | 1.511538 | 5.03342154 | Edhazardia aedis USNM 41457 | 1003232 | Fungi | Fungi | 44.3 | 0.0264 | NR | EJW01629.1 | 1003232 | g6569 | i0 | 57.9 | 0.342342342342342 | 38 | 15 | 34.2 | 1 | 115 | 2 | 2 | 38 | EJW01629.1 hypothetical protein EDEG_03832 [Edhazardia aedis USNM 41457] | diamond | 114 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Culicosporidae | Edhazardia | Edhazardia aedis | |||
| 32681830 | 32681830 | PRJEB36940_P_NODE_8840_length_292_cov_1.063927_g8711_i0 | PRJEB36940 | 8840 | 292 | 1.063927 | 3.10666684 | Nosematidae | 27974 | Fungi | Fungi | 49.3 | 1.98e-4 | NR | KAF9764799.1 | 83296 | g8711 | i0 | 47.1 | 3.67808219178082 | 51 | 27 | 52.4 | 0 | 10 | 162 | 134 | 184 | KAF9764799.1 Transforming protein RhoA [Nosema granulosis] | diamond | 1074 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis |
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);;