contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1158727" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 305596 | 305596 | PRJNA1158727_P_NODE_49481_length_505_cov_4.585648_g42026_i0 | PRJNA1158727 | 49481 | 505 | 4.585648 | 23.1575224 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 291 | 9.609999999999999e-74 | NTclustered | gi|1069936519|ref|XM_018440025.1| | 763407 | g42026 | i0 | 82.883 | 61.3663366336634 | 333 | 48 | 65 | 6 | 158 | 487 | 135 | 461 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 30990 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 2857475 | 2857475 | PRJNA1158727_P_NODE_84963_length_326_cov_1.205534_g77502_i0 | PRJNA1158727 | 84963 | 326 | 1.205534 | 3.93004084 | Mycotypha africana | 64632 | Fungi | Fungi | 54.7 | 0.009 | NTclustered | gi|2432559541|ref|XM_053080147.1| | 64632 | g77502 | i0 | 96.97 | 0.101226993865031 | 33 | 0 | 10 | 1 | 194 | 226 | 789 | 758 | Mycotypha africana S-adenosyl-L-methionine-dependent methyltransferase (BDF20DRAFT_853692), mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 6681080 | 6681080 | PRJNA1158727_P_NODE_106646_length_283_cov_3.280952_g99185_i0 | PRJNA1158727 | 106646 | 283 | 3.280952 | 9.28509416 | Halteromyces radiatus | 101107 | Fungi | Fungi | 226 | 1.4499999999999998e-54 | NTclustered | gi|2323738033|ref|XM_051545656.1| | 101107 | g99185 | i0 | 81.919 | 5.7208480565371 | 271 | 45 | 95 | 4 | 1 | 269 | 269 | 1 | Halteromyces radiatus 60S ribosomal protein L10-A (BX664DRAFT_334155), partial mRNA | blastn | 1619 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus | |
| 11784138 | 11784138 | PRJNA1158727_P_NODE_45550_length_545_cov_2.252119_g38114_i0 | PRJNA1158727 | 45550 | 545 | 2.252119 | 12.27404855 | uncultured Acaulosporaceae | 467201 | Fungi | Fungi | 119 | 5.21e-22 | NTclustered | gi|523473549|gb|KF206444.1| | 467201 | g38114 | i0 | 84.874 | 6.42568807339449 | 119 | 17 | 22 | 1 | 128 | 246 | 1057 | 940 | Uncultured Acaulosporaceae clone Gra-11 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 | 3502 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | uncultured Acaulosporaceae | ||
| 14332766 | 14332766 | PRJNA1158727_P_NODE_132872_length_253_cov_1.372222_g125411_i0 | PRJNA1158727 | 132872 | 253 | 1.372222 | 3.47172166 | Rhizopus delemar | 936053 | Fungi | Fungi | 182 | 2.81e-41 | NTclustered | gi|2797463937|ref|XM_067662595.1| | 246409 | g125411 | i0 | 80.932 | 2.17786561264822 | 236 | 39 | 92 | 3 | 7 | 239 | 292 | 524 | Rhizopus delemar RA 99-880 60S ribosomal protein uL16 (RO3G_08005), partial mRNA | blastn | 551 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus delemar | |
| 14334639 | 14334639 | PRJNA1158727_P_NODE_53932_length_467_cov_1.934010_g46474_i0 | PRJNA1158727 | 53932 | 467 | 1.93401 | 9.0318267 | Gilbertella persicaria | 101096 | Fungi | Fungi | 311 | 6.78e-80 | NTclustered | gi|2323740287|ref|XM_051583307.1| | 101096 | g46474 | i0 | 79.556 | 24.3404710920771 | 450 | 80 | 95 | 11 | 13 | 456 | 444 | 1 | Gilbertella persicaria 40S ribosomal protein S23 (B0P05DRAFT_603980), partial mRNA | blastn | 11367 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria | |
| 15606952 | 15606952 | PRJNA1158727_P_NODE_149613_length_246_cov_0.890173_g142151_i0 | PRJNA1158727 | 149613 | 246 | 0.890173 | 2.18982558 | Lichtheimia ornata | 688661 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2553573839|ref|XM_058485473.1| | 688661 | g142151 | i0 | 96.97 | 1.36991869918699 | 33 | 1 | 13 | 0 | 105 | 137 | 874 | 842 | Lichtheimia ornata uncharacterized protein (O0I10_005430), partial mRNA | blastn | 337 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ornata | |
| 16883460 | 16883460 | PRJNA1158727_P_NODE_76934_length_349_cov_1.384058_g69473_i0 | PRJNA1158727 | 76934 | 349 | 1.384058 | 4.83036242 | uncultured Glomeromycotina | 241622 | Fungi | Fungi | 106 | 2.49e-18 | NTclustered | gi|2863800393|gb|PQ669850.1| | 241622 | g69473 | i0 | 92 | 4.19484240687679 | 75 | 6 | 21 | 0 | 8 | 82 | 804 | 878 | Uncultured Glomeromycotina isolate HbAMF84 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1464 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | uncultured Glomeromycotina | |||||
| 19429669 | 19429669 | PRJNA1158727_P_NODE_124436_length_262_cov_1.629630_g116975_i0 | PRJNA1158727 | 124436 | 262 | 1.62963 | 4.2696306 | Umbelopsis ramanniana | 41833 | Fungi | Fungi | 156 | 1.77e-33 | NTclustered | gi|2323696762|ref|XM_051591846.1| | 1314678 | g116975 | i0 | 82.353 | 10.8053435114504 | 187 | 25 | 70 | 8 | 59 | 241 | 86 | 268 | Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_258468), mRNA | blastn | 2831 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis ramanniana | |
| 19432399 | 19432399 | PRJNA1158727_P_NODE_77356_length_348_cov_1.080000_g69895_i0 | PRJNA1158727 | 77356 | 348 | 1.08 | 3.7584 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 204 | 8.599999999999999e-48 | NTclustered | gi|2324069670|ref|XM_051531294.1| | 90255 | g69895 | i0 | 79.195 | 8.24137931034483 | 298 | 58 | 85 | 4 | 52 | 347 | 502 | 797 | Cokeromyces recurvatus ATP-dependent RNA helicase eIF4A (BX663DRAFT_551643), partial mRNA | blastn | 2868 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 19432592 | 19432592 | PRJNA1158727_P_NODE_84376_length_327_cov_1.952756_g76915_i0 | PRJNA1158727 | 84376 | 327 | 1.952756 | 6.38551212 | Gilbertella persicaria | 101096 | Fungi | Fungi | 147 | 1.37e-30 | NTclustered | gi|2323717654|ref|XM_051576335.1| | 101096 | g76915 | i0 | 89.076 | 35.9755351681957 | 119 | 11 | 36 | 2 | 1 | 118 | 543 | 660 | Gilbertella persicaria 60S ribosomal protein L2 (B0P05DRAFT_525634), partial mRNA | blastn | 11764 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria | |
| 21980685 | 21980685 | PRJNA1158727_P_NODE_136538_length_251_cov_0.865169_g129076_i0 | PRJNA1158727 | 136538 | 251 | 0.865169 | 2.17157419 | Gilbertella persicaria | 101096 | Fungi | Fungi | 265 | 2.68e-66 | NTclustered | gi|2323751103|ref|XM_051582701.1| | 101096 | g129076 | i0 | 87.665 | 4.90836653386454 | 227 | 28 | 90 | 0 | 1 | 227 | 194 | 420 | Gilbertella persicaria cyclophilin-like domain-containing protein (B0P05DRAFT_588968), partial mRNA | blastn | 1232 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria | |
| 21982148 | 21982148 | PRJNA1158727_P_NODE_39998_length_618_cov_2.196330_g32611_i0 | PRJNA1158727 | 39998 | 618 | 2.19633 | 13.5733194 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 342 | 3.2499999999999995e-89 | NTclustered | gi|1069938230|ref|XM_018429293.1| | 763407 | g32611 | i0 | 79.707 | 66.7087378640777 | 478 | 93 | 77 | 4 | 43 | 518 | 3071 | 3546 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 41226 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 24529622 | 24529622 | PRJNA1158727_P_NODE_125180_length_261_cov_1.952128_g117719_i0 | PRJNA1158727 | 125180 | 261 | 1.952128 | 5.09505408 | Rhizopus microsporus | 58291 | Fungi | Fungi | 150 | 8.2e-32 | NTclustered | gi|1331207227|ref|XM_023607402.1| | 1340429 | g117719 | i0 | 91.667 | 25.6551724137931 | 108 | 9 | 41 | 0 | 146 | 253 | 557 | 450 | Rhizopus microsporus ATCC 52813 ribosomal protein L19/L19e (RHIMIDRAFT_220265), mRNA | blastn | 6696 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 25263683 | 25263683 | PRJNA1158727_P_NODE_106580_length_284_cov_1.014218_g99119_i0 | PRJNA1158727 | 106580 | 284 | 1.014218 | 2.88037912 | Mucorales | 4827 | Fungi | Fungi | 200 | 8.85e-47 | NTclustered | gi|2323721047|ref|XM_051582306.1| | 101096 | g99119 | i0 | 89.809 | 8.95774647887324 | 157 | 14 | 55 | 2 | 31 | 186 | 243 | 88 | Gilbertella persicaria ribosomal protein S28e (B0P05DRAFT_584049), partial mRNA | blastn | 2544 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria |
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);;