contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA879314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8510824 | 8510824 | PRJNA879314_P_NODE_6707_length_249_cov_0.886364_g6657_i0 | PRJNA879314 | 6707 | 249 | 0.886364 | 2.20704636 | Lentinus tigrinus | 5365 | Fungi | Fungi | 110 | 1.32e-19 | NTclustered | gi|2797376130|ref|XM_067677658.1| | 1328758 | g6657 | i0 | 86.139 | 0.405622489959839 | 101 | 14 | 41 | 0 | 1 | 101 | 28 | 128 | Lentinus tigrinus ALCF2SS1-7 MAS20-domain-containing protein (L226DRAFT_498300), partial mRNA | blastn | 101 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus tigrinus | |
| 9785696 | 9785696 | PRJNA879314_P_NODE_3008_length_287_cov_1.070093_g2958_i0 | PRJNA879314 | 3008 | 287 | 1.070093 | 3.07116691 | Ganoderma boninense | 34458 | Fungi | Fungi | 99 | 3.36e-16 | NTclustered | gi|1768659916|emb|LR727948.1| | 34458 | g2958 | i0 | 93.846 | 0.226480836236934 | 65 | 4 | 23 | 0 | 223 | 287 | 488 | 424 | Ganoderma boninense G5EHQ9 gene for NmrA domain-containing protein | blastn | 65 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma boninense | |
| 12337013 | 12337013 | PRJNA879314_P_NODE_9050_length_246_cov_0.872832_g9000_i0 | PRJNA879314 | 9050 | 246 | 0.872832 | 2.14716672 | Apiotrichum porosum | 105984 | Fungi | Fungi | 52.8 | 0.022 | NTclustered | gi|1607528374|ref|XM_028617027.1| | 105984 | g9000 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 145 | 172 | 1003 | 976 | Apiotrichum porosum uncharacterized protein (EHS24_001226), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 16160482 | 16160482 | PRJNA879314_P_NODE_10373_length_243_cov_0.917647_g10323_i0 | PRJNA879314 | 10373 | 243 | 0.917647 | 2.22988221 | Ganoderma subamboinense | 34466 | Fungi | Fungi | 401 | 1.8899999999999993e-107 | NTclustered | gi|2192917214|ref|NC_060422.1| | 34466 | g10323 | i0 | 96.708 | 7.31687242798354 | 243 | 5 | 100 | 1 | 1 | 243 | 61136 | 61375 | Ganoderma subamboinense mitochondrion, complete sequence | blastn | 1778 | 401 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma subamboinense | |
| 18709287 | 18709287 | PRJNA879314_P_NODE_7795_length_248_cov_0.862857_g7745_i0 | PRJNA879314 | 7795 | 248 | 0.862857 | 2.13988536 | Ganoderma boninense | 34458 | Fungi | Fungi | 150 | 7.729999999999999e-32 | NTclustered | gi|1768655236|emb|LR725853.1| | 34458 | g7745 | i0 | 94.792 | 0.725806451612903 | 96 | 5 | 72 | 0 | 1 | 96 | 2065 | 1970 | Ganoderma boninense Q8Y8N0 gene for ATP-dependent RNA helicase CshA (EC 3.6.4.13) | blastn | 180 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma boninense | |
| 19091887 | 19091887 | PRJNA879314_P_NODE_2115_length_322_cov_1.566265_g2065_i0 | PRJNA879314 | 2115 | 322 | 1.566265 | 5.0433733 | Agaricomycetes | 155619 | Fungi | Fungi | 534 | 2.46e-147 | NTclustered | gi|827046364|ref|NC_027188.1| | 29884 | g2065 | i0 | 97.152 | 5.88509316770186 | 316 | 9 | 98 | 0 | 7 | 322 | 4364 | 4049 | Ganoderma applanatum strain CGMCC5.249 mitochondrion, complete genome | blastn | 1895 | 536 | 0.996268656716418 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma applanatum | |
| 20366700 | 20366700 | PRJNA879314_P_NODE_1716_length_346_cov_0.857143_g1666_i0 | PRJNA879314 | 1716 | 346 | 0.857143 | 2.96571478 | Polyporaceae | 5317 | Fungi | Fungi | 569 | 7.31e-158 | NTclustered | gi|2206971136|ref|NC_061293.1| | 1173714 | g1666 | i0 | 96.264 | 66.7109826589595 | 348 | 11 | 100 | 2 | 1 | 346 | 6220 | 5873 | Ganoderma multipileum mitochondrion, complete genome | blastn | 23082 | 569 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma multipileum | |
| 22534558 | 22534558 | PRJNA879314_P_NODE_4878_length_252_cov_1.307263_g4828_i0 | PRJNA879314 | 4878 | 252 | 1.307263 | 3.29430276 | Ganoderma resinaceum | 34465 | Fungi | Fungi | 298 | 2.66e-76 | NTclustered | gi|2713138142|emb|OZ026805.1| | 34465 | g4828 | i0 | 89.167 | 1.96825396825397 | 240 | 24 | 95 | 2 | 1 | 240 | 1813 | 2050 | Ganoderma resinaceum genome assembly, organelle: mitochondrion | blastn | 496 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma resinaceum | |
| 23810009 | 23810009 | PRJNA879314_P_NODE_1919_length_332_cov_1.100386_g1869_i0 | PRJNA879314 | 1919 | 332 | 1.100386 | 3.65328152 | Ganoderma applanatum | 29884 | Fungi | Fungi | 564 | 3.2499999999999996e-156 | NTclustered | gi|827046364|ref|NC_027188.1| | 29884 | g1869 | i0 | 97.289 | 10.9939759036145 | 332 | 9 | 100 | 0 | 1 | 332 | 76220 | 75889 | Ganoderma applanatum strain CGMCC5.249 mitochondrion, complete genome | blastn | 3650 | 564 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma applanatum | |
| 23810100 | 23810100 | PRJNA879314_P_NODE_9939_length_244_cov_0.912281_g9889_i0 | PRJNA879314 | 9939 | 244 | 0.912281 | 2.22596564 | Ganoderma multipileum | 1173714 | Fungi | Fungi | 451 | 1.86e-122 | NTclustered | gi|2206971136|ref|NC_061293.1| | 1173714 | g9889 | i0 | 100 | 54.5040983606557 | 244 | 0 | 100 | 0 | 1 | 244 | 42278 | 42521 | Ganoderma multipileum mitochondrion, complete genome | blastn | 13299 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma multipileum |
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);;