contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA917598" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8549550 | 8549550 | PRJNA917598_P_NODE_65667_length_280_cov_2.198068_g64723_i0 | PRJNA917598 | 65667 | 280 | 2.198068 | 6.1545904 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|1069944198|ref|XM_018438230.1| | 763407 | g64723 | i0 | 96.97 | 0.117857142857143 | 33 | 1 | 12 | 0 | 42 | 74 | 1982 | 2014 | Phycomyces blakesleeanus NRRL 1555(-) Zn(2)-C6 fungal-specific transcription factor mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 11099382 | 11099382 | PRJNA917598_P_NODE_36709_length_379_cov_1.258170_g35765_i0 | PRJNA917598 | 36709 | 379 | 1.25817 | 4.7684643 | Zychaea mexicana | 64656 | Fungi | Fungi | 287 | 9.09e-73 | NTclustered | gi|2432180051|ref|XM_053124241.1| | 64656 | g35765 | i0 | 82.866 | 30.9894459102902 | 321 | 53 | 84 | 2 | 3 | 322 | 633 | 314 | Zychaea mexicana elongation factor 2 (BDB00DRAFT_832933), partial mRNA | blastn | 11745 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Zychaea | Zychaea mexicana | |
| 12376189 | 12376189 | PRJNA917598_P_NODE_84890_length_248_cov_0.880000_g83946_i0 | PRJNA917598 | 84890 | 248 | 0.88 | 2.1824 | Rhizomucor pusillus | 4840 | Fungi | Fungi | 119 | 2.18e-22 | NTclustered | gi|2837767459|ref|XM_069386175.1| | 4840 | g83946 | i0 | 82.353 | 42.1491935483871 | 136 | 24 | 55 | 0 | 6 | 141 | 594 | 729 | Rhizomucor pusillus 60S ribosomal protein uL2 (VTP01DRAFT_7190), partial mRNA | blastn | 10453 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 14924068 | 14924068 | PRJNA917598_P_NODE_47052_length_334_cov_2.513410_g46108_i0 | PRJNA917598 | 47052 | 334 | 2.51341 | 8.3947894 | Umbelopsis ramanniana | 41833 | Fungi | Fungi | 150 | 1.09e-31 | NTclustered | gi|2323693681|ref|XM_051590921.1| | 1314678 | g46108 | i0 | 79.464 | 38.2844311377246 | 224 | 36 | 66 | 7 | 8 | 226 | 335 | 117 | Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_252681), mRNA | blastn | 12787 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis ramanniana | |
| 16554211 | 16554211 | PRJNA917598_P_NODE_87933_length_246_cov_0.890173_g86989_i0 | PRJNA917598 | 87933 | 246 | 0.890173 | 2.18982558 | Mucoromycota | 1913637 | Fungi | Fungi | 189 | 1.62e-43 | NTclustered | gi|2323749382|ref|XM_051572893.1| | 64574 | g86989 | i0 | 84.103 | 6.77642276422764 | 195 | 31 | 79 | 0 | 1 | 195 | 228 | 422 | Radiomyces spectabilis 40S ribosomal protein S20 (BYT42DRAFT_91081), mRNA | blastn | 1667 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 17473473 | 17473473 | PRJNA917598_P_NODE_13054_length_654_cov_3.993115_g12127_i0 | PRJNA917598 | 13054 | 654 | 3.993115 | 26.1149721 | Mucor mucedo | 29922 | Fungi | Fungi | 161 | 1.04e-34 | NTclustered | gi|2324057426|ref|XM_051602033.1| | 29922 | g12127 | i0 | 84.337 | 2.59633027522936 | 166 | 24 | 25 | 2 | 117 | 281 | 98 | 262 | Mucor mucedo putative ribosomal protein S28B (EV154DRAFT_513542), mRNA | blastn | 1698 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo | |
| 20022673 | 20022673 | PRJNA917598_P_NODE_40796_length_359_cov_2.153846_g39852_i0 | PRJNA917598 | 40796 | 359 | 2.153846 | 7.73230714 | Rhizopus microsporus | 58291 | Fungi | Fungi | 248 | 4.04e-61 | NTclustered | gi|1331200175|ref|XM_023611249.1| | 1340429 | g39852 | i0 | 82.414 | 18.4623955431755 | 290 | 46 | 80 | 5 | 64 | 351 | 136 | 422 | Rhizopus microsporus ATCC 52813 40S ribosomal protein S23 (RHIMIDRAFT_257100), partial mRNA | blastn | 6628 | 248 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 20023181 | 20023181 | PRJNA917598_P_NODE_61096_length_289_cov_1.282407_g60152_i0 | PRJNA917598 | 61096 | 289 | 1.282407 | 3.70615623 | Gamsiella multidivaricata | 101098 | Fungi | Fungi | 195 | 4.2e-45 | NTclustered | gi|2323773512|ref|XM_051554546.1| | 101098 | g60152 | i0 | 83.981 | 62.7162629757785 | 206 | 29 | 71 | 4 | 85 | 288 | 399 | 196 | Gamsiella multidivaricata heat shock protein 90 (BC939DRAFT_443462), partial mRNA | blastn | 18125 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Gamsiella | Gamsiella multidivaricata | |
| 21297538 | 21297538 | PRJNA917598_P_NODE_23257_length_480_cov_2.292383_g22315_i0 | PRJNA917598 | 23257 | 480 | 2.292383 | 11.0034384 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 106 | 3.54e-18 | NTclustered | gi|1069940028|ref|XM_018438097.1| | 763407 | g22315 | i0 | 79.87 | 4.50416666666667 | 154 | 23 | 31 | 7 | 331 | 480 | 446 | 297 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 2162 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 24202691 | 24202691 | PRJNA917598_P_NODE_19219_length_532_cov_2.442266_g18282_i0 | PRJNA917598 | 19219 | 532 | 2.442266 | 12.99285512 | Fungi | 4751 | Fungi | Fungi | 363 | 2.1199999999999994e-95 | NTclustered | gi|2323695494|ref|XM_051584821.1| | 1314678 | g18282 | i0 | 81.304 | 123.526315789474 | 460 | 75 | 86 | 9 | 20 | 475 | 704 | 1156 | Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_214084), mRNA | blastn | 65716 | 364 | 0.997252747252747 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis ramanniana | |
| 25121575 | 25121575 | PRJNA917598_P_NODE_21560_length_500_cov_1.152225_g20621_i0 | PRJNA917598 | 21560 | 500 | 1.152225 | 5.761125 | Rhizopus delemar | 936053 | Fungi | Fungi | 121 | 1.32e-22 | NTclustered | gi|2797429826|ref|XM_067658750.1| | 246409 | g20621 | i0 | 81.944 | 1.516 | 144 | 24 | 29 | 2 | 4 | 146 | 169 | 311 | Rhizopus delemar RA 99-880 60S ribosomal protein (RO3G_04160), partial mRNA | blastn | 758 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus delemar |
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);;