contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA407087" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3632509 | 3632509 | PRJNA407087_S_NODE_4463_length_256_cov_18.982379_g4000_i0 | PRJNA407087 | 4463 | 256 | 18.982379 | 48.59489024 | Eukaryota | 2759 | Fungi | Fungi | 204 | 6.07e-48 | NTclustered | gi|82398466|gb|DQ273800.1| | 4837 | g4000 | i0 | 98.291 | 47.78515625 | 117 | 1 | 46 | 1 | 1 | 117 | 2301 | 2186 | Phycomyces blakesleeanus isolate AFTOL-ID 184 28S ribosomal RNA gene, partial sequence | blastn | 12233 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 5518709 | 5518709 | PRJNA407087_S_NODE_2185_length_441_cov_12.009709_g1725_i0 | PRJNA407087 | 2185 | 441 | 12.009709 | 52.96281669 | Gamsiella multidivaricata | 101098 | Fungi | Fungi | 250 | 1.41e-61 | NTclustered | gi|2323787328|ref|XM_051556087.1| | 101098 | g1725 | i0 | 82.686 | 11.7551020408163 | 283 | 47 | 64 | 2 | 24 | 305 | 431 | 150 | Gamsiella multidivaricata 60S ribosomal protein L3 (BC939DRAFT_454620), mRNA | blastn | 5184 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Gamsiella | Gamsiella multidivaricata | |
| 5518720 | 5518720 | PRJNA407087_S_NODE_3865_length_285_cov_10.156250_g3402_i0 | PRJNA407087 | 3865 | 285 | 10.15625 | 28.9453125 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 148 | 3.2599999999999992e-31 | NTclustered | gi|1069947120|ref|XM_018433359.1| | 763407 | g3402 | i0 | 83.133 | 7.40701754385965 | 166 | 25 | 58 | 1 | 120 | 285 | 108 | 270 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein partial mRNA | blastn | 2111 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 11893815 | 11893815 | PRJNA407087_S_NODE_7590_length_176_cov_11.414966_g7127_i0 | PRJNA407087 | 7590 | 176 | 11.414966 | 20.09034016 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 93.5 | 8.75e-15 | NTclustered | gi|1069952193|ref|XM_018439310.1| | 763407 | g7127 | i0 | 90.141 | 6.57386363636364 | 71 | 7 | 40 | 0 | 102 | 172 | 103 | 173 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 1157 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 13168731 | 13168731 | PRJNA407087_S_NODE_5891_length_208_cov_3.162011_g5428_i0 | PRJNA407087 | 5891 | 208 | 3.162011 | 6.57698288 | Rhizomucor pusillus | 4840 | Fungi | Fungi | 165 | 2.24e-36 | NTclustered | gi|2837715318|ref|XM_069385123.1| | 4840 | g5428 | i0 | 82.888 | 44.0961538461538 | 187 | 28 | 89 | 4 | 23 | 207 | 698 | 514 | Rhizomucor pusillus uncharacterized protein (VTP01DRAFT_6243), partial mRNA | blastn | 9172 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 23367046 | 23367046 | PRJNA407087_S_NODE_3699_length_295_cov_4.857143_g3236_i0 | PRJNA407087 | 3699 | 295 | 4.857143 | 14.32857185 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 172 | 2.0099999999999999e-38 | NTclustered | gi|1069966156|ref|XM_018429855.1| | 763407 | g3236 | i0 | 81.731 | 3.04067796610169 | 208 | 36 | 70 | 2 | 89 | 295 | 659 | 453 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 897 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 25307793 | 25307793 | PRJNA407087_S_NODE_4280_length_265_cov_2.788136_g3817_i0 | PRJNA407087 | 4280 | 265 | 2.788136 | 7.3885604 | Fungi | 4751 | Fungi | Fungi | 202 | 2.27e-47 | NTclustered | gi|2312|emb|X54730.1| | 4829 | g3817 | i0 | 82.969 | 83.3735849056604 | 229 | 33 | 85 | 5 | 39 | 264 | 1505 | 1280 | Absidia glauca tef-1 gene for elongation factor 1-alpha | blastn | 22094 | 204 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Absidia | Absidia glauca |
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);;