contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA492406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1727178 | 1727178 | PRJNA492406_P_NODE_19882_length_284_cov_1.360190_g19583_i0 | PRJNA492406 | 19882 | 284 | 1.36019 | 3.8629396 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 250 | 8.66e-62 | NTclustered | gi|2324087667|ref|XM_051530092.1| | 90255 | g19583 | i0 | 83.456 | 11.419014084507 | 272 | 41 | 95 | 4 | 15 | 284 | 422 | 153 | Cokeromyces recurvatus putative ribosomal protein L10 (BX663DRAFT_527823), partial mRNA | blastn | 3243 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 9380319 | 9380319 | PRJNA492406_P_NODE_2128_length_829_cov_4.734127_g1859_i0 | PRJNA492406 | 2128 | 829 | 4.734127 | 39.24591283 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 333 | 2.66e-86 | NTclustered | gi|1069936519|ref|XM_018440025.1| | 763407 | g1859 | i0 | 80.455 | 47.1821471652594 | 440 | 83 | 53 | 2 | 153 | 592 | 135 | 571 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 39114 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 15127350 | 15127350 | PRJNA492406_P_NODE_5632_length_506_cov_1.748268_g5333_i0 | PRJNA492406 | 5632 | 506 | 1.748268 | 8.84623608 | Fungi | 4751 | Fungi | Fungi | 228 | 7.659999999999999e-55 | NTclustered | gi|2323788186|ref|XM_051559590.1| | 101098 | g5333 | i0 | 76.905 | 65.9822134387352 | 420 | 86 | 82 | 9 | 46 | 461 | 930 | 518 | Gamsiella multidivaricata ribosomal L18ae/LX protein domain-containing protein (BC939DRAFT_494133), partial mRNA | blastn | 33387 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Gamsiella | Gamsiella multidivaricata | |
| 18950719 | 18950719 | PRJNA492406_P_NODE_14055_length_334_cov_1.831418_g13756_i0 | PRJNA492406 | 14055 | 334 | 1.831418 | 6.11693612 | Fungi | 4751 | Fungi | Fungi | 231 | 3.7699999999999995e-56 | NTclustered | gi|2323767062|ref|XM_051580778.1| | 101096 | g13756 | i0 | 80.386 | 39.0209580838323 | 311 | 55 | 92 | 6 | 23 | 330 | 1853 | 1546 | Gilbertella persicaria transitional endoplasmic reticulum ATPase (B0P05DRAFT_563993), mRNA | blastn | 13033 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria | |
| 20853850 | 20853850 | PRJNA492406_P_NODE_10877_length_375_cov_1.294702_g10578_i0 | PRJNA492406 | 10877 | 375 | 1.294702 | 4.8551325 | Gamsiella multidivaricata | 101098 | Fungi | Fungi | 309 | 1.92e-79 | NTclustered | gi|2323775344|ref|XM_051554880.1| | 101098 | g10578 | i0 | 84.918 | 81.7653333333333 | 305 | 46 | 81 | 0 | 51 | 355 | 461 | 157 | Gamsiella multidivaricata ribosomal protein s23 (BC939DRAFT_445976), mRNA | blastn | 30662 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Gamsiella | Gamsiella multidivaricata | |
| 22128653 | 22128653 | PRJNA492406_P_NODE_13138_length_345_cov_2.080882_g12839_i0 | PRJNA492406 | 13138 | 345 | 2.080882 | 7.1790429 | Lichtheimia ornata | 688661 | Fungi | Fungi | 52.8 | 0.033 | NTclustered | gi|2553609711|ref|XM_058492615.1| | 688661 | g12839 | i0 | 100 | 0.0811594202898551 | 28 | 0 | 8 | 0 | 66 | 93 | 2257 | 2284 | Lichtheimia ornata uncharacterized protein (O0I10_012727), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ornata | |
| 23404616 | 23404616 | PRJNA492406_P_NODE_14619_length_327_cov_2.275591_g14320_i0 | PRJNA492406 | 14619 | 327 | 2.275591 | 7.44118257 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 206 | 2.2299999999999994e-48 | NTclustered | gi|1069959750|ref|XM_018429123.1| | 763407 | g14320 | i0 | 79.791 | 11.5045871559633 | 287 | 54 | 87 | 4 | 15 | 299 | 450 | 166 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 3762 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 24678284 | 24678284 | PRJNA492406_P_NODE_12480_length_353_cov_1.957143_g12181_i0 | PRJNA492406 | 12480 | 353 | 1.957143 | 6.90871479 | Gilbertella persicaria | 101096 | Fungi | Fungi | 158 | 6.879999999999999e-34 | NTclustered | gi|2323717654|ref|XM_051576335.1| | 101096 | g12181 | i0 | 89.062 | 35.915014164306 | 128 | 12 | 36 | 2 | 1 | 127 | 534 | 660 | Gilbertella persicaria 60S ribosomal protein L2 (B0P05DRAFT_525634), partial mRNA | blastn | 12678 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria |
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);;