contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA326068" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4216754 | 4216754 | PRJNA326068_P_NODE_6364_length_432_cov_2.364764_g5461_i0 | PRJNA326068 | 6364 | 432 | 2.364764 | 10.21578048 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 789 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g5461 | i0 | 99.538 | 97.1087962962963 | 433 | 1 | 100 | 1 | 1 | 432 | 1519 | 1951 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 41951 | 789 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 6767031 | 6767031 | PRJNA326068_P_NODE_17146_length_196_cov_3.017964_g16183_i0 | PRJNA326068 | 17146 | 196 | 3.017964 | 5.91520944 | Pleistophora mulleri | 249366 | Fungi | Fungi | 324 | 3.25e-84 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g16183 | i0 | 96.447 | 54.3316326530612 | 197 | 5 | 100 | 2 | 1 | 196 | 2908 | 3103 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 10649 | 324 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 13822624 | 13822624 | PRJNA326068_P_NODE_1471_length_876_cov_3.299882_g1073_i0 | PRJNA326068 | 1471 | 876 | 3.299882 | 28.90696632 | Pleistophoridae | 35232 | Fungi | Fungi | 811 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g1073 | i0 | 83.632 | 22.8767123287671 | 892 | 106 | 99 | 32 | 6 | 876 | 1881 | 2753 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 20040 | 815 | 0.995092024539877 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 13822657 | 13822657 | PRJNA326068_P_NODE_8991_length_343_cov_2.337580_g8037_i0 | PRJNA326068 | 8991 | 343 | 2.33758 | 8.0178994 | Heterosporis | 157917 | Fungi | Fungi | 311 | 4.85e-80 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g8037 | i0 | 94.527 | 6.45189504373178 | 201 | 11 | 59 | 0 | 1 | 201 | 3612 | 3412 | 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 | 2213 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 15097023 | 15097023 | PRJNA326068_P_NODE_1472_length_876_cov_3.214876_g1073_i1 | PRJNA326068 | 1472 | 876 | 3.214876 | 28.16231376 | Pleistophoridae | 35232 | Fungi | Fungi | 817 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g1073 | i1 | 83.744 | 22.8595890410959 | 892 | 105 | 99 | 32 | 1 | 871 | 2753 | 1881 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 20025 | 817 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 16966801 | 16966801 | PRJNA326068_P_NODE_494_length_1342_cov_6.945164_g332_i0 | PRJNA326068 | 494 | 1342 | 6.945164 | 93.20410088 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 2446 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g332 | i0 | 99.775 | 92.0506706408346 | 1331 | 3 | 99 | 0 | 1 | 1331 | 22 | 1352 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 123532 | 2446 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia |
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);;