contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA451191" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5544856 | 5544856 | PRJNA451191_P_NODE_55365_length_202_cov_0.921986_g55094_i0 | PRJNA451191 | 55365 | 202 | 0.921986 | 1.86241172 | Puccinia graminis | 5297 | Fungi | Fungi | 296 | 7.36e-76 | NTclustered | gi|3168|emb|Z11586.1| | 5297 | g55094 | i0 | 96.154 | 139.326732673267 | 182 | 4 | 89 | 3 | 1 | 179 | 182 | 1 | P.graminis large subunit ribosomal RNA gene (partial) | blastn | 28144 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia graminis | |
| 6195728 | 6195728 | PRJNA451191_P_NODE_42145_length_219_cov_1.898734_g41874_i0 | PRJNA451191 | 42145 | 219 | 1.898734 | 4.15822746 | Opisthokonta | 33154 | Fungi | Fungi | 394 | 2.79e-105 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g41874 | i0 | 99.087 | 98.7945205479452 | 219 | 2 | 100 | 0 | 1 | 219 | 835 | 617 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 21636 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7470680 | 7470680 | PRJNA451191_P_NODE_39886_length_225_cov_3.079268_g39615_i0 | PRJNA451191 | 39886 | 225 | 3.079268 | 6.928353 | Opisthokonta | 33154 | Fungi | Fungi | 416 | 6.159999999999998e-112 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g39615 | i0 | 100 | 100 | 225 | 0 | 100 | 0 | 1 | 225 | 203 | 427 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 22500 | 416 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10644029 | 10644029 | PRJNA451191_P_NODE_23409_length_294_cov_4.480687_g23138_i0 | PRJNA451191 | 23409 | 294 | 4.480687 | 13.17321978 | Malassezia restricta | 76775 | Fungi | Fungi | 381 | 3.059999999999999e-101 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g23138 | i0 | 90.847 | 72.6904761904762 | 295 | 12 | 100 | 11 | 1 | 294 | 3002 | 3282 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 21371 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 12571639 | 12571639 | PRJNA451191_P_NODE_56510_length_193_cov_2.727273_g56239_i0 | PRJNA451191 | 56510 | 193 | 2.727273 | 5.26363689 | Basidiomycota | 5204 | Fungi | Fungi | 357 | 3.1499999999999996e-94 | NTclustered | gi|996412224|gb|KJ708433.1| | 5435 | g56239 | i0 | 100 | 99.9378238341969 | 193 | 0 | 100 | 0 | 1 | 193 | 1608 | 1416 | Symmetrospora gracilis 18S ribosomal RNA gene, partial sequence | blastn | 19288 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Symmetrosporaceae | Symmetrospora | Symmetrospora gracilis | ||
| 17018190 | 17018190 | PRJNA451191_P_NODE_45614_length_211_cov_0.866667_g45343_i0 | PRJNA451191 | 45614 | 211 | 0.866667 | 1.82866737 | Wallemia mellicola | 1708541 | Fungi | Fungi | 206 | 1.34e-48 | NTclustered | gi|588258180|ref|XM_006958189.1| | 671144 | g45343 | i0 | 100 | 0.800947867298578 | 111 | 0 | 80 | 0 | 101 | 211 | 351 | 241 | Wallemia mellicola CBS 633.66 WD40 repeat-like protein mRNA | blastn | 169 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia mellicola | |
| 17018240 | 17018240 | PRJNA451191_P_NODE_47634_length_209_cov_0.878378_g47363_i0 | PRJNA451191 | 47634 | 209 | 0.878378 | 1.83581002 | Malassezia globosa | 76773 | Fungi | Fungi | 342 | 9.709999999999999e-90 | NTclustered | gi|164654991|ref|XM_001728576.1| | 425265 | g47363 | i0 | 96.172 | 1.15311004784689 | 209 | 8 | 100 | 0 | 1 | 209 | 913 | 705 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_4227), partial mRNA | blastn | 241 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 20218930 | 20218930 | PRJNA451191_P_NODE_43496_length_215_cov_2.785714_g43225_i0 | PRJNA451191 | 43496 | 215 | 2.785714 | 5.9892851 | Eukaryota | 2759 | Fungi | Fungi | 398 | 2.1099999999999997e-106 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g43225 | i0 | 100 | 99.7953488372093 | 215 | 0 | 100 | 0 | 1 | 215 | 1681 | 1467 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 21456 | 398 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20842375 | 20842375 | PRJNA451191_P_NODE_40057_length_225_cov_1.585366_g39786_i0 | PRJNA451191 | 40057 | 225 | 1.585366 | 3.5670735 | Rhodotorula glutinis | 5535 | Fungi | Fungi | 405 | 1.33e-108 | NTclustered | gi|225134685|gb|FJ345357.1| | 5535 | g39786 | i0 | 99.111 | 96.8 | 225 | 2 | 100 | 0 | 1 | 225 | 2369 | 2145 | Rhodotorula glutinis strain ATCC 16726 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 21780 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula glutinis | |
| 20842567 | 20842567 | PRJNA451191_P_NODE_46037_length_211_cov_0.866667_g45766_i0 | PRJNA451191 | 46037 | 211 | 0.866667 | 1.82866737 | Malassezia japonica | 223818 | Fungi | Fungi | 285 | 1.68e-72 | NTclustered | gi|2594594551|ref|XM_060268229.1| | 223818 | g45766 | i0 | 91.707 | 4.11374407582938 | 205 | 17 | 97 | 0 | 7 | 211 | 1 | 205 | Malassezia japonica uncharacterized protein (MJAP1_004312), partial mRNA | blastn | 868 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica |
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);;