contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA886442" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23814200 | 23814200 | PRJNA886442_P_NODE_9119_length_267_cov_1.603093_g8955_i0 | PRJNA886442 | 9119 | 267 | 1.603093 | 4.28025831 | Opisthokonta | 33154 | Fungi | Fungi | 99.4 | 4.289999999999999e-23 | NR | KAI0066439.1 | 48021 | g8955 | i0 | 48.3 | 2.8988764044943802 | 87 | 45 | 97.8 | 0 | 266 | 6 | 14 | 100 | KAI0066439.1 NAD-P-binding protein [Artomyces pyxidatus] | diamond | 774 | 100 | 0.994 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Auriscalpiaceae | Artomyces | Artomyces pyxidatus | |
| 26612101 | 26612101 | PRJNA886442_P_NODE_10161_length_253_cov_2.444444_g9997_i0 | PRJNA886442 | 10161 | 253 | 2.444444 | 6.18444332 | Atractiella rhizophila | 1938712 | Fungi | Fungi | 79.3 | 4.42e-15 | NR | KAH8925836.1 | 1938712 | g9997 | i0 | 57.1 | 0.74703557312253 | 63 | 25 | 74.7 | 1 | 253 | 65 | 333 | 393 | KAH8925836.1 hypothetical protein BT69DRAFT_1279357 [Atractiella rhizophila] | diamond | 189 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Atractiellomycetes | Atractiellales | Hoehnelomycetaceae | Atractiella | Atractiella rhizophila | |
| 26897394 | 26897394 | PRJNA886442_P_NODE_15141_length_242_cov_0.923077_g14977_i0 | PRJNA886442 | 15141 | 242 | 0.923077 | 2.23384634 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 67 | 1.01e-10 | NR | CAD6579371.1 | 2778381 | g14977 | i0 | 43.4 | 0.942148760330578 | 76 | 43 | 94.2 | 0 | 3 | 230 | 190 | 265 | CAD6579371.1 MAG: hypothetical protein CYPHOPRED_000869 [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 228 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 29897605 | 29897605 | PRJNA886442_P_NODE_13431_length_246_cov_0.901734_g13267_i0 | PRJNA886442 | 13431 | 246 | 0.901734 | 2.21826564 | Atractiella rhizophila | 1938712 | Fungi | Fungi | 133 | 1.6299999999999999e-34 | NR | KAH8921326.1 | 1938712 | g13267 | i0 | 80.5 | 1 | 82 | 16 | 100 | 0 | 246 | 1 | 63 | 144 | KAH8921326.1 protein disulfide isomerase [Atractiella rhizophila] | diamond | 246 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Atractiellomycetes | Atractiellales | Hoehnelomycetaceae | Atractiella | Atractiella rhizophila | |
| 30245205 | 30245205 | PRJNA886442_P_NODE_2692_length_430_cov_1.425770_g2528_i0 | PRJNA886442 | 2692 | 430 | 1.42577 | 6.130811 | Mycena crocata | 220801 | Fungi | Fungi | 85.9 | 1.77e-17 | NR | KAJ7182922.1 | 220801 | g2528 | i0 | 60.7 | 0.837209302325581 | 61 | 24 | 42.6 | 0 | 248 | 430 | 42 | 102 | KAJ7182922.1 Caleosin related protein-domain-containing protein [Mycena crocata] | diamond | 360 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena crocata | |
| 31414323 | 31414323 | PRJNA886442_P_NODE_12756_length_247_cov_0.896552_g12592_i0 | PRJNA886442 | 12756 | 247 | 0.896552 | 2.21448344 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 67 | 1.1e-10 | NR | CAD6566822.1 | 2778381 | g12592 | i0 | 66.7 | 0.510121457489879 | 42 | 14 | 51 | 0 | 115 | 240 | 257 | 298 | CAD6566822.1 MAG: hypothetical protein CYPHOPRED_001131 [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 126 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 32078563 | 32078563 | PRJNA886442_P_NODE_7678_length_287_cov_2.369159_g7514_i0 | PRJNA886442 | 7678 | 287 | 2.369159 | 6.79948633 | Ceratobasidium sp. 423 | 2600206 | Fungi | Fungi | 43.5 | 0.0333 | NR | KAG8730680.1 | 2600206 | g7514 | i0 | 35.3 | 0.710801393728223 | 68 | 44 | 71.1 | 0 | 216 | 13 | 492 | 559 | KAG8730680.1 hypothetical protein FRC11_006108, partial [Ceratobasidium sp. 423] | diamond | 204 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. 423 |
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);;