contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA977246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3820857 | 3820857 | PRJNA977246_S_NODE_29363_length_230_cov_77.636816_g28371_i0 | PRJNA977246 | 29363 | 230 | 77.636816 | 178.5646768 | Geosiphon pyriformis | 50956 | Fungi | Fungi | 80.1 | 1.95e-15 | NR | KAG9292464.1 | 50956 | g28371 | i0 | 67.3 | 0.717391304347826 | 55 | 18 | 71.7 | 0 | 3 | 167 | 41 | 95 | KAG9292464.1 hypothetical protein G9A89_000462 [Geosiphon pyriformis] | diamond | 165 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Geosiphonaceae | Geosiphon | Geosiphon pyriformis | |
| 6054106 | 6054106 | PRJNA977246_S_NODE_12025_length_434_cov_7.377778_g11062_i0 | PRJNA977246 | 12025 | 434 | 7.377778 | 32.01955652 | Mucor plumbeus | 97098 | Fungi | Fungi | 218 | 1.86e-69 | NR | KAG2192991.1 | 97098 | g11062 | i0 | 100 | 0.746543778801843 | 108 | 0 | 74.7 | 0 | 27 | 350 | 102 | 209 | KAG2192991.1 hypothetical protein INT46_010823 [Mucor plumbeus] | diamond | 324 | 218 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor plumbeus | |
| 10197742 | 10197742 | PRJNA977246_S_NODE_7248_length_585_cov_3384.482014_g6446_i0 | PRJNA977246 | 7248 | 585 | 3384.482014 | 19799.2197819 | Mucor plumbeus | 97098 | Fungi | Fungi | 134 | 3.96e-36 | NR | KAG2214622.1 | 97098 | g6446 | i0 | 97.1 | 0.348717948717949 | 68 | 2 | 34.9 | 0 | 543 | 340 | 73 | 140 | KAG2214622.1 hypothetical protein INT46_008167 [Mucor plumbeus] | diamond | 204 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor plumbeus | |
| 14979715 | 14979715 | PRJNA977246_S_NODE_8132_length_546_cov_1725.692456_g7285_i0 | PRJNA977246 | 8132 | 546 | 1725.692456 | 9422.28080976 | Mucor plumbeus | 97098 | Fungi | Fungi | 208 | 2.13e-62 | NR | KAG2189956.1 | 97098 | g7285 | i0 | 98.2 | 0.60989010989011 | 111 | 2 | 61 | 0 | 76 | 408 | 294 | 404 | KAG2189956.1 hypothetical protein INT46_005775 [Mucor plumbeus] | diamond | 333 | 208 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor plumbeus | |
| 15296689 | 15296689 | PRJNA977246_S_NODE_17952_length_333_cov_6178.296053_g16960_i0 | PRJNA977246 | 17952 | 333 | 6178.296053 | 20573.72585649 | Mucor plumbeus | 97098 | Fungi | Fungi | 123 | 2.46e-30 | NR | KAG2201306.1 | 97098 | g16960 | i0 | 97.7 | 0.792792792792793 | 88 | 2 | 79.3 | 0 | 289 | 26 | 89 | 176 | KAG2201306.1 hypothetical protein INT46_003883 [Mucor plumbeus] | diamond | 264 | 123 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor plumbeus | |
| 26836424 | 26836424 | PRJNA977246_S_NODE_43101_length_171_cov_4.450704_g42109_i0 | PRJNA977246 | 43101 | 171 | 4.450704 | 7.61070384 | Mucor plumbeus | 97098 | Fungi | Fungi | 109 | 2.29e-26 | NR | KAG2201306.1 | 97098 | g42109 | i0 | 98.2 | 0.982456140350877 | 56 | 1 | 98.2 | 0 | 2 | 169 | 254 | 309 | KAG2201306.1 hypothetical protein INT46_003883 [Mucor plumbeus] | diamond | 168 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor plumbeus | |
| 31891000 | 31891000 | PRJNA977246_S_NODE_48117_length_158_cov_2.899225_g47125_i0 | PRJNA977246 | 48117 | 158 | 2.899225 | 4.5807755 | Syncephalastrum racemosum | 13706 | Fungi | Fungi | 63.9 | 1.3099999999999999e-10 | NR | ORZ03463.1 | 13706 | g47125 | i0 | 64.7 | 0.968354430379747 | 51 | 18 | 96.8 | 0 | 153 | 1 | 99 | 149 | ORZ03463.1 ribosomal protein L13e [Syncephalastrum racemosum] | diamond | 153 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Syncephalastraceae | Syncephalastrum | Syncephalastrum racemosum | |
| 32744599 | 32744599 | PRJNA977246_S_NODE_41360_length_177_cov_2.378378_g40368_i0 | PRJNA977246 | 41360 | 177 | 2.378378 | 4.20972906 | Acaulospora colombiana | 27376 | Fungi | Fungi | 88.2 | 1.18e-18 | NR | CAG8651226.1 | 27376 | g40368 | i0 | 62.1 | 0.983050847457627 | 58 | 22 | 98.3 | 0 | 2 | 175 | 67 | 124 | CAG8651226.1 7968_t:CDS:2 [Acaulospora colombiana] | diamond | 174 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora colombiana | |
| 32775870 | 32775870 | PRJNA977246_S_NODE_29220_length_231_cov_4.821782_g28228_i0 | PRJNA977246 | 29220 | 231 | 4.821782 | 11.13831642 | Mucor plumbeus | 97098 | Fungi | Fungi | 111 | 1.47e-26 | NR | KAG2201306.1 | 97098 | g28228 | i0 | 98.2 | 0.727272727272727 | 56 | 1 | 72.7 | 0 | 38 | 205 | 188 | 243 | KAG2201306.1 hypothetical protein INT46_003883 [Mucor plumbeus] | diamond | 168 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor plumbeus | |
| 32870369 | 32870369 | PRJNA977246_S_NODE_19220_length_318_cov_610.460208_g18228_i0 | PRJNA977246 | 19220 | 318 | 610.460208 | 1941.26346144 | Mucor plumbeus | 97098 | Fungi | Fungi | 72.8 | 2.84e-14 | NR | KAG2198157.1 | 97098 | g18228 | i0 | 100 | 0.30188679245283 | 32 | 0 | 30.2 | 0 | 237 | 142 | 1 | 32 | KAG2198157.1 hypothetical protein INT46_000594 [Mucor plumbeus] | diamond | 96 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor plumbeus |
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);;