contig_metadata
7 rows where bioproject = "PRJNA983838" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18817670 | 18817670 | PRJNA983838_P_NODE_91555_length_275_cov_1.277228_g89188_i0 | PRJNA983838 | 91555 | 275 | 1.277228 | 3.512377 | Eukaryota | 2759 | Fungi | Fungi | 108 | 3.68e-25 | NR | KAG9300577.1 | 50956 | g89188 | i0 | 80 | 5.50909090909091 | 60 | 12 | 65.5 | 0 | 182 | 3 | 7 | 66 | KAG9300577.1 hypothetical protein G9A89_000758 [Geosiphon pyriformis] | diamond | 1515 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Geosiphonaceae | Geosiphon | Geosiphon pyriformis | |
| 27311057 | 27311057 | PRJNA983838_P_NODE_123383_length_227_cov_2.025974_g121016_i0 | PRJNA983838 | 123383 | 227 | 2.025974 | 4.59896098 | Rhizophagus irregularis | 588596 | Fungi | Fungi | 75.9 | 4.25e-14 | NR | PKY34876.1 | 588596 | g121016 | i0 | 51.4 | 0.951541850220264 | 72 | 31 | 95.2 | 1 | 226 | 11 | 202 | 269 | PKY34876.1 hypothetical protein RhiirB3_532974 [Rhizophagus irregularis] | diamond | 216 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis | |
| 27316988 | 27316988 | PRJNA983838_P_NODE_57843_length_383_cov_1.000000_g55476_i0 | PRJNA983838 | 57843 | 383 | 1 | 3.83 | Eukaryota | 2759 | Fungi | Fungi | 80.9 | 9.8e-17 | NR | KAG2186871.1 | 44442 | g55476 | i0 | 56 | 20.0992167101828 | 84 | 26 | 65.8 | 1 | 13 | 264 | 50 | 122 | KAG2186871.1 hypothetical protein INT44_003098 [Umbelopsis vinacea] | diamond | 7698 | 81.3 | 0.995079950799508 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis vinacea | |
| 27626802 | 27626802 | PRJNA983838_P_NODE_118584_length_242_cov_0.923077_g116217_i0 | PRJNA983838 | 118584 | 242 | 0.923077 | 2.23384634 | Dichotomocladium elegans | 101130 | Fungi | Fungi | 47.4 | 5.85e-4 | NR | KAI9323789.1 | 101130 | g116217 | i0 | 40.3 | 0.830578512396694 | 67 | 36 | 83.1 | 2 | 8 | 208 | 142 | 204 | KAI9323789.1 GTP-binding protein ypt1 [Dichotomocladium elegans] | diamond | 201 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Dichotomocladium | Dichotomocladium elegans | |
| 27721806 | 27721806 | PRJNA983838_P_NODE_86644_length_284_cov_3.412322_g84277_i0 | PRJNA983838 | 86644 | 284 | 3.412322 | 9.69099448 | Mortierella alpina | 64518 | Fungi | Fungi | 43.9 | 0.0242 | NR | KAF9963164.1 | 64518 | g84277 | i0 | 37.5 | 0.591549295774648 | 56 | 35 | 59.2 | 0 | 73 | 240 | 230 | 285 | KAF9963164.1 MutS protein msh5 [Mortierella alpina] | diamond | 168 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella alpina | |
| 28447711 | 28447711 | PRJNA983838_P_NODE_66886_length_342_cov_2.349442_g64519_i0 | PRJNA983838 | 66886 | 342 | 2.349442 | 8.03509164 | Mortierella alpina | 64518 | Fungi | Fungi | 58.2 | 8.75e-8 | NR | KAF9283277.1 | 64518 | g64519 | i0 | 44.9 | 1.23684210526316 | 69 | 33 | 60.5 | 2 | 17 | 223 | 95 | 158 | KAF9283277.1 calmodulin-like 3 [Mortierella alpina] | diamond | 423 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella alpina | |
| 32213732 | 32213732 | PRJNA983838_P_NODE_95218_length_268_cov_1.600000_g92851_i0 | PRJNA983838 | 95218 | 268 | 1.6 | 4.288 | Eukaryota | 2759 | Fungi | Fungi | 52.8 | 1.49e-5 | NR | KAI9314337.1 | 101130 | g92851 | i0 | 33.7 | 14.8432835820896 | 86 | 54 | 96.3 | 2 | 262 | 5 | 58 | 140 | KAI9314337.1 armadillo-type protein [Dichotomocladium elegans] | diamond | 3978 | 53.1 | 0.994350282485876 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Dichotomocladium | Dichotomocladium elegans |
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);;