contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA976345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 947861 | 947861 | PRJNA976345_P_NODE_13821_length_458_cov_3.028369_g12246_i0 | PRJNA976345 | 13821 | 458 | 3.028369 | 13.86993002 | Rhizomucor miehei | 4839 | Fungi | Fungi | 819 | 0 | NTclustered | gi|225134684|gb|FJ345356.1| | 4839 | g12246 | i0 | 98.908 | 67.7401746724891 | 458 | 5 | 100 | 0 | 1 | 458 | 2300 | 2757 | Rhizomucor miehei strain ATCC 46345 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 | 31025 | 819 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor miehei | |
| 7325893 | 7325893 | PRJNA976345_P_NODE_168246_length_159_cov_2.306452_g166638_i0 | PRJNA976345 | 168246 | 159 | 2.306452 | 3.66725868 | Rhizophagus irregularis | 588596 | Fungi | Fungi | 56.5 | 0.001 | NTclustered | gi|2749802524|ref|XM_066141260.1| | 588596 | g166638 | i0 | 94.595 | 0.465408805031447 | 37 | 1 | 23 | 1 | 71 | 107 | 2280 | 2315 | Rhizophagus irregularis uncharacterized protein (OCT59_006431), partial mRNA | blastn | 74 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis | |
| 9876664 | 9876664 | PRJNA976345_P_NODE_42948_length_264_cov_1.318777_g41340_i0 | PRJNA976345 | 42948 | 264 | 1.318777 | 3.48157128 | Mucor velutinosus | 708070 | Fungi | Fungi | 65.8 | 3.1e-6 | NTclustered | gi|2724900017|ref|XM_064828484.1| | 708070 | g41340 | i0 | 95.238 | 0.159090909090909 | 42 | 1 | 16 | 1 | 20 | 61 | 919 | 959 | Mucor velutinosus AP-2 complex subunit beta (AP2B1), partial mRNA | blastn | 42 | 65.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor velutinosus | |
| 13701690 | 13701690 | PRJNA976345_P_NODE_16591_length_415_cov_4.423684_g15003_i0 | PRJNA976345 | 16591 | 415 | 4.423684 | 18.3582886 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 69.4 | 3.96e-7 | NTclustered | gi|2324053343|ref|XM_051531806.1| | 90255 | g15003 | i0 | 93.617 | 8.26987951807229 | 47 | 1 | 11 | 1 | 209 | 255 | 896 | 852 | Cokeromyces recurvatus uncharacterized protein (BX663DRAFT_558375), partial mRNA | blastn | 3432 | 69.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 18800232 | 18800232 | PRJNA976345_P_NODE_38135_length_277_cov_7.628099_g36528_i0 | PRJNA976345 | 38135 | 277 | 7.628099 | 21.12983423 | Rhizophagus irregularis | 588596 | Fungi | Fungi | 52.8 | 0.025 | NTclustered | gi|1409887710|ref|XM_025327943.1| | 588596 | g36528 | i0 | 100 | 0.101083032490975 | 28 | 0 | 10 | 0 | 131 | 158 | 3018 | 2991 | Rhizophagus irregularis uncharacterized protein (OCT59_015580), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis | |
| 21350198 | 21350198 | PRJNA976345_P_NODE_19157_length_385_cov_2.368571_g17562_i0 | PRJNA976345 | 19157 | 385 | 2.368571 | 9.11899835 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 99 | 4.65e-16 | NTclustered | gi|2324058839|ref|XM_051526445.1| | 90255 | g17562 | i0 | 95.161 | 0.161038961038961 | 62 | 3 | 16 | 0 | 287 | 348 | 3 | 64 | Cokeromyces recurvatus uncharacterized protein (BX663DRAFT_501159), mRNA | blastn | 62 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 21350625 | 21350625 | PRJNA976345_P_NODE_48017_length_251_cov_3.282407_g46409_i0 | PRJNA976345 | 48017 | 251 | 3.282407 | 8.23884157 | Mycotypha africana | 64632 | Fungi | Fungi | 52.8 | 0.023 | NTclustered | gi|2432555938|ref|XM_053078456.1| | 64632 | g46409 | i0 | 96.875 | 0.127490039840637 | 32 | 0 | 12 | 1 | 162 | 192 | 372 | 341 | Mycotypha africana kinase-like domain-containing protein (BDF20DRAFT_831513), partial mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 25493577 | 25493577 | PRJNA976345_P_NODE_158240_length_163_cov_1.554688_g156632_i0 | PRJNA976345 | 158240 | 163 | 1.554688 | 2.53414144 | Fungi | 4751 | Fungi | Fungi | 137 | 3.65e-28 | NTclustered | gi|2323768172|ref|XM_051559322.1| | 101098 | g156632 | i0 | 83.007 | 5.31901840490798 | 153 | 24 | 93 | 2 | 12 | 163 | 280 | 431 | Gamsiella multidivaricata 40s ribosomal protein S6 (BC939DRAFT_485875), partial mRNA | blastn | 867 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Gamsiella | Gamsiella multidivaricata |
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);;