contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA812001" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13563992 | 13563992 | PRJNA812001_P_NODE_13911_length_431_cov_10.603352_g13665_i0 | PRJNA812001 | 13911 | 431 | 10.603352 | 45.70044712 | Eukaryota | 2759 | Fungi | Fungi | 196 | 5.570000000000001e-59 | NR | KAG0286410.1 | 64522 | g13665 | i0 | 67.1 | 11.5406032482599 | 140 | 45 | 96.8 | 1 | 2 | 418 | 226 | 365 | KAG0286410.1 hypothetical protein BGZ96_009474 [Linnemannia gamsii] | diamond | 4974 | 197 | 0.99492385786802 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Linnemannia | Linnemannia gamsii | |
| 18662141 | 18662141 | PRJNA812001_P_NODE_39195_length_311_cov_9.352941_g38949_i0 | PRJNA812001 | 39195 | 311 | 9.352941 | 29.08764651 | Mucoromycota | 1913637 | Fungi | Fungi | 161 | 6.4700000000000004e-49 | NR | KAI9303706.1 | 76405 | g38949 | i0 | 80.2 | 12.2508038585209 | 91 | 18 | 87.8 | 0 | 289 | 17 | 39 | 129 | KAI9303706.1 40S ribosomal protein S22-A [Cunninghamella echinulata] | diamond | 3810 | 162 | 0.993827160493827 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Cunninghamella | Cunninghamella echinulata | |
| 27212124 | 27212124 | PRJNA812001_P_NODE_30382_length_334_cov_6.877395_g30136_i0 | PRJNA812001 | 30382 | 334 | 6.877395 | 22.9704993 | Rhizophagus clarus | 94130 | Fungi | Fungi | 77 | 1.09e-13 | NR | GES99488.1 | 94130 | g30136 | i0 | 43.2 | 5.00299401197605 | 81 | 46 | 72.8 | 0 | 25 | 267 | 2122 | 2202 | GES99488.1 midasin [Rhizophagus clarus] | diamond | 1671 | 77 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus clarus | |
| 29043945 | 29043945 | PRJNA812001_P_NODE_136168_length_234_cov_4.267081_g135922_i0 | PRJNA812001 | 136168 | 234 | 4.267081 | 9.98496954 | Lichtheimia ramosa | 688394 | Fungi | Fungi | 43.5 | 0.00975 | NR | CDS11410.1 | 688394 | g135922 | i0 | 69 | 0.371794871794872 | 29 | 9 | 37.2 | 0 | 223 | 137 | 128 | 156 | CDS11410.1 hypothetical protein LRAMOSA03673 [Lichtheimia ramosa] | diamond | 87 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ramosa | |
| 29462696 | 29462696 | PRJNA812001_P_NODE_31430_length_331_cov_12.496124_g31184_i0 | PRJNA812001 | 31430 | 331 | 12.496124 | 41.36217044 | Fungi | 4751 | Fungi | Fungi | 62 | 6.11e-10 | NR | XP_051455026.1 | 29922 | g31184 | i0 | 70 | 5.42900302114804 | 40 | 12 | 36.3 | 0 | 325 | 206 | 52 | 91 | XP_051455026.1 uncharacterized protein EV154DRAFT_517201 [Mucor mucedo] | diamond | 1797 | 62.4 | 0.993589743589744 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo | |
| 31697776 | 31697776 | PRJNA812001_P_NODE_9237_length_514_cov_45.519274_g8991_i0 | PRJNA812001 | 9237 | 514 | 45.519274 | 233.96906836 | Blakeslea trispora | 4850 | Fungi | Fungi | 130 | 3.84e-35 | NR | KAI8373739.1 | 4850 | g8991 | i0 | 95.7 | 0.40272373540856 | 69 | 3 | 40.3 | 0 | 198 | 404 | 77 | 145 | KAI8373739.1 hypothetical protein BD560DRAFT_394198 [Blakeslea trispora] | diamond | 207 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Blakeslea | Blakeslea trispora |
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);;