contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2684916 | 2684916 | PRJEB66218_P_NODE_98443_length_309_cov_4.471774_g96015_i0 | PRJEB66218 | 98443 | 309 | 4.471774 | 13.81778166 | Pleistophora mulleri | 249366 | Fungi | Fungi | 425 | 1.48e-114 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g96015 | i0 | 91.318 | 25.1359223300971 | 311 | 24 | 99 | 3 | 2 | 309 | 3593 | 3283 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 7767 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 10337611 | 10337611 | PRJEB66218_P_NODE_88289_length_331_cov_6.025926_g85862_i0 | PRJEB66218 | 88289 | 331 | 6.025926 | 19.94581506 | Ovipleistophora diplostomuri | 2023159 | Fungi | Fungi | 442 | 1.5799999999999993e-119 | NTclustered | gi|2017842943|gb|MW811107.1| | 2023159 | g85862 | i0 | 90.801 | 24.3655589123867 | 337 | 22 | 100 | 8 | 1 | 331 | 1245 | 1578 | Ovipleistophora diplostomuri isolate 15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 8065 | 442 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Ovipleistophora | Ovipleistophora diplostomuri | |||
| 15433316 | 15433316 | PRJEB66218_P_NODE_126213_length_266_cov_4.946341_g123784_i0 | PRJEB66218 | 126213 | 266 | 4.946341 | 13.15726706 | Vavraia culicis | 103449 | Fungi | Fungi | 291 | 4.74e-74 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g123784 | i0 | 86.667 | 27.6616541353383 | 270 | 26 | 100 | 7 | 1 | 266 | 659 | 396 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 7358 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 17982661 | 17982661 | PRJEB66218_P_NODE_134655_length_256_cov_20.635897_g132226_i0 | PRJEB66218 | 134655 | 256 | 20.635897 | 52.82789632 | Vavraia culicis | 103449 | Fungi | Fungi | 305 | 1.62e-78 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g132226 | i0 | 88.281 | 2 | 256 | 29 | 100 | 1 | 1 | 256 | 2634 | 2380 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 512 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 21808890 | 21808890 | PRJEB66218_P_NODE_19558_length_893_cov_19.365385_g17517_i0 | PRJEB66218 | 19558 | 893 | 19.365385 | 172.93288805 | Heterosporis sp. NBDP-2013a | 1289055 | Fungi | Fungi | 75 | 1.92e-8 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g17517 | i0 | 95.652 | 0.105263157894737 | 46 | 2 | 5 | 0 | 561 | 606 | 2917 | 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 | 94 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 25220276 | 25220276 | PRJEB66218_P_NODE_131160_length_260_cov_3.768844_g128731_i0 | PRJEB66218 | 131160 | 260 | 3.768844 | 9.7989944 | Glugeidae | 36735 | Fungi | Fungi | 424 | 4.36e-114 | NTclustered | gi|7161819|emb|AJ252951.1| | 103443 | g128731 | i0 | 96.85 | 96.6923076923077 | 254 | 7 | 97 | 1 | 8 | 260 | 556 | 809 | Loma acerinae 16S rRNA gene | blastn | 25140 | 425 | 0.997647058823529 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Loma | Loma acerinae |
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);;