contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1068830" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1014062 | 1014062 | PRJNA1068830_P_NODE_21641_length_509_cov_4.077982_g20940_i0 | PRJNA1068830 | 21641 | 509 | 4.077982 | 20.75692838 | Pleistophora | 35233 | Fungi | Fungi | 941 | 0 | NTclustered | gi|264683451|gb|GU126672.1| | 689837 | g20940 | i0 | 100 | 99.1611001964637 | 509 | 0 | 100 | 0 | 1 | 509 | 850 | 1358 | Pleistophora hyphessobryconis 16S ribosomal RNA gene, partial sequence | blastn | 50473 | 941 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora hyphessobryconis | |||
| 1458089 | 1458089 | PRJNA1068830_P_NODE_70862_length_255_cov_3.763736_g70159_i0 | PRJNA1068830 | 70862 | 255 | 3.763736 | 9.5975268 | Vavraia culicis | 103449 | Fungi | Fungi | 291 | 4.509999999999999e-74 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g70159 | i0 | 88.142 | 10.6156862745098 | 253 | 18 | 97 | 9 | 9 | 255 | 486 | 732 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 2707 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 7835140 | 7835140 | PRJNA1068830_P_NODE_3647_length_1326_cov_171.399840_g3307_i0 | PRJNA1068830 | 3647 | 1326 | 171.39984 | 2272.7618784 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 2429 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g3307 | i0 | 99.698 | 92.8634992458522 | 1325 | 4 | 99 | 0 | 1 | 1325 | 11 | 1335 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 123137 | 2429 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 9110389 | 9110389 | PRJNA1068830_P_NODE_45788_length_325_cov_2.726190_g45085_i0 | PRJNA1068830 | 45788 | 325 | 2.72619 | 8.8601175 | Pleistophora hyphessobryconis | 689837 | Fungi | Fungi | 573 | 5.269999999999998e-159 | NTclustered | gi|827529328|gb|KM458272.1| | 689837 | g45085 | i0 | 99.06 | 40.24 | 319 | 3 | 98 | 0 | 1 | 319 | 1590 | 1908 | Pleistophora hyphessobryconis isolate HB1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 13078 | 573 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora hyphessobryconis | |||
| 15485146 | 15485146 | PRJNA1068830_P_NODE_29053_length_425_cov_2.133523_g28350_i0 | PRJNA1068830 | 29053 | 425 | 2.133523 | 9.06747275 | Fusasporis stethaprioni | 2777717 | Fungi | Fungi | 651 | 0 | NTclustered | gi|1914073495|gb|MW077214.1| | 2777717 | g28350 | i0 | 94.34 | 100.249411764706 | 424 | 24 | 99 | 0 | 2 | 425 | 642 | 219 | Fusasporis stethaprioni strain 2018 small subunit ribosomal RNA gene, partial sequence | blastn | 42606 | 651 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Fusasporis | Fusasporis stethaprioni | |||
| 15485286 | 15485286 | PRJNA1068830_P_NODE_34893_length_381_cov_1.857143_g34190_i0 | PRJNA1068830 | 34893 | 381 | 1.857143 | 7.07571483 | Ovipleistophora ovariae | 103445 | Fungi | Fungi | 604 | 2.219999999999999e-168 | NTclustered | gi|2017842940|gb|MW811106.1| | 103445 | g34190 | i0 | 95.276 | 30.1312335958005 | 381 | 18 | 100 | 0 | 1 | 381 | 2299 | 1919 | 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 | 11480 | 604 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Ovipleistophora | Ovipleistophora ovariae | |||
| 16759566 | 16759566 | PRJNA1068830_P_NODE_39234_length_356_cov_1.325088_g38531_i0 | PRJNA1068830 | 39234 | 356 | 1.325088 | 4.71731328 | Pleistophora mulleri | 249366 | Fungi | Fungi | 351 | 2.97e-92 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g38531 | i0 | 97.115 | 36.938202247191 | 208 | 6 | 58 | 0 | 149 | 356 | 2840 | 3047 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 13150 | 351 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 22690854 | 22690854 | PRJNA1068830_P_NODE_12478_length_703_cov_4.057143_g11813_i0 | PRJNA1068830 | 12478 | 703 | 4.057143 | 28.52171529 | Ovipleistophora | 157915 | Fungi | Fungi | 1160 | 0 | NTclustered | gi|2017842940|gb|MW811106.1| | 103445 | g11813 | i0 | 96.444 | 24.2574679943101 | 703 | 25 | 100 | 0 | 1 | 703 | 1754 | 1052 | 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 | 17053 | 1160 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Ovipleistophora | Ovipleistophora ovariae |
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);;