contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA188516" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6743482 | 6743482 | PRJNA188516_P_NODE_3826_length_173_cov_1.258065_g3776_i0 | PRJNA188516 | 3826 | 173 | 1.258065 | 2.17645245 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 119 | 1.4100000000000001e-22 | NTclustered | gi|2324052953|ref|XM_051525900.1| | 90255 | g3776 | i0 | 87.5 | 0.601156069364162 | 104 | 11 | 60 | 2 | 69 | 171 | 608 | 506 | Cokeromyces recurvatus uncharacterized protein (BX663DRAFT_497341), partial mRNA | blastn | 104 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 10569831 | 10569831 | PRJNA188516_P_NODE_1549_length_290_cov_1.481328_g1499_i0 | PRJNA188516 | 1549 | 290 | 1.481328 | 4.2958512 | Rhizopus microsporus | 58291 | Fungi | Fungi | 217 | 9e-52 | NTclustered | gi|1331189772|ref|XM_023607192.1| | 1340429 | g1499 | i0 | 84.977 | 19.8758620689655 | 213 | 32 | 73 | 0 | 1 | 213 | 209 | 421 | Rhizopus microsporus ATCC 52813 uncharacterized protein (RHIMIDRAFT_211203), mRNA | blastn | 5764 | 217 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 14394906 | 14394906 | PRJNA188516_P_NODE_4592_length_167_cov_0.881356_g4542_i0 | PRJNA188516 | 4592 | 167 | 0.881356 | 1.47186452 | Radiomyces spectabilis | 64574 | Fungi | Fungi | 169 | 1.33e-37 | NTclustered | gi|2323733830|ref|XM_051572657.1| | 64574 | g4542 | i0 | 85.119 | 6.35329341317365 | 168 | 21 | 99 | 4 | 1 | 166 | 313 | 148 | Radiomyces spectabilis ribosomal S17-domain-containing protein (BYT42DRAFT_645550), partial mRNA | blastn | 1061 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 19491829 | 19491829 | PRJNA188516_P_NODE_5856_length_163_cov_0.912281_g5806_i0 | PRJNA188516 | 5856 | 163 | 0.912281 | 1.48701803 | Rhizophagus irregularis | 588596 | Fungi | Fungi | 82.4 | 1.73e-11 | NTclustered | gi|2749812207|ref|XM_025310519.2| | 588596 | g5806 | i0 | 80.769 | 0.895705521472393 | 104 | 20 | 64 | 0 | 60 | 163 | 627 | 730 | Rhizophagus irregularis uncharacterized protein (OCT59_013130), partial mRNA | blastn | 146 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis |
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);;