contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA533114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5609220 | 5609220 | PRJNA533114_P_NODE_71005_length_285_cov_1.816038_g70753_i0 | PRJNA533114 | 71005 | 285 | 1.816038 | 5.1757083 | Vavraia culicis | 103449 | Fungi | Fungi | 326 | 1.4e-84 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g70753 | i0 | 87.413 | 14.3333333333333 | 286 | 32 | 99 | 4 | 1 | 284 | 933 | 1216 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 4085 | 326 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 11983472 | 11983472 | PRJNA533114_P_NODE_19510_length_512_cov_1.911162_g19261_i0 | PRJNA533114 | 19510 | 512 | 1.911162 | 9.78514944 | Nematocida homosporus | 1912981 | Fungi | Fungi | 58.4 | 0.001 | NTclustered | gi|2324166807|ref|XM_051490623.1| | 1912981 | g19261 | i0 | 100 | 2.2578125 | 31 | 0 | 6 | 0 | 443 | 473 | 326 | 356 | Nematocida homosporus uncharacterized protein (NEHOM01_1745), partial mRNA | blastn | 1156 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida homosporus | ||||
| 13258653 | 13258653 | PRJNA533114_P_NODE_26911_length_439_cov_1.989071_g26659_i0 | PRJNA533114 | 26911 | 439 | 1.989071 | 8.73202169 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 806 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g26659 | i0 | 99.772 | 98.5148063781321 | 438 | 1 | 99 | 0 | 2 | 439 | 832 | 395 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 43248 | 806 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 14533627 | 14533627 | PRJNA533114_P_NODE_22712_length_476_cov_1.414392_g22462_i0 | PRJNA533114 | 22712 | 476 | 1.414392 | 6.73250592 | Vittaforma corneae | 42399 | Fungi | Fungi | 62.1 | 7.7e-5 | NTclustered | gi|667639104|ref|XM_007603809.1| | 993615 | g22462 | i0 | 83.824 | 0.388655462184874 | 68 | 8 | 14 | 2 | 8 | 72 | 461 | 394 | Vittaforma corneae ATCC 50505 AUR protein kinase (VICG_00418), partial mRNA | blastn | 185 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 15807690 | 15807690 | PRJNA533114_P_NODE_36673_length_381_cov_0.850649_g36421_i0 | PRJNA533114 | 36673 | 381 | 0.850649 | 3.24097269 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 684 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g36421 | i0 | 98.95 | 96.1154855643045 | 381 | 4 | 100 | 0 | 1 | 381 | 37 | 417 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 36620 | 684 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 17081998 | 17081998 | PRJNA533114_P_NODE_14554_length_593_cov_4.478846_g14309_i0 | PRJNA533114 | 14554 | 593 | 4.478846 | 26.55955678 | Nematocida displodere | 1805483 | Fungi | Fungi | 56.5 | 0.005 | NTclustered | gi|2797489297|ref|XM_067688031.1| | 1805483 | g14309 | i0 | 100 | 0.0505902192242833 | 30 | 0 | 5 | 0 | 447 | 476 | 1828 | 1799 | Nematocida displodere uncharacterized protein (NEDG_00613), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida displodere |
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);;