contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA807836" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 807124 | 807124 | PRJNA807836_S_NODE_23761_length_275_cov_1.826733_g23485_i0 | PRJNA807836 | 23761 | 275 | 1.826733 | 5.02351575 | Sporisorium graminicola | 280036 | Fungi | Fungi | 60.2 | 1.51e-4 | NTclustered | gi|1701856799|ref|XM_029886318.1| | 280036 | g23485 | i0 | 100 | 8.21090909090909 | 32 | 0 | 12 | 0 | 130 | 161 | 2293 | 2324 | Sporisorium graminicola uncharacterized protein (EX895_005726), partial mRNA | blastn | 2258 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Sporisorium | Sporisorium graminicola | |
| 2082956 | 2082956 | PRJNA807836_S_NODE_27802_length_250_cov_0.870056_g27526_i0 | PRJNA807836 | 27802 | 250 | 0.870056 | 2.17514 | Melampsora laricis-populina | 203908 | Fungi | Fungi | 444 | 3.1999999999999986e-120 | NTclustered | gi|599373429|ref|XM_007407306.1| | 747676 | g27526 | i0 | 98.8 | 1 | 250 | 2 | 100 | 1 | 1 | 250 | 1420 | 1172 | Melampsora larici-populina 98AG31 uncharacterized protein (MELLADRAFT_47456), partial mRNA | blastn | 250 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora laricis-populina | |
| 13560764 | 13560764 | PRJNA807836_S_NODE_23091_length_280_cov_1.483092_g22815_i0 | PRJNA807836 | 23091 | 280 | 1.483092 | 4.1526576 | Heterobasidion irregulare | 984962 | Fungi | Fungi | 65.8 | 3.31e-6 | NTclustered | gi|695572815|ref|XM_009553142.1| | 747525 | g22815 | i0 | 100 | 20.9642857142857 | 35 | 0 | 13 | 0 | 192 | 226 | 701 | 735 | Heterobasidion irregulare TC 32-1 glyoxal oxidase 5 (glox5), partial mRNA | blastn | 5870 | 65.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Bondarzewiaceae | Heterobasidion | Heterobasidion irregulare | |
| 25033606 | 25033606 | PRJNA807836_S_NODE_23860_length_274_cov_2.288557_g23584_i0 | PRJNA807836 | 23860 | 274 | 2.288557 | 6.27064618 | Rhodotorula toruloides | 5286 | Fungi | Fungi | 58.4 | 5.41e-4 | NTclustered | gi|1022851889|ref|XM_016415630.1| | 1130832 | g23584 | i0 | 97.059 | 0.124087591240876 | 34 | 1 | 12 | 0 | 136 | 169 | 446 | 479 | Rhodotorula toruloides NP11 RNA recognition motif domain containing protein (RHTO_01951), partial mRNA | blastn | 34 | 58.4 | 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);;