contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJDB14274" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27411941 | 27411941 | PRJDB14274_S_NODE_7403_length_233_cov_1.133721_g7325_i0 | PRJDB14274 | 7403 | 233 | 1.133721 | 2.64156993 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 45.8 | 0.00254 | NR | XP_017994028.1 | 77020 | g7325 | i0 | 76 | 0.682403433476395 | 25 | 6 | 32.2 | 0 | 232 | 158 | 289 | 313 | XP_017994028.1 trm8-part of complex required for 7-methylguanosine modification [Malassezia pachydermatis] | diamond | 159 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 29148657 | 29148657 | PRJDB14274_S_NODE_8249_length_221_cov_1.218750_g8171_i0 | PRJDB14274 | 8249 | 221 | 1.21875 | 2.6934375 | Imleria badia | 36058 | Fungi | Fungi | 76.6 | 3.18e-14 | NR | KAF8557423.1 | 36058 | g8171 | i0 | 49.3 | 0.963800904977376 | 71 | 36 | 96.4 | 0 | 215 | 3 | 413 | 483 | KAF8557423.1 PRMT5-domain-containing protein [Imleria badia] | diamond | 213 | 76.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Boletaceae | Imleria | Imleria badia | |
| 31201031 | 31201031 | PRJDB14274_S_NODE_4175_length_302_cov_1.597510_g4097_i0 | PRJDB14274 | 4175 | 302 | 1.59751 | 4.8244802 | Mycena vulgaris | 1033282 | Fungi | Fungi | 43.9 | 0.0274 | NR | KAJ6527347.1 | 1033282 | g4097 | i0 | 37.8 | 0.894039735099338 | 90 | 43 | 86.4 | 3 | 301 | 41 | 212 | 291 | KAJ6527347.1 hypothetical protein DFH09DRAFT_1414366 [Mycena vulgaris] | diamond | 270 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena vulgaris | |
| 31232882 | 31232882 | PRJDB14274_S_NODE_6115_length_254_cov_1.331606_g6037_i0 | PRJDB14274 | 6115 | 254 | 1.331606 | 3.38227924 | Fomitiporia mediterranea MF3/22 | 694068 | Fungi | Fungi | 43.9 | 0.0164 | NR | XP_007266028.1 | 694068 | g6037 | i0 | 41.8 | 0.649606299212598 | 55 | 31 | 65 | 1 | 81 | 245 | 5 | 58 | XP_007266028.1 uncharacterized protein FOMMEDRAFT_167616 [Fomitiporia mediterranea MF3/22] | diamond | 165 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Fomitiporia | Fomitiporia mediterranea | |
| 32308955 | 32308955 | PRJDB14274_S_NODE_8939_length_212_cov_1.291391_g8861_i0 | PRJDB14274 | 8939 | 212 | 1.291391 | 2.73774892 | Kwoniella heveanensis BCC8398 | 1296120 | Fungi | Fungi | 42.4 | 0.0334 | NR | OCF33127.1 | 1296120 | g8861 | i0 | 50 | 0.594339622641509 | 42 | 21 | 59.4 | 0 | 3 | 128 | 253 | 294 | OCF33127.1 lysophosphatidate acyltransferase [Kwoniella heveanensis BCC8398] | diamond | 126 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella heveanensis | |
| 32524572 | 32524572 | PRJDB14274_S_NODE_7079_length_238_cov_1.367232_g7001_i0 | PRJDB14274 | 7079 | 238 | 1.367232 | 3.25401216 | Tulasnella | 5240 | Fungi | Fungi | 105 | 1.35e-25 | NR | KAG8919841.1 | 2600224 | g7001 | i0 | 64.4 | 5.53361344537815 | 73 | 26 | 92 | 0 | 19 | 237 | 106 | 178 | KAG8919841.1 hypothetical protein FRC00_010845, partial [Tulasnella sp. 408] | diamond | 1317 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 408 |
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);;