contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJEB29441" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6091281 | 6091281 | PRJEB29441_P_NODE_12225_length_318_cov_3.977695_g11784_i0 | PRJEB29441 | 12225 | 318 | 3.977695 | 12.6490701 | Mucor | 4830 | Fungi | Fungi | 588 | 1.84e-163 | NTclustered | gi|37786673|gb|AY213712.1| | 4841 | g11784 | i0 | 100 | 99.8647798742138 | 318 | 0 | 100 | 0 | 1 | 318 | 700 | 383 | Mucor racemosus strain UWFP 788 28S ribosomal RNA gene, partial sequence | blastn | 31757 | 588 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus | |
| 6404694 | 6404694 | PRJEB29441_P_NODE_26266_length_205_cov_1.307692_g25825_i0 | PRJEB29441 | 26266 | 205 | 1.307692 | 2.6807686 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 145 | 2.8699999999999997e-30 | NTclustered | gi|2324061888|ref|XM_051531209.1| | 90255 | g25825 | i0 | 84.106 | 70.4 | 151 | 22 | 73 | 2 | 1 | 150 | 511 | 660 | Cokeromyces recurvatus 60S ribosomal protein L2 (BX663DRAFT_550341), partial mRNA | blastn | 14432 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 7678880 | 7678880 | PRJEB29441_P_NODE_35167_length_176_cov_1.606299_g34726_i0 | PRJEB29441 | 35167 | 176 | 1.606299 | 2.82708624 | Mycotypha africana | 64632 | Fungi | Fungi | 126 | 8.63e-25 | NTclustered | gi|2432561609|ref|XM_053077210.1| | 64632 | g34726 | i0 | 80.233 | 30.9659090909091 | 172 | 30 | 97 | 4 | 5 | 174 | 377 | 208 | Mycotypha africana 40S ribosomal protein S16 (BDF20DRAFT_816965), partial mRNA | blastn | 5450 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 8641343 | 8641343 | PRJEB29441_P_NODE_16227_length_269_cov_1.913636_g15786_i0 | PRJEB29441 | 16227 | 269 | 1.913636 | 5.14768084 | Fungi | 4751 | Fungi | Fungi | 497 | 2.63e-136 | NTclustered | gi|358001175|gb|JN938898.1| | 4841 | g15786 | i0 | 100 | 99.7063197026022 | 269 | 0 | 100 | 0 | 1 | 269 | 276 | 8 | Mucor racemosus strain DAOM 229663 28S ribosomal RNA (LSU) gene, partial sequence | blastn | 26821 | 497 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus | |
| 11504756 | 11504756 | PRJEB29441_P_NODE_36530_length_172_cov_2.439024_g36089_i0 | PRJEB29441 | 36530 | 172 | 2.439024 | 4.19512128 | Mucor velutinosus | 708070 | Fungi | Fungi | 119 | 1.4000000000000002e-22 | NTclustered | gi|2724936175|ref|XM_064825295.1| | 708070 | g36089 | i0 | 79.651 | 70.8662790697674 | 172 | 30 | 99 | 3 | 1 | 171 | 702 | 535 | Mucor velutinosus uncharacterized protein (ATC70_006013), partial mRNA | blastn | 12189 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor velutinosus | |
| 13741778 | 13741778 | PRJEB29441_P_NODE_34931_length_177_cov_1.062500_g34490_i0 | PRJEB29441 | 34931 | 177 | 1.0625 | 1.880625 | Eukaryota | 2759 | Fungi | Fungi | 150 | 5.149999999999999e-32 | NTclustered | gi|2323715713|ref|XM_051567416.1| | 64574 | g34490 | i0 | 83.851 | 20.7062146892655 | 161 | 23 | 90 | 3 | 19 | 177 | 360 | 201 | Radiomyces spectabilis 40S ribosomal protein S23 (BYT42DRAFT_561967), mRNA | blastn | 3665 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 16603161 | 16603161 | PRJEB29441_P_NODE_18474_length_249_cov_4.090000_g18033_i0 | PRJEB29441 | 18474 | 249 | 4.09 | 10.1841 | Mucor racemosus | 4841 | Fungi | Fungi | 460 | 3.16e-125 | NTclustered | gi|225134681|gb|FJ345353.1| | 4841 | g18033 | i0 | 100 | 46.281124497992 | 249 | 0 | 100 | 0 | 1 | 249 | 3997 | 3749 | Mucor racemosus strain ATCC 42647 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 11524 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus | |
| 17878292 | 17878292 | PRJEB29441_P_NODE_36695_length_172_cov_1.577236_g36254_i0 | PRJEB29441 | 36695 | 172 | 1.577236 | 2.71284592 | Gongronella sp. w5 | 483437 | Fungi | Fungi | 307 | 2.79e-79 | NTclustered | gi|2301278552|ref|NC_066217.1| | 483437 | g36254 | i0 | 98.837 | 48.2441860465116 | 172 | 2 | 100 | 0 | 1 | 172 | 684 | 513 | Gongronella sp. w5 culture CCTCC:AF 2012004 mitochondrion, complete genome | blastn | 8298 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Gongronella | Gongronella sp. w5 | |
| 21390306 | 21390306 | PRJEB29441_P_NODE_10197_length_354_cov_1.632787_g9756_i0 | PRJEB29441 | 10197 | 354 | 1.632787 | 5.78006598 | Mucor | 4830 | Fungi | Fungi | 643 | 4.3399999999999985e-180 | NTclustered | gi|168378|gb|M26190.1|MRARRHA | 4841 | g9756 | i0 | 99.435 | 101.550847457627 | 354 | 2 | 100 | 0 | 1 | 354 | 1796 | 2149 | M.racemosus (Zygomycetes) 25S ribosomal RNA gene | blastn | 35949 | 643 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus | |
| 21703312 | 21703312 | PRJEB29441_P_NODE_31478_length_186_cov_6.029197_g31037_i0 | PRJEB29441 | 31478 | 186 | 6.029197 | 11.21430642 | Mucor racemosus | 4841 | Fungi | Fungi | 316 | 5.11e-82 | NTclustered | gi|225134681|gb|FJ345353.1| | 4841 | g31037 | i0 | 97.826 | 11.2365591397849 | 184 | 2 | 99 | 2 | 1 | 184 | 2169 | 2350 | Mucor racemosus strain ATCC 42647 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 2090 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus | |
| 23940551 | 23940551 | PRJEB29441_P_NODE_19839_length_239_cov_3.178947_g19398_i0 | PRJEB29441 | 19839 | 239 | 3.178947 | 7.59768333 | Fungi | 4751 | Fungi | Fungi | 431 | 2.3599999999999996e-116 | NTclustered | gi|908373098|gb|JF723682.2| | 4841 | g19398 | i0 | 99.163 | 100 | 239 | 2 | 100 | 0 | 1 | 239 | 709 | 947 | Mucor racemosus strain LMSA 1.09.217 18S ribosomal RNA gene, partial sequence | blastn | 23900 | 431 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus |
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);;