contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA800053" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19923046 | 19923046 | PRJNA800053_P_NODE_23516_length_241_cov_1.476190_g23352_i0 | PRJNA800053 | 23516 | 241 | 1.47619 | 3.5576179 | Malassezia cuniculi | 948313 | Fungi | Fungi | 139 | 2.9e-37 | NR | WFD35336.1 | 948313 | g23352 | i0 | 85.9 | 0.970954356846473 | 78 | 11 | 97.1 | 0 | 240 | 7 | 368 | 445 | WFD35336.1 ornithine aminotransferase [Malassezia cuniculi] | diamond | 234 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 26610705 | 26610705 | PRJNA800053_P_NODE_17841_length_250_cov_1.728814_g17677_i0 | PRJNA800053 | 17841 | 250 | 1.728814 | 4.322035 | Mycena galericulata | 71905 | Fungi | Fungi | 46.2 | 0.00252 | NR | KAJ7432825.1 | 71905 | g17677 | i0 | 49 | 1.188 | 51 | 25 | 60 | 1 | 2 | 151 | 653 | 703 | KAJ7432825.1 hypothetical protein B0H11DRAFT_2260010 [Mycena galericulata] | diamond | 297 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena galericulata | |
| 27591391 | 27591391 | PRJNA800053_P_NODE_22824_length_242_cov_1.804734_g22660_i0 | PRJNA800053 | 22824 | 242 | 1.804734 | 4.36745628 | Malassezia cuniculi | 948313 | Fungi | Fungi | 87 | 1.98e-18 | NR | WFD34402.1 | 948313 | g22660 | i0 | 77.8 | 1.11570247933884 | 45 | 10 | 55.8 | 0 | 241 | 107 | 240 | 284 | WFD34402.1 hypothetical protein MCUN1_001243 [Malassezia cuniculi] | diamond | 270 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 28137043 | 28137043 | PRJNA800053_P_NODE_21805_length_244_cov_0.900585_g21641_i0 | PRJNA800053 | 21805 | 244 | 0.900585 | 2.1974274 | Malassezia | 55193 | Fungi | Fungi | 105 | 1.71e-24 | NR | KAI3623411.1 | 55194 | g21641 | i0 | 59.5 | 3.86065573770492 | 79 | 32 | 97.1 | 0 | 237 | 1 | 226 | 304 | KAI3623411.1 CEG1 [Malassezia furfur] | diamond | 942 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 28475290 | 28475290 | PRJNA800053_P_NODE_13646_length_275_cov_1.509901_g13482_i0 | PRJNA800053 | 13646 | 275 | 1.509901 | 4.15222775 | Malassezia cuniculi | 948313 | Fungi | Fungi | 145 | 1.6799999999999999e-40 | NR | WFD35849.1 | 948313 | g13482 | i0 | 74.4 | 0.981818181818182 | 90 | 23 | 98.2 | 0 | 1 | 270 | 71 | 160 | WFD35849.1 hypothetical protein MCUN1_002717 [Malassezia cuniculi] | diamond | 270 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 29485363 | 29485363 | PRJNA800053_P_NODE_8010_length_336_cov_1.239544_g7846_i0 | PRJNA800053 | 8010 | 336 | 1.239544 | 4.16486784 | Armillaria gallica | 47427 | Fungi | Fungi | 42.4 | 0.0198 | NR | PBK95230.1 | 47427 | g7846 | i0 | 38 | 0.633928571428571 | 71 | 40 | 63.4 | 1 | 64 | 276 | 9 | 75 | PBK95230.1 hypothetical protein ARMGADRAFT_791432 [Armillaria gallica] | diamond | 213 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Armillaria | Armillaria gallica | |
| 30654266 | 30654266 | PRJNA800053_P_NODE_14593_length_268_cov_1.574359_g14429_i0 | PRJNA800053 | 14593 | 268 | 1.574359 | 4.21928212 | Malassezia cuniculi | 948313 | Fungi | Fungi | 142 | 6.7e-37 | NR | WFD35677.1 | 948313 | g14429 | i0 | 77.9 | 0.962686567164179 | 86 | 19 | 96.3 | 0 | 4 | 261 | 1032 | 1117 | WFD35677.1 hypothetical protein MCUN1_002538 [Malassezia cuniculi] | diamond | 258 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 31033841 | 31033841 | PRJNA800053_P_NODE_21655_length_244_cov_1.169591_g21491_i0 | PRJNA800053 | 21655 | 244 | 1.169591 | 2.85380204 | Candolleomyces aberdarensis | 2316362 | Fungi | Fungi | 157 | 1.6499999999999998e-42 | NR | RXW24817.1 | 2316362 | g21491 | i0 | 97.5 | 0.983606557377049 | 80 | 2 | 98.4 | 0 | 242 | 3 | 352 | 431 | RXW24817.1 hypothetical protein EST38_g1032 [Candolleomyces aberdarensis] | diamond | 240 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Candolleomyces | Candolleomyces aberdarensis | |
| 32307942 | 32307942 | PRJNA800053_P_NODE_21099_length_245_cov_0.895349_g20935_i0 | PRJNA800053 | 21099 | 245 | 0.895349 | 2.19360505 | Rhodotorula | 5533 | Fungi | Fungi | 103 | 2.0799999999999994e-23 | NR | KAK4335681.1 | 5286 | g20935 | i0 | 57.5 | 4.91020408163265 | 80 | 34 | 98 | 0 | 2 | 241 | 1085 | 1164 | KAK4335681.1 40S ribosomal protein S4-A [Rhodotorula toruloides] | diamond | 1203 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides |
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);;