contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA833575" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5927395 | 5927395 | PRJNA833575_P_NODE_26065_length_292_cov_0.914798_g25928_i0 | PRJNA833575 | 26065 | 292 | 0.914798 | 2.6712101599999998 | Gloeophyllum sepiarium | 40444 | Fungi | Fungi | 339 | 1.86e-88 | NTclustered | gi|34915795|emb|AJ583432.1| | 40444 | g25928 | i0 | 87.713 | 92.8835616438356 | 293 | 32 | 100 | 4 | 1 | 292 | 3235 | 2946 | Gloeophyllum sepiarium 28S rRNA gene, isolate P198 | blastn | 27122 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gloeophyllales | Gloeophyllaceae | Gloeophyllum | Gloeophyllum sepiarium | |
| 7202293 | 7202293 | PRJNA833575_P_NODE_12926_length_404_cov_1.719403_g12789_i0 | PRJNA833575 | 12926 | 404 | 1.719403 | 6.94638812 | Kwoniella shandongensis | 1734106 | Fungi | Fungi | 189 | 2.8299999999999998e-43 | NTclustered | gi|1799713775|ref|XM_032003036.1| | 1734106 | g12789 | i0 | 83.495 | 41.6683168316832 | 206 | 30 | 50 | 4 | 18 | 221 | 24 | 227 | Kwoniella shandongensis 60S ribosomal protein uL15 (CI109_100300), partial mRNA | blastn | 16834 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shandongensis | |
| 8477217 | 8477217 | PRJNA833575_P_NODE_32747_length_259_cov_1.468421_g32610_i0 | PRJNA833575 | 32747 | 259 | 1.468421 | 3.80321039 | Rhodotorula graminis | 29898 | Fungi | Fungi | 52.8 | 0.024 | NTclustered | gi|1069917442|ref|XM_018413066.1| | 578459 | g32610 | i0 | 91.892 | 0.142857142857143 | 37 | 3 | 14 | 0 | 2 | 38 | 639 | 675 | Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_32945), partial mRNA | blastn | 37 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 12303583 | 12303583 | PRJNA833575_P_NODE_34030_length_253_cov_1.826087_g33893_i0 | PRJNA833575 | 34030 | 253 | 1.826087 | 4.62000011 | Epithele typhae | 378194 | Fungi | Fungi | 122 | 1.73e-23 | NTclustered | gi|2234710531|ref|XM_048018404.1| | 378194 | g33893 | i0 | 81.879 | 12.9209486166008 | 149 | 23 | 58 | 4 | 20 | 166 | 192 | 46 | Epithele typhae mitochondrial carrier (BXZ73DRAFT_39567), partial mRNA | blastn | 3269 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Epitheliaceae | Epithele | Epithele typhae |
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);;