contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA453111" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4268498 | 4268498 | PRJNA453111_P_NODE_7004_length_306_cov_1.321888_g6912_i0 | PRJNA453111 | 7004 | 306 | 1.321888 | 4.04497728 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 342 | 1.5099999999999997e-89 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g6912 | i0 | 87.797 | 8.58496732026144 | 295 | 32 | 96 | 4 | 10 | 302 | 2248 | 1956 | 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 | 2627 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 5545152 | 5545152 | PRJNA453111_P_NODE_3005_length_470_cov_1.352645_g2913_i0 | PRJNA453111 | 3005 | 470 | 1.352645 | 6.3574315 | Ovipleistophora ovariae | 103445 | Fungi | Fungi | 545 | 1.7199999999999995e-150 | NTclustered | gi|13274171|emb|AJ278955.1| | 103445 | g2913 | i0 | 87.633 | 1.96382978723404 | 469 | 58 | 99 | 0 | 1 | 469 | 1260 | 792 | Pleistophora ovariae partial rpb1 gene for RNA polymerase II largest subunit | blastn | 923 | 545 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Ovipleistophora | Ovipleistophora ovariae | |||
| 8094590 | 8094590 | PRJNA453111_P_NODE_2827_length_487_cov_31.265700_g2735_i0 | PRJNA453111 | 2827 | 487 | 31.2657 | 152.263959 | Vavraia culicis | 103449 | Fungi | Fungi | 278 | 7.199999999999999e-70 | NTclustered | gi|667635644|ref|XM_008076914.1| | 948595 | g2735 | i0 | 78.054 | 0.907597535934292 | 442 | 95 | 91 | 2 | 31 | 471 | 465 | 25 | Vavraia culicis subsp. floridensis uncharacterized protein (VCUG_02091), partial mRNA | blastn | 442 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 9369298 | 9369298 | PRJNA453111_P_NODE_148_length_1748_cov_64.960597_g129_i0 | PRJNA453111 | 148 | 1748 | 64.960597 | 1135.51123556 | Ovipleistophora ovariae | 103445 | Fungi | Fungi | 2732 | 0 | NTclustered | gi|2017842940|gb|MW811106.1| | 103445 | g129 | i0 | 94.872 | 37.5446224256293 | 1755 | 78 | 100 | 7 | 1 | 1748 | 2321 | 572 | 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 | 65628 | 2732 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Ovipleistophora | Ovipleistophora ovariae | |||
| 11920239 | 11920239 | PRJNA453111_P_NODE_6730_length_312_cov_128.184100_g6638_i0 | PRJNA453111 | 6730 | 312 | 128.1841 | 399.934392 | Vavraia culicis | 103449 | Fungi | Fungi | 233 | 9.71e-57 | NTclustered | gi|667632012|ref|XM_008075098.1| | 948595 | g6638 | i0 | 80.707 | 1.14102564102564 | 311 | 51 | 98 | 8 | 1 | 306 | 143 | 449 | Vavraia culicis subsp. floridensis uncharacterized protein (VCUG_00269), mRNA | blastn | 356 | 233 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 17018793 | 17018793 | PRJNA453111_P_NODE_9994_length_251_cov_0.865169_g9902_i0 | PRJNA453111 | 9994 | 251 | 0.865169 | 2.17157419 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 329 | 9.38e-86 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g9902 | i0 | 90.272 | 16.9482071713147 | 257 | 18 | 100 | 5 | 1 | 251 | 3979 | 3724 | 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 | 4254 | 329 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 18944312 | 18944312 | PRJNA453111_P_NODE_315_length_1361_cov_48.815217_g279_i0 | PRJNA453111 | 315 | 1361 | 48.815217 | 664.37510337 | Pleistophora | 35233 | Fungi | Fungi | 2490 | 0 | NTclustered | gi|827529328|gb|KM458272.1| | 689837 | g279 | i0 | 99.706 | 95.5319617927994 | 1360 | 4 | 99 | 0 | 1 | 1360 | 9 | 1368 | 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 | 130019 | 2490 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora hyphessobryconis |
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);;