contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA689790" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 668767 | 668767 | PRJNA689790_S_NODE_6401_length_236_cov_1.748744_g6286_i0 | PRJNA689790 | 6401 | 236 | 1.748744 | 4.12703584 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 76.8 | 1.26e-9 | NTclustered | gi|1069952157|ref|XM_018433864.1| | 763407 | g6286 | i0 | 88.71 | 4.04661016949153 | 62 | 7 | 26 | 0 | 141 | 202 | 415 | 354 | Phycomyces blakesleeanus NRRL 1555(-) CCHC-type zinc finger transcription factor partial mRNA | blastn | 955 | 76.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 7047305 | 7047305 | PRJNA689790_S_NODE_12886_length_167_cov_1.500000_g12771_i0 | PRJNA689790 | 12886 | 167 | 1.5 | 2.505 | Umbelopsis ramanniana | 41833 | Fungi | Fungi | 122 | 1.0499999999999999e-23 | NTclustered | gi|2323683432|ref|XM_051584750.1| | 1314678 | g12771 | i0 | 85.366 | 45.3952095808383 | 123 | 12 | 72 | 4 | 1 | 120 | 794 | 913 | Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_206629), mRNA | blastn | 7581 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis ramanniana | |
| 7047354 | 7047354 | PRJNA689790_S_NODE_6046_length_243_cov_3.941748_g5931_i0 | PRJNA689790 | 6046 | 243 | 3.941748 | 9.57844764 | Lobosporangium transversale | 64571 | Fungi | Fungi | 207 | 4.42e-49 | NTclustered | gi|1227137782|ref|XM_022023968.1| | 64571 | g5931 | i0 | 85.427 | 64.8930041152263 | 199 | 29 | 82 | 0 | 1 | 199 | 364 | 166 | Lobosporangium transversale S2 ribosomal protein (BCR41DRAFT_352547), partial mRNA | blastn | 15769 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Lobosporangium | Lobosporangium transversale | |
| 9597248 | 9597248 | PRJNA689790_S_NODE_12648_length_168_cov_2.083969_g12533_i0 | PRJNA689790 | 12648 | 168 | 2.083969 | 3.50106792 | Gamsiella multidivaricata | 101098 | Fungi | Fungi | 132 | 1.7600000000000002e-26 | NTclustered | gi|2323770400|ref|XM_051558359.1| | 101098 | g12533 | i0 | 90.816 | 4.75595238095238 | 98 | 9 | 58 | 0 | 27 | 124 | 326 | 229 | Gamsiella multidivaricata 60S ribosomal protein L3 (BC939DRAFT_473571), partial mRNA | blastn | 799 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Gamsiella | Gamsiella multidivaricata | |
| 12148028 | 12148028 | PRJNA689790_S_NODE_15450_length_155_cov_1.584746_g15335_i0 | PRJNA689790 | 15450 | 155 | 1.584746 | 2.4563563 | Gilbertella persicaria | 101096 | Fungi | Fungi | 52.8 | 0.013 | NTclustered | gi|2323727952|ref|XM_051574294.1| | 101096 | g15335 | i0 | 100 | 0.180645161290323 | 28 | 0 | 18 | 0 | 1 | 28 | 496 | 523 | Gilbertella persicaria P-loop containing nucleoside triphosphate hydrolase protein (B0P05DRAFT_465918), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria | |
| 15971485 | 15971485 | PRJNA689790_S_NODE_7473_length_216_cov_2.150838_g7358_i0 | PRJNA689790 | 7473 | 216 | 2.150838 | 4.64581008 | Podila verticillata | 78898 | Fungi | Fungi | 102 | 1.87e-17 | NTclustered | gi|82398405|gb|DQ273794.1| | 78898 | g7358 | i0 | 89.157 | 38.0787037037037 | 83 | 7 | 38 | 2 | 16 | 97 | 1815 | 1734 | Mortierella verticillata isolate AFTOL-ID 141 28S ribosomal RNA gene, partial sequence | blastn | 8225 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Podila | Podila verticillata | |
| 23621622 | 23621622 | PRJNA689790_S_NODE_5279_length_262_cov_2.217778_g5164_i0 | PRJNA689790 | 5279 | 262 | 2.217778 | 5.81057836 | Mycotypha africana | 64632 | Fungi | Fungi | 147 | 1.07e-30 | NTclustered | gi|2432573624|ref|XM_053082345.1| | 64632 | g5164 | i0 | 80.203 | 38.9427480916031 | 197 | 37 | 75 | 2 | 1 | 196 | 317 | 512 | Mycotypha africana hsp83-like protein (BDF20DRAFT_893347), mRNA | blastn | 10203 | 147 | 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);;