contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7251036 | 7251036 | PRJNA896758_P_NODE_5866_length_470_cov_1.143577_g5477_i0 | PRJNA896758 | 5866 | 470 | 1.143577 | 5.3748119 | Pleistophora mulleri | 249366 | Fungi | Fungi | 399 | 1.4199999999999997e-106 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g5477 | i0 | 95.6 | 29.1446808510638 | 250 | 9 | 53 | 2 | 222 | 470 | 2842 | 3090 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 13698 | 399 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 12351824 | 12351824 | PRJNA896758_P_NODE_25150_length_244_cov_0.900585_g24760_i0 | PRJNA896758 | 25150 | 244 | 0.900585 | 2.1974274 | Ichthyosporidium weissii | 1172315 | Fungi | Fungi | 257 | 4.35e-64 | NTclustered | gi|384232434|gb|JQ062988.1| | 1172315 | g24760 | i0 | 90.306 | 80.7786885245902 | 196 | 19 | 80 | 0 | 1 | 196 | 1394 | 1589 | Ichthyosporidium weissii small subunit ribosomal RNA gene, partial sequence; small subunit rRNA-large subunit rRNA intergenic spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 19710 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Ichthyosporidium | Ichthyosporidium weissii | |||
| 13626664 | 13626664 | PRJNA896758_P_NODE_431_length_1648_cov_7.694603_g280_i0 | PRJNA896758 | 431 | 1648 | 7.694603 | 126.80705744 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 736 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g280 | i0 | 84.739 | 11.9375 | 747 | 100 | 93 | 14 | 8 | 747 | 1729 | 2468 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 19673 | 736 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 14900855 | 14900855 | PRJNA896758_P_NODE_7372_length_417_cov_2.238372_g6982_i0 | PRJNA896758 | 7372 | 417 | 2.238372 | 9.33401124 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 760 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g6982 | i0 | 99.52 | 97.2326139088729 | 417 | 1 | 99 | 1 | 2 | 417 | 1942 | 1526 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 40546 | 760 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 16175578 | 16175578 | PRJNA896758_P_NODE_20973_length_252_cov_1.290503_g20583_i0 | PRJNA896758 | 20973 | 252 | 1.290503 | 3.25206756 | Ordospora pajunii | 3039483 | Fungi | Fungi | 220 | 5.919999999999999e-53 | NTclustered | gi|2607439339|ref|XM_060421342.1| | 3039483 | g20583 | i0 | 84.821 | 2.1984126984127 | 224 | 28 | 88 | 6 | 31 | 251 | 1045 | 1265 | Ordospora pajunii MCMP-loop domain-containing protein (HK407_09g13800), partial mRNA | blastn | 554 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Ordosporidae | Ordospora | Ordospora pajunii | |||
| 18724250 | 18724250 | PRJNA896758_P_NODE_15395_length_291_cov_1.059633_g15005_i0 | PRJNA896758 | 15395 | 291 | 1.059633 | 3.08353203 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 534 | 2.1999999999999998e-147 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g15005 | i0 | 99.656 | 97.8384879725086 | 291 | 1 | 100 | 0 | 1 | 291 | 666 | 376 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 28471 | 534 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 22921583 | 22921583 | PRJNA896758_P_NODE_7758_length_407_cov_2.092814_g7368_i0 | PRJNA896758 | 7758 | 407 | 2.092814 | 8.51775298 | Pleistophoridae | 35232 | Fungi | Fungi | 466 | 1.18e-126 | NTclustered | gi|27448231|gb|AF387331.1| | 184033 | g7368 | i0 | 88 | 34.7788697788698 | 400 | 40 | 98 | 8 | 5 | 403 | 2304 | 1912 | Heterosporis anguillarum small subunit ribosomal RNA gene, internal transcribed spacer, and large subunit ribosomal RNA gene, complete sequence | blastn | 14155 | 466 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis anguillarum | |||
| 23825005 | 23825005 | PRJNA896758_P_NODE_21679_length_250_cov_0.870056_g21289_i0 | PRJNA896758 | 21679 | 250 | 0.870056 | 2.17514 | Microsporidium sp. BVER2 | 698263 | Fungi | Fungi | 361 | 3.31e-95 | NTclustered | gi|272477488|gb|FJ756170.1| | 698263 | g21289 | i0 | 92.857 | 99.672 | 252 | 13 | 100 | 5 | 1 | 250 | 268 | 20 | Microsporidium sp. BVER2 small subunit ribosomal RNA gene, partial sequence | blastn | 24918 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. BVER2 | ||||
| 25098792 | 25098792 | PRJNA896758_P_NODE_1440_length_966_cov_3.247480_g1131_i0 | PRJNA896758 | 1440 | 966 | 3.24748 | 31.3706568 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 1203 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g1131 | i0 | 89.231 | 88.7215320910973 | 975 | 88 | 99 | 13 | 3 | 966 | 1273 | 305 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 85705 | 1203 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei |
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);;