contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA800090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2073549 | 2073549 | PRJNA800090_P_NODE_164782_length_242_cov_1.710983_g162597_i0 | PRJNA800090 | 164782 | 242 | 1.710983 | 4.14057886 | Gilbertella persicaria | 101096 | Fungi | Fungi | 171 | 5.77e-38 | NTclustered | gi|2323751859|ref|XM_051574772.1| | 101096 | g162597 | i0 | 84.091 | 5.75619834710744 | 176 | 28 | 73 | 0 | 62 | 237 | 674 | 499 | Gilbertella persicaria Metallo-dependent phosphatase-like protein (B0P05DRAFT_474166), partial mRNA | blastn | 1393 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria | |
| 3347473 | 3347473 | PRJNA800090_P_NODE_106883_length_313_cov_1.495902_g104698_i0 | PRJNA800090 | 106883 | 313 | 1.495902 | 4.68217326 | Halteromyces radiatus | 101107 | Fungi | Fungi | 248 | 3.4799999999999997e-61 | NTclustered | gi|2323760940|ref|XM_051547327.1| | 101107 | g104698 | i0 | 81.518 | 33.9009584664537 | 303 | 54 | 96 | 2 | 7 | 308 | 209 | 510 | Halteromyces radiatus ras family-domain-containing protein (BX664DRAFT_343563), mRNA | blastn | 10611 | 248 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus | |
| 3772364 | 3772364 | PRJNA800090_P_NODE_183483_length_231_cov_2.302469_g181298_i0 | PRJNA800090 | 183483 | 231 | 2.302469 | 5.31870339 | Opisthokonta | 33154 | Fungi | Fungi | 220 | 5.35e-53 | NTclustered | gi|2323765975|ref|XM_051573515.1| | 101096 | g181298 | i0 | 86.802 | 57.030303030303 | 197 | 26 | 85 | 0 | 13 | 209 | 310 | 506 | Gilbertella persicaria rac protein (B0P05DRAFT_314874), mRNA | blastn | 13174 | 222 | 0.990990990990991 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria | |
| 5900463 | 5900463 | PRJNA800090_P_NODE_127625_length_281_cov_1.731132_g125440_i0 | PRJNA800090 | 127625 | 281 | 1.731132 | 4.86448092 | Lichtheimia ornata | 688661 | Fungi | Fungi | 220 | 6.71e-53 | NTclustered | gi|2553572665|ref|XM_058485270.1| | 688661 | g125440 | i0 | 81.272 | 21.270462633452 | 283 | 43 | 99 | 9 | 4 | 281 | 97 | 374 | Lichtheimia ornata pyridoxal biosynthesis lyase PdxS (O0I10_005223), partial mRNA | blastn | 5977 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ornata | |
| 9727900 | 9727900 | PRJNA800090_P_NODE_78188_length_379_cov_3.974194_g76003_i0 | PRJNA800090 | 78188 | 379 | 3.974194 | 15.06219526 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 60.2 | 2.16e-4 | NTclustered | gi|1069968457|ref|XM_018434186.1| | 763407 | g76003 | i0 | 100 | 0.171503957783641 | 32 | 0 | 8 | 0 | 49 | 80 | 50 | 81 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 65 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 13974158 | 13974158 | PRJNA800090_P_NODE_134831_length_272_cov_1.078818_g132646_i0 | PRJNA800090 | 134831 | 272 | 1.078818 | 2.93438496 | Mortierellaceae | 4854 | Fungi | Fungi | 215 | 3.01e-51 | NTclustered | gi|1929277582|gb|MN878163.1| | 205924 | g132646 | i0 | 81.159 | 99.3272058823529 | 276 | 44 | 100 | 7 | 1 | 272 | 349 | 78 | Entomortierella parvispora strain AD039 elongation factor 1-alpha (EF1a) gene, partial cds | blastn | 27017 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Entomortierella | Entomortierella parvispora | |
| 18648691 | 18648691 | PRJNA800090_P_NODE_138535_length_268_cov_1.075377_g136350_i0 | PRJNA800090 | 138535 | 268 | 1.075377 | 2.88201036 | Lobosporangium transversale | 64571 | Fungi | Fungi | 62.1 | 4.08e-5 | NTclustered | gi|1227138090|ref|XM_022024022.1| | 64571 | g136350 | i0 | 93.023 | 0.16044776119403 | 43 | 1 | 16 | 2 | 31 | 73 | 1161 | 1121 | Lobosporangium transversale hypothetical protein (BCR41DRAFT_352836), mRNA | blastn | 43 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Lobosporangium | Lobosporangium transversale | |
| 21202235 | 21202235 | PRJNA800090_P_NODE_78097_length_380_cov_1.385852_g75912_i0 | PRJNA800090 | 78097 | 380 | 1.385852 | 5.2662376 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 233 | 1.21e-56 | NTclustered | gi|1069961705|ref|XM_018434095.1| | 763407 | g75912 | i0 | 82.89 | 36.2105263157895 | 263 | 41 | 69 | 2 | 89 | 349 | 430 | 170 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 13760 | 233 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 25024683 | 25024683 | PRJNA800090_P_NODE_179500_length_233_cov_0.890244_g177315_i0 | PRJNA800090 | 179500 | 233 | 0.890244 | 2.07426852 | Mucor mucedo | 29922 | Fungi | Fungi | 147 | 9.3e-31 | NTclustered | gi|2324049153|ref|XM_051595885.1| | 29922 | g177315 | i0 | 81.977 | 14.9871244635193 | 172 | 31 | 74 | 0 | 1 | 172 | 220 | 49 | Mucor mucedo 40S ribosomal protein S27 (EV154DRAFT_419262), partial mRNA | blastn | 3492 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo | |
| 25025103 | 25025103 | PRJNA800090_P_NODE_198200_length_216_cov_2.306122_g196015_i0 | PRJNA800090 | 198200 | 216 | 2.306122 | 4.98122352 | Mycotypha africana | 64632 | Fungi | Fungi | 128 | 3.08e-25 | NTclustered | gi|2432555835|ref|XM_053079633.1| | 64632 | g196015 | i0 | 89.216 | 7.97685185185185 | 102 | 11 | 47 | 0 | 115 | 216 | 330 | 229 | Mycotypha africana eukaryotic translation initiation factor 5A (BDF20DRAFT_844615), mRNA | blastn | 1723 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana |
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);;