contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA893346" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2143374 | 2143374 | PRJNA893346_P_NODE_18142_length_363_cov_1.593103_g17653_i0 | PRJNA893346 | 18142 | 363 | 1.593103 | 5.78296389 | Mucor velutinosus | 708070 | Fungi | Fungi | 265 | 4.06e-66 | NTclustered | gi|2724911651|ref|XM_064820432.1| | 708070 | g17653 | i0 | 81.402 | 71.8044077134986 | 328 | 57 | 90 | 4 | 38 | 363 | 411 | 86 | Mucor velutinosus PHO85 cyclin-5 (PCL5_1), partial mRNA | blastn | 26065 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor velutinosus | |
| 7246298 | 7246298 | PRJNA893346_P_NODE_26106_length_296_cov_1.542601_g25616_i0 | PRJNA893346 | 26106 | 296 | 1.5426010000000001 | 4.56609896 | Mucor velutinosus | 708070 | Fungi | Fungi | 348 | 3.13e-91 | NTclustered | gi|2724890309|ref|XM_064825758.1| | 708070 | g25616 | i0 | 88.85 | 87.9324324324324 | 287 | 27 | 96 | 5 | 5 | 288 | 1113 | 829 | Mucor velutinosus tRNA A64-2'-O-ribosylphosphate transferase (RIT1), partial mRNA | blastn | 26028 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor velutinosus | |
| 9796379 | 9796379 | PRJNA893346_P_NODE_39508_length_241_cov_1.255952_g39018_i0 | PRJNA893346 | 39508 | 241 | 1.255952 | 3.02684432 | Gamsiella multidivaricata | 101098 | Fungi | Fungi | 147 | 9.67e-31 | NTclustered | gi|2323800178|ref|XM_051557252.1| | 101098 | g39018 | i0 | 87.5 | 50.7095435684647 | 128 | 15 | 53 | 1 | 1 | 127 | 319 | 192 | Gamsiella multidivaricata 40S ribosomal protein S5 (BC939DRAFT_463556), mRNA | blastn | 12221 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Gamsiella | Gamsiella multidivaricata | |
| 14895941 | 14895941 | PRJNA893346_P_NODE_16712_length_379_cov_1.509804_g16224_i0 | PRJNA893346 | 16712 | 379 | 1.509804 | 5.72215716 | Mycotypha africana | 64632 | Fungi | Fungi | 276 | 1.9699999999999999e-69 | NTclustered | gi|2432573168|ref|XM_053084955.1| | 64632 | g16224 | i0 | 82.848 | 80.6596306068602 | 309 | 51 | 81 | 2 | 66 | 373 | 359 | 666 | Mycotypha africana 40S ribosomal protein S2 (BDF20DRAFT_963343), mRNA | blastn | 30570 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 16170745 | 16170745 | PRJNA893346_P_NODE_20533_length_340_cov_1.355805_g20044_i0 | PRJNA893346 | 20533 | 340 | 1.355805 | 4.609737 | Halteromyces radiatus | 101107 | Fungi | Fungi | 200 | 1.08e-46 | NTclustered | gi|2323725066|ref|XM_051541399.1| | 101107 | g20044 | i0 | 80.46 | 58.2882352941176 | 261 | 51 | 77 | 0 | 73 | 333 | 927 | 667 | Halteromyces radiatus adenosylhomocysteinase (BX664DRAFT_278257), mRNA | blastn | 19818 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus | |
| 16545794 | 16545794 | PRJNA893346_P_NODE_23813_length_313_cov_1.283333_g23323_i0 | PRJNA893346 | 23813 | 313 | 1.283333 | 4.01683229 | Fungi | 4751 | Fungi | Fungi | 211 | 4.56e-50 | NTclustered | gi|2837717254|ref|XM_069385475.1| | 4840 | g23323 | i0 | 80.069 | 63.5623003194888 | 291 | 52 | 92 | 6 | 9 | 296 | 493 | 206 | Rhizomucor pusillus uncharacterized protein (VTP01DRAFT_6560), partial mRNA | blastn | 19895 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 17446500 | 17446500 | PRJNA893346_P_NODE_30674_length_267_cov_1.587629_g30184_i0 | PRJNA893346 | 30674 | 267 | 1.587629 | 4.23896943 | Rhizopus microsporus | 58291 | Fungi | Fungi | 110 | 1.43e-19 | NTclustered | gi|1331199135|ref|XM_023605726.1| | 1340429 | g30184 | i0 | 91.25 | 4.38951310861423 | 80 | 7 | 30 | 0 | 71 | 150 | 210 | 131 | Rhizopus microsporus ATCC 52813 large subunit ribosomal protein 1 (RHIMIDRAFT_143459), mRNA | blastn | 1172 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 25094509 | 25094509 | PRJNA893346_P_NODE_39920_length_241_cov_0.916667_g39430_i0 | PRJNA893346 | 39920 | 241 | 0.916667 | 2.20916747 | Rhizopus microsporus | 58291 | Fungi | Fungi | 117 | 7.58e-22 | NTclustered | gi|1331197927|ref|XM_023607577.1| | 1340429 | g39430 | i0 | 79.651 | 7.85477178423236 | 172 | 27 | 70 | 8 | 2 | 169 | 314 | 481 | Rhizopus microsporus ATCC 52813 histone-fold-containing protein (RHIMIDRAFT_226687), mRNA | blastn | 1893 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus |
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);;