contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA675331" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 647677 | 647677 | PRJNA675331_P_NODE_19881_length_248_cov_0.880000_g19709_i0 | PRJNA675331 | 19881 | 248 | 0.88 | 2.1824 | Kwoniella mangrovensis | 463800 | Fungi | Fungi | 237 | 5.77e-58 | NTclustered | gi|2736858679|ref|XM_065517828.1| | 1296122 | g19709 | i0 | 84.064 | 273.129032258065 | 251 | 34 | 100 | 6 | 1 | 248 | 569 | 322 | Kwoniella mangroviensis CBS 8507 polyubiquitin (I203_105727), partial mRNA | blastn | 67736 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella mangrovensis | |
| 647724 | 647724 | PRJNA675331_P_NODE_7921_length_347_cov_1.401460_g7749_i0 | PRJNA675331 | 7921 | 347 | 1.40146 | 4.8630662 | Epithele typhae | 378194 | Fungi | Fungi | 248 | 3.9e-61 | NTclustered | gi|2234710349|ref|XM_048027160.1| | 378194 | g7749 | i0 | 82.456 | 75.463976945245 | 285 | 48 | 82 | 2 | 18 | 301 | 2141 | 1858 | Epithele typhae eukaryotic translation elongation factor 2 (BXZ73DRAFT_96766), partial mRNA | blastn | 26186 | 248 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Epitheliaceae | Epithele | Epithele typhae | |
| 1923859 | 1923859 | PRJNA675331_P_NODE_17622_length_253_cov_1.416667_g17450_i0 | PRJNA675331 | 17622 | 253 | 1.416667 | 3.58416751 | Malassezia restricta | 76775 | Fungi | Fungi | 435 | 1.95e-117 | NTclustered | gi|1546634478|ref|XM_027628899.1| | 76775 | g17450 | i0 | 97.628 | 1 | 253 | 6 | 100 | 0 | 1 | 253 | 1273 | 1525 | Malassezia restricta uncharacterized protein (MRET_2272), partial mRNA | blastn | 253 | 435 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 4475791 | 4475791 | PRJNA675331_P_NODE_3764_length_483_cov_4.585366_g3592_i0 | PRJNA675331 | 3764 | 483 | 4.585366 | 22.14731778 | Malassezia restricta | 76775 | Fungi | Fungi | 891 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g3592 | i0 | 100 | 106.273291925466 | 482 | 0 | 99 | 0 | 1 | 482 | 1455 | 1936 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 51330 | 891 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5751357 | 5751357 | PRJNA675331_P_NODE_6045_length_391_cov_1.132075_g5873_i0 | PRJNA675331 | 6045 | 391 | 1.132075 | 4.42641325 | Ustilago hordei | 120017 | Fungi | Fungi | 209 | 2.1e-49 | NTclustered | gi|2037031892|ref|XM_041557656.1| | 120017 | g5873 | i0 | 79.032 | 55.8951406649616 | 310 | 61 | 79 | 4 | 49 | 356 | 37 | 344 | Ustilago hordei putative SAM2 - S-adenosylmethionine synthetase 2 (UHO2_05942), partial mRNA | blastn | 21855 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Ustilago | Ustilago hordei | |
| 9576279 | 9576279 | PRJNA675331_P_NODE_13408_length_280_cov_0.995169_g13236_i0 | PRJNA675331 | 13408 | 280 | 0.995169 | 2.7864732 | Cutaneotrichosporon cavernicola | 279322 | Fungi | Fungi | 54.7 | 0.007 | NTclustered | gi|2612484376|ref|XM_060598190.1| | 279322 | g13236 | i0 | 100 | 0.103571428571429 | 29 | 0 | 10 | 0 | 227 | 255 | 278 | 250 | Cutaneotrichosporon cavernicola uncharacterized protein (rsd1), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon cavernicola | |
| 12127125 | 12127125 | PRJNA675331_P_NODE_9270_length_325_cov_0.916667_g9098_i0 | PRJNA675331 | 9270 | 325 | 0.916667 | 2.97916775 | Marasmius oreades | 181124 | Fungi | Fungi | 228 | 4.729999999999998e-55 | NTclustered | gi|2083678687|ref|XM_043153773.1| | 181124 | g9098 | i0 | 80.667 | 51.9230769230769 | 300 | 52 | 91 | 6 | 2 | 298 | 382 | 86 | Marasmius oreades GTP-binding nuclear protein gsp1/Ran (GSP1), mRNA | blastn | 16875 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius oreades | |
| 15950493 | 15950493 | PRJNA675331_P_NODE_18073_length_251_cov_0.865169_g17901_i0 | PRJNA675331 | 18073 | 251 | 0.865169 | 2.17157419 | Apiotrichum porosum | 105984 | Fungi | Fungi | 52.8 | 0.023 | NTclustered | gi|1607499260|ref|XM_028621432.1| | 105984 | g17901 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 217 | 244 | 531 | 558 | Apiotrichum porosum Nucleolar Complex 2 protein (NOC2), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 17225743 | 17225743 | PRJNA675331_P_NODE_10254_length_312_cov_0.962343_g10082_i0 | PRJNA675331 | 10254 | 312 | 0.962343 | 3.00251016 | Coprinopsis cinerea | 5346 | Fungi | Fungi | 207 | 5.88e-49 | NTclustered | gi|299748163|ref|XM_001837454.2| | 240176 | g10082 | i0 | 79.798 | 61.7371794871795 | 297 | 50 | 94 | 8 | 21 | 312 | 289 | 580 | Coprinopsis cinerea okayama7#130 hypothetical protein (CC1G_01418), partial mRNA | blastn | 19262 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis cinerea | |
| 17225863 | 17225863 | PRJNA675331_P_NODE_9834_length_317_cov_1.168033_g9662_i0 | PRJNA675331 | 9834 | 317 | 1.168033 | 3.70266461 | Kwoniella botswanensis | 1268659 | Fungi | Fungi | 206 | 2.1499999999999997e-48 | NTclustered | gi|2725014277|ref|XM_064888420.1| | 1268659 | g9662 | i0 | 82.969 | 44.8738170347003 | 229 | 37 | 72 | 2 | 49 | 276 | 456 | 229 | Kwoniella botswanensis polyubiquitin (L199_002681), partial mRNA | blastn | 14225 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella botswanensis |
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);;