contig_metadata
7 rows where bioproject = "PRJNA928559", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3454136 | 3454136 | PRJNA928559_P_NODE_195883_length_249_cov_3.920455_g194314_i0 | PRJNA928559 | 195883 | 249 | 3.920455 | 9.76193295 | Heterosporis sp. NBDP-2013a | 1289055 | Fungi | Fungi | 67.6 | 8.05e-7 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g194314 | i0 | 95.238 | 0.168674698795181 | 42 | 2 | 17 | 0 | 1 | 42 | 2921 | 2962 | Heterosporis sp. NBDP-2013a isolate MN/CISCO small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 42 | 67.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 5081298 | 5081298 | PRJNA928559_P_NODE_213104_length_242_cov_6.804734_g211535_i0 | PRJNA928559 | 213104 | 242 | 6.804734 | 16.46745628 | Pleistophoridae | 35232 | Fungi | Fungi | 82.4 | 2.78e-11 | NTclustered | gi|2017842940|gb|MW811106.1| | 103445 | g211535 | i0 | 97.872 | 3.90495867768595 | 47 | 1 | 19 | 0 | 24 | 70 | 2113 | 2159 | Ovipleistophora ovariae isolate 2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 945 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Ovipleistophora | Ovipleistophora ovariae | |||
| 7282140 | 7282140 | PRJNA928559_P_NODE_48046_length_492_cov_3.126492_g46484_i0 | PRJNA928559 | 48046 | 492 | 3.126492 | 15.38234064 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 198 | 2.99e-62 | NR | XP_013239437.1 | 1485682 | g46484 | i0 | 75.8 | 4.53658536585366 | 124 | 30 | 75.6 | 0 | 490 | 119 | 24 | 147 | XP_013239437.1 40S ribosomal protein S16 [Mitosporidium daphniae] | diamond | 2232 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 27150845 | 27150845 | PRJNA928559_P_NODE_96282_length_363_cov_2.448276_g94713_i0 | PRJNA928559 | 96282 | 363 | 2.448276 | 8.88724188 | Nosema granulosis | 83296 | Fungi | Fungi | 46.6 | 0.00363 | NR | KAF9764698.1 | 83296 | g94713 | i0 | 27.2 | 0.669421487603306 | 81 | 59 | 66.9 | 0 | 3 | 245 | 80 | 160 | KAF9764698.1 Ras-related protein Rab-5A [Nosema granulosis] | diamond | 243 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis | |||
| 28603937 | 28603937 | PRJNA928559_P_NODE_178947_length_260_cov_1.508021_g177378_i0 | PRJNA928559 | 178947 | 260 | 1.508021 | 3.9208546 | Amphiamblys sp. WSBS2 | 1866961 | Fungi | Fungi | 72.4 | 2.16e-13 | NR | OIR57166.1 | 1866961 | g177378 | i0 | 50 | 3.54230769230769 | 82 | 38 | 94.6 | 2 | 260 | 15 | 82 | 160 | OIR57166.1 MAG: small COPII coat GTPase Sar1 [Amphiamblys sp. WSBS2006] | diamond | 921 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Amphiacanthidae | Amphiamblys | Amphiamblys sp. WSBS2006 | |||
| 30126556 | 30126556 | PRJNA928559_P_NODE_92792_length_370_cov_1.218855_g91223_i0 | PRJNA928559 | 92792 | 370 | 1.218855 | 4.5097635 | Fungi | 4751 | Fungi | Fungi | 45.1 | 0.021 | NR | XP_013239055.1 | 1485682 | g91223 | i0 | 28.6 | 1.28108108108108 | 91 | 56 | 73.8 | 1 | 93 | 365 | 103 | 184 | XP_013239055.1 uncharacterized protein DI09_14p110 [Mitosporidium daphniae] | diamond | 474 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 30593436 | 30593436 | PRJNA928559_P_NODE_192033_length_251_cov_1.528090_g190464_i0 | PRJNA928559 | 192033 | 251 | 1.52809 | 3.8355059 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 54.7 | 2.17e-6 | NR | KAG0433372.1 | 279532 | g190464 | i0 | 46.4 | 1.35059760956175 | 56 | 28 | 66.9 | 1 | 177 | 10 | 166 | 219 | KAG0433372.1 Deoxyhypusine hydroxylase [Dictyocoela muelleri] | diamond | 339 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri |
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);;