contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA263496" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10573323 | 10573323 | PRJNA263496_P_NODE_20749_length_168_cov_1.714286_g20496_i0 | PRJNA263496 | 20749 | 168 | 1.714286 | 2.88000048 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 311 | 2.11e-80 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g20496 | i0 | 100 | 73.7321428571429 | 168 | 0 | 100 | 0 | 1 | 168 | 1322 | 1155 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 12387 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 13123418 | 13123418 | PRJNA263496_P_NODE_8011_length_282_cov_2.175966_g7758_i0 | PRJNA263496 | 8011 | 282 | 2.175966 | 6.13622412 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 518 | 2.13e-142 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g7758 | i0 | 99.645 | 98.0567375886525 | 282 | 1 | 100 | 0 | 1 | 282 | 303 | 22 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 27652 | 518 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 16946734 | 16946734 | PRJNA263496_P_NODE_24674_length_162_cov_0.902655_g24421_i0 | PRJNA263496 | 24674 | 162 | 0.902655 | 1.4623011 | Glugoides intestinalis | 174680 | Fungi | Fungi | 143 | 7.78e-30 | NTclustered | gi|113470857|gb|DQ680158.2| | 174680 | g24421 | i0 | 91.429 | 3.82716049382716 | 105 | 7 | 65 | 2 | 52 | 156 | 335 | 233 | Glugoides intestinalis isolate Gi3 23S ribosomal RNA gene, partial sequence; 23S-16S ribosomal RNA spacer, complete sequence; and 16S ribosomal RNA gene, partial sequence | blastn | 620 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugoides | Glugoides intestinalis | |||
| 20771131 | 20771131 | PRJNA263496_P_NODE_9277_length_260_cov_0.966825_g9024_i0 | PRJNA263496 | 9277 | 260 | 0.966825 | 2.513745 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 477 | 3.3e-130 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g9024 | i0 | 99.615 | 86.3615384615385 | 260 | 1 | 100 | 0 | 1 | 260 | 514 | 773 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 22454 | 477 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 21458947 | 21458947 | PRJNA263496_P_NODE_14297_length_206_cov_2.872611_g14044_i0 | PRJNA263496 | 14297 | 206 | 2.872611 | 5.91757866 | Enterocytozoonidae | 27970 | Fungi | Fungi | 255 | 1.28e-63 | NTclustered | gi|1023344233|gb|KU198278.1| | 546761 | g14044 | i0 | 89.655 | 97.8252427184466 | 203 | 18 | 99 | 3 | 4 | 206 | 314 | 115 | Uncultured Enterocytozoonidae isolate EHPAAHL01 small subunit ribosomal RNA gene, partial sequence | blastn | 20152 | 257 | 0.992217898832685 | Eukaryota | Opisthokonta | Fungi | Microsporidia | uncultured Enterocytozoonidae | |||||
| 22045683 | 22045683 | PRJNA263496_P_NODE_14018_length_209_cov_0.987500_g13765_i0 | PRJNA263496 | 14018 | 209 | 0.9875 | 2.063875 | Obruspora papernae | 1341930 | Fungi | Fungi | 147 | 8.169999999999998e-31 | NTclustered | gi|573008413|emb|HG005137.1| | 1341930 | g13765 | i0 | 86.029 | 0.650717703349282 | 136 | 19 | 65 | 0 | 74 | 209 | 1479 | 1614 | Obruspora papernae 16S rRNA gene (partial), ITS and 23S rRNA gene (partial), individual 1 | blastn | 136 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Obruspora | Obruspora papernae | |||
| 22045816 | 22045816 | PRJNA263496_P_NODE_18478_length_180_cov_2.526718_g18225_i0 | PRJNA263496 | 18478 | 180 | 2.526718 | 4.5480924 | Vavraia culicis | 103449 | Fungi | Fungi | 239 | 1.09e-58 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g18225 | i0 | 92.727 | 15.2166666666667 | 165 | 12 | 92 | 0 | 4 | 168 | 884 | 1048 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 2739 | 239 | 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);;