contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1159911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2859057 | 2859057 | PRJNA1159911_P_NODE_63583_length_300_cov_1.118943_g63041_i0 | PRJNA1159911 | 63583 | 300 | 1.118943 | 3.356829 | Mycotypha africana | 64632 | Fungi | Fungi | 161 | 4.44e-35 | NTclustered | gi|2432568539|ref|XM_053081520.1| | 64632 | g63041 | i0 | 81.188 | 12.54 | 202 | 36 | 67 | 2 | 4 | 204 | 269 | 69 | Mycotypha africana ribosomal protein L4 domain-containing protein (BDF20DRAFT_878818), partial mRNA | blastn | 3762 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 4134793 | 4134793 | PRJNA1159911_P_NODE_51764_length_340_cov_1.565543_g51222_i0 | PRJNA1159911 | 51764 | 340 | 1.565543 | 5.3228462 | Rhizopus microsporus | 58291 | Fungi | Fungi | 326 | 1.71e-84 | NTclustered | gi|1331195227|ref|XM_023607527.1| | 1340429 | g51222 | i0 | 84.524 | 92.4647058823529 | 336 | 44 | 98 | 8 | 7 | 338 | 1321 | 990 | Rhizopus microsporus ATCC 52813 ATP synthase F1, beta subunit (RHIMIDRAFT_225386), mRNA | blastn | 31438 | 326 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 5411905 | 5411905 | PRJNA1159911_P_NODE_95385_length_245_cov_0.895349_g94843_i0 | PRJNA1159911 | 95385 | 245 | 0.895349 | 2.19360505 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 132 | 2.76e-26 | NTclustered | gi|2324049831|ref|XM_051531783.1| | 90255 | g94843 | i0 | 82.895 | 1.23265306122449 | 152 | 20 | 61 | 6 | 41 | 189 | 319 | 171 | Cokeromyces recurvatus 60S ribosomal protein L18-B (BX663DRAFT_557770), partial mRNA | blastn | 302 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 10511009 | 10511009 | PRJNA1159911_P_NODE_17129_length_728_cov_1.859542_g16627_i0 | PRJNA1159911 | 17129 | 728 | 1.859542 | 13.53746576 | Mucor mucedo | 29922 | Fungi | Fungi | 117 | 2.5500000000000004e-21 | NTclustered | gi|2324032737|ref|XM_051605504.1| | 29922 | g16627 | i0 | 77.665 | 1.38736263736264 | 197 | 41 | 27 | 3 | 163 | 358 | 282 | 476 | Mucor mucedo ribosomal protein L6e-domain-containing protein (EV154DRAFT_558689), partial mRNA | blastn | 1010 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo | |
| 11787535 | 11787535 | PRJNA1159911_P_NODE_97750_length_243_cov_1.317647_g97208_i0 | PRJNA1159911 | 97750 | 243 | 1.317647 | 3.20188221 | Mycotypha africana | 64632 | Fungi | Fungi | 124 | 4.579999999999999e-24 | NTclustered | gi|2432565159|ref|XM_053084780.1| | 64632 | g97208 | i0 | 77.778 | 3.25102880658436 | 207 | 42 | 84 | 4 | 39 | 243 | 759 | 555 | Mycotypha africana 60S ribosomal protein L12 (BDF20DRAFT_939637), partial mRNA | blastn | 790 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 14336091 | 14336091 | PRJNA1159911_P_NODE_104412_length_226_cov_2.235294_g103870_i0 | PRJNA1159911 | 104412 | 226 | 2.235294 | 5.05176444 | Mucor mucedo | 29922 | Fungi | Fungi | 132 | 2.51e-26 | NTclustered | gi|2324061705|ref|XM_051602447.1| | 29922 | g103870 | i0 | 82.993 | 5.47345132743363 | 147 | 23 | 65 | 2 | 56 | 201 | 174 | 29 | Mucor mucedo 60S ribosomal protein L18-A (EV154DRAFT_516981), partial mRNA | blastn | 1237 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo | |
| 16340412 | 16340412 | PRJNA1159911_P_NODE_34193_length_449_cov_2.002660_g33652_i0 | PRJNA1159911 | 34193 | 449 | 2.00266 | 8.9919434 | Mucorales | 4827 | Fungi | Fungi | 200 | 1.47e-46 | NTclustered | gi|2323721047|ref|XM_051582306.1| | 101096 | g33652 | i0 | 89.809 | 5.66592427616926 | 157 | 14 | 35 | 2 | 137 | 292 | 88 | 243 | Gilbertella persicaria ribosomal protein S28e (B0P05DRAFT_584049), partial mRNA | blastn | 2544 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria | |
| 18159682 | 18159682 | PRJNA1159911_P_NODE_51815_length_340_cov_1.385768_g51273_i0 | PRJNA1159911 | 51815 | 340 | 1.3857680000000001 | 4.7116112 | Lichtheimia ornata | 688661 | Fungi | Fungi | 95.3 | 5.26e-15 | NTclustered | gi|2553548665|ref|XM_058480136.1| | 688661 | g51273 | i0 | 80.153 | 17.2147058823529 | 131 | 22 | 38 | 4 | 211 | 339 | 141 | 13 | Lichtheimia ornata 60S ribosomal protein L29 (O0I10_000020), partial mRNA | blastn | 5853 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ornata | |
| 18159941 | 18159941 | PRJNA1159911_P_NODE_67135_length_290_cov_2.359447_g66593_i0 | PRJNA1159911 | 67135 | 290 | 2.359447 | 6.8423963 | Mucor mucedo | 29922 | Fungi | Fungi | 226 | 1.5e-54 | NTclustered | gi|2324041151|ref|XM_051600232.1| | 29922 | g66593 | i0 | 85.135 | 24.3413793103448 | 222 | 31 | 76 | 2 | 42 | 262 | 221 | 1 | Mucor mucedo 60S ribosomal protein L15 (EV154DRAFT_497163), partial mRNA | blastn | 7059 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo | |
| 20709417 | 20709417 | PRJNA1159911_P_NODE_57297_length_319_cov_2.365854_g56755_i0 | PRJNA1159911 | 57297 | 319 | 2.365854 | 7.54707426 | Halteromyces radiatus | 101107 | Fungi | Fungi | 134 | 1.04e-26 | NTclustered | gi|2323726675|ref|XM_051542152.1| | 101107 | g56755 | i0 | 87.719 | 9.2884012539185 | 114 | 14 | 36 | 0 | 116 | 229 | 498 | 611 | Halteromyces radiatus 40S ribosomal protein S8 (BX664DRAFT_295451), partial mRNA | blastn | 2963 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus | |
| 24533835 | 24533835 | PRJNA1159911_P_NODE_45280_length_370_cov_1.353535_g44738_i0 | PRJNA1159911 | 45280 | 370 | 1.353535 | 5.0080795 | Umbelopsis ramanniana | 41833 | Fungi | Fungi | 52.8 | 0.035 | NTclustered | gi|2323679023|ref|XM_051585247.1| | 1314678 | g44738 | i0 | 92.105 | 0.102702702702703 | 38 | 2 | 10 | 1 | 333 | 370 | 616 | 580 | Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_218674), mRNA | blastn | 38 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis ramanniana |
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);;