contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA770826" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 746847 | 746847 | PRJNA770826_P_NODE_18681_length_187_cov_1.601449_g18510_i0 | PRJNA770826 | 18681 | 187 | 1.601449 | 2.99470963 | Vavraia culicis | 103449 | Fungi | Fungi | 283 | 5.209999999999999e-72 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g18510 | i0 | 94.086 | 11.9839572192513 | 186 | 11 | 99 | 0 | 1 | 186 | 549 | 734 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 2241 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 3298054 | 3298054 | PRJNA770826_P_NODE_1583_length_679_cov_2.358730_g1435_i0 | PRJNA770826 | 1583 | 679 | 2.35873 | 16.0157767 | Fusasporis stethaprioni | 2777717 | Fungi | Fungi | 1072 | 0 | NTclustered | gi|1914073495|gb|MW077214.1| | 2777717 | g1435 | i0 | 95.294 | 97.2164948453608 | 680 | 24 | 99 | 6 | 4 | 679 | 506 | 1181 | Fusasporis stethaprioni strain 2018 small subunit ribosomal RNA gene, partial sequence | blastn | 66010 | 1072 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Fusasporis | Fusasporis stethaprioni | |||
| 3298175 | 3298175 | PRJNA770826_P_NODE_7503_length_300_cov_1.247012_g7332_i0 | PRJNA770826 | 7503 | 300 | 1.247012 | 3.741036 | Glugea plecoglossi | 40978 | Fungi | Fungi | 281 | 3.27e-71 | NTclustered | gi|1209747780|gb|KX814862.1| | 40978 | g7332 | i0 | 89.035 | 62.4666666666667 | 228 | 24 | 76 | 1 | 57 | 284 | 1314 | 1540 | Glugea plecoglossi small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 18740 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugea | Glugea plecoglossi | |||
| 4575147 | 4575147 | PRJNA770826_P_NODE_20464_length_179_cov_1.200000_g20293_i0 | PRJNA770826 | 20464 | 179 | 1.2 | 2.148 | Fusasporis stethaprioni | 2777717 | Fungi | Fungi | 233 | 5.0499999999999995e-57 | NTclustered | gi|1914073495|gb|MW077214.1| | 2777717 | g20293 | i0 | 90.449 | 79.2402234636871 | 178 | 16 | 99 | 1 | 1 | 178 | 347 | 523 | Fusasporis stethaprioni strain 2018 small subunit ribosomal RNA gene, partial sequence | blastn | 14184 | 233 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Fusasporis | Fusasporis stethaprioni | |||
| 10951075 | 10951075 | PRJNA770826_P_NODE_6669_length_322_cov_2.128205_g6498_i0 | PRJNA770826 | 6669 | 322 | 2.128205 | 6.8528201 | Pleistophora mulleri | 249366 | Fungi | Fungi | 462 | 1.18e-125 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g6498 | i0 | 93.269 | 30.7639751552795 | 312 | 19 | 96 | 2 | 1 | 310 | 3240 | 3551 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 9906 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 12686333 | 12686333 | PRJNA770826_P_NODE_2470_length_554_cov_2.205941_g2303_i0 | PRJNA770826 | 2470 | 554 | 2.205941 | 12.22091314 | Heterosporis | 157917 | Fungi | Fungi | 416 | 1.68e-111 | NTclustered | gi|448278452|gb|KC137548.1| | 1289055 | g2303 | i0 | 83.368 | 17.1083032490975 | 475 | 54 | 83 | 20 | 1 | 462 | 2287 | 2749 | Heterosporis sp. NBDP-2013a isolate MN/WAE small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 9478 | 416 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 17325198 | 17325198 | PRJNA770826_P_NODE_18154_length_190_cov_1.184397_g17983_i0 | PRJNA770826 | 18154 | 190 | 1.184397 | 2.2503543 | Pleistophora mulleri | 249366 | Fungi | Fungi | 296 | 6.83e-76 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g17983 | i0 | 94.764 | 57.1315789473684 | 191 | 8 | 100 | 2 | 1 | 190 | 3096 | 2907 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 10855 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 23699802 | 23699802 | PRJNA770826_P_NODE_15339_length_206_cov_1.324841_g15168_i0 | PRJNA770826 | 15339 | 206 | 1.324841 | 2.72917246 | Vavraia culicis | 103449 | Fungi | Fungi | 254 | 4.6e-63 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g15168 | i0 | 89.216 | 1.99029126213592 | 204 | 21 | 99 | 1 | 1 | 204 | 2367 | 2569 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 410 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis |
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);;