contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA951388" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 934777 | 934777 | PRJNA951388_S_NODE_5121_length_371_cov_2.218121_g4994_i0 | PRJNA951388 | 5121 | 371 | 2.218121 | 8.22922891 | Malassezia restricta | 76775 | Fungi | Fungi | 652 | 0 | NTclustered | gi|902264999|gb|KR998250.1| | 76775 | g4994 | i0 | 98.383 | 2 | 371 | 6 | 100 | 0 | 1 | 371 | 507 | 877 | Malassezia restricta strain ATCC 96810 lipase (lip1) gene, complete cds | blastn | 742 | 652 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 2210016 | 2210016 | PRJNA951388_S_NODE_10402_length_255_cov_4.615385_g10275_i0 | PRJNA951388 | 10402 | 255 | 4.615385 | 11.76923175 | Wolfiporia cocos | 81056 | Fungi | Fungi | 472 | 1.5e-128 | NTclustered | gi|126508724|gb|EF397600.1| | 81056 | g10275 | i0 | 100 | 107.058823529412 | 255 | 0 | 100 | 0 | 1 | 255 | 1524 | 1778 | Poria cocos strain KANP No. 7233 28S ribosomal RNA gene, partial sequence | blastn | 27300 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phaeolaceae | Wolfiporia | Wolfiporia cocos | |
| 4763099 | 4763099 | PRJNA951388_S_NODE_10684_length_251_cov_2.674157_g10557_i0 | PRJNA951388 | 10684 | 251 | 2.674157 | 6.71213407 | Filobasidium floriforme | 5210 | Fungi | Fungi | 372 | 1.54e-98 | NTclustered | gi|2185539042|ref|XM_046176727.1| | 5210 | g10557 | i0 | 96.444 | 0.896414342629482 | 225 | 8 | 90 | 0 | 1 | 225 | 2169 | 2393 | Filobasidium floriforme uncharacterized protein (HD553DRAFT_149098), mRNA | blastn | 225 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 8587740 | 8587740 | PRJNA951388_S_NODE_9127_length_277_cov_1.720588_g9000_i0 | PRJNA951388 | 9127 | 277 | 1.720588 | 4.76602876 | Malassezia restricta | 76775 | Fungi | Fungi | 512 | 9.73e-141 | NTclustered | gi|1546632162|ref|XM_027627741.1| | 76775 | g9000 | i0 | 100 | 1 | 277 | 0 | 100 | 0 | 1 | 277 | 2030 | 2306 | Malassezia restricta heat shock 70kDa protein 4 (MRET_1114), partial mRNA | blastn | 277 | 512 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 13688388 | 13688388 | PRJNA951388_S_NODE_10071_length_260_cov_5.160428_g9944_i0 | PRJNA951388 | 10071 | 260 | 5.160428 | 13.4171128 | Malassezia restricta | 76775 | Fungi | Fungi | 182 | 2.9e-41 | NTclustered | gi|1546631125|ref|XM_027627223.1| | 76775 | g9944 | i0 | 99.01 | 0.388461538461538 | 101 | 1 | 39 | 0 | 1 | 101 | 272 | 372 | Malassezia restricta uncharacterized protein (MRET_0596), partial mRNA | blastn | 101 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 13688413 | 13688413 | PRJNA951388_S_NODE_7171_length_317_cov_17.631148_g7044_i0 | PRJNA951388 | 7171 | 317 | 17.631148 | 55.89073916 | Hericium alpestre | 135208 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2489641794|ref|NC_073556.1| | 135208 | g7044 | i0 | 96.97 | 0.536277602523659 | 33 | 1 | 10 | 0 | 114 | 146 | 27974 | 27942 | Hericium alpestre mitochondrion, complete genome | blastn | 170 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Hericiaceae | Hericium | Hericium alpestre | |
| 17512901 | 17512901 | PRJNA951388_S_NODE_9894_length_263_cov_2.294737_g9767_i0 | PRJNA951388 | 9894 | 263 | 2.294737 | 6.03515831 | Malassezia globosa | 76773 | Fungi | Fungi | 459 | 1.21e-124 | NTclustered | gi|164658424|ref|XM_001730286.1| | 425265 | g9767 | i0 | 98.099 | 1 | 263 | 5 | 100 | 0 | 1 | 263 | 2156 | 1894 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2720), partial mRNA | blastn | 263 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 20061392 | 20061392 | PRJNA951388_S_NODE_11316_length_243_cov_0.905882_g11189_i0 | PRJNA951388 | 11316 | 243 | 0.905882 | 2.20129326 | Malassezia restricta | 76775 | Fungi | Fungi | 309 | 1.1800000000000002e-79 | NTclustered | gi|1546633708|ref|XM_027628514.1| | 76775 | g11189 | i0 | 99.415 | 9.37037037037037 | 171 | 0 | 70 | 1 | 15 | 184 | 171 | 1 | Malassezia restricta small subunit ribosomal protein S29e (MRET_1887), partial mRNA | blastn | 2277 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21336847 | 21336847 | PRJNA951388_S_NODE_9437_length_271_cov_3.111111_g9310_i0 | PRJNA951388 | 9437 | 271 | 3.111111 | 8.43111081 | Malassezia restricta | 76775 | Fungi | Fungi | 411 | 3.5599999999999996e-110 | NTclustered | gi|1546638199|ref|XM_027630741.1| | 76775 | g9310 | i0 | 100 | 0.819188191881919 | 222 | 0 | 82 | 0 | 50 | 271 | 1122 | 901 | Malassezia restricta large subunit ribosomal protein L4e (MRET_4114), partial mRNA | blastn | 222 | 411 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 22611758 | 22611758 | PRJNA951388_S_NODE_4418_length_394_cov_1.623053_g4291_i0 | PRJNA951388 | 4418 | 394 | 1.623053 | 6.39482882 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.038 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g4291 | i0 | 100 | 0.0710659898477157 | 28 | 0 | 7 | 0 | 367 | 394 | 30 | 3 | Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus luteus |
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);;