contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJEB55250" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1396299 | 1396299 | PRJEB55250_P_NODE_7662_length_279_cov_1.271845_g7538_i0 | PRJEB55250 | 7662 | 279 | 1.271845 | 3.54844755 | Ustilago bromivora | 307758 | Fungi | Fungi | 244 | 3.95e-60 | NTclustered | gi|1098870294|emb|LT558140.1| | 307758 | g7538 | i0 | 95.455 | 14.7347670250896 | 154 | 6 | 55 | 1 | 126 | 279 | 104682 | 104530 | Ustilago bromivora strain UB2112 genome assembly, organelle: mitochondrion | blastn | 4111 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Ustilago | Ustilago bromivora | |
| 4819832 | 4819832 | PRJEB55250_P_NODE_4484_length_328_cov_3.321569_g4360_i0 | PRJEB55250 | 4484 | 328 | 3.321569 | 10.89474632 | Udeniomyces | 42658 | Fungi | Fungi | 601 | 2.4399999999999998e-167 | NTclustered | gi|1102646410|gb|KY109980.1| | 42659 | g4360 | i0 | 99.695 | 99.9329268292683 | 328 | 1 | 100 | 0 | 1 | 328 | 798 | 471 | Udeniomyces megalosporus culture CBS:7359 large subunit ribosomal RNA gene, partial sequence | blastn | 32778 | 601 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Udeniomyces | Udeniomyces megalosporus | |
| 6500057 | 6500057 | PRJEB55250_P_NODE_4546_length_327_cov_1.141732_g4422_i0 | PRJEB55250 | 4546 | 327 | 1.141732 | 3.73346364 | Malassezia globosa | 76773 | Fungi | Fungi | 604 | 1.8799999999999993e-168 | NTclustered | gi|1321659477|gb|KY911087.1| | 76773 | g4422 | i0 | 100 | 44.0642201834862 | 327 | 0 | 100 | 0 | 1 | 327 | 30383 | 30057 | Malassezia globosa mitochondrion, complete genome | blastn | 14409 | 604 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 7774256 | 7774256 | PRJEB55250_P_NODE_4307_length_333_cov_7.092308_g4183_i0 | PRJEB55250 | 4307 | 333 | 7.092308 | 23.61738564 | Malassezia restricta | 76775 | Fungi | Fungi | 448 | 3.4299999999999995e-121 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g4183 | i0 | 91.617 | 73.4264264264264 | 334 | 13 | 100 | 11 | 1 | 333 | 3294 | 2975 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 24451 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 12875437 | 12875437 | PRJEB55250_P_NODE_6611_length_287_cov_1.439252_g6487_i0 | PRJEB55250 | 6611 | 287 | 1.439252 | 4.13065324 | Malassezia restricta | 76775 | Fungi | Fungi | 525 | 1.2999999999999995e-144 | NTclustered | gi|1546635218|ref|XM_027629268.1| | 76775 | g6487 | i0 | 99.652 | 1 | 287 | 1 | 100 | 0 | 1 | 287 | 744 | 1030 | Malassezia restricta uncharacterized protein (MRET_2641), partial mRNA | blastn | 287 | 525 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14149961 | 14149961 | PRJEB55250_P_NODE_10412_length_258_cov_1.664865_g10288_i0 | PRJEB55250 | 10412 | 258 | 1.664865 | 4.2953517 | Malassezia globosa | 76773 | Fungi | Fungi | 438 | 1.5399999999999995e-118 | NTclustered | gi|164661268|ref|XM_001731705.1| | 425265 | g10288 | i0 | 97.287 | 1 | 258 | 7 | 100 | 0 | 1 | 258 | 1502 | 1245 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_1025), partial mRNA | blastn | 258 | 438 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 14150229 | 14150229 | PRJEB55250_P_NODE_6752_length_286_cov_1.446009_g6628_i0 | PRJEB55250 | 6752 | 286 | 1.446009 | 4.13558574 | Malassezia restricta | 76775 | Fungi | Fungi | 529 | 1e-145 | NTclustered | gi|1546634998|ref|XM_027629158.1| | 76775 | g6628 | i0 | 100 | 1 | 286 | 0 | 100 | 0 | 1 | 286 | 1308 | 1593 | Malassezia restricta oxidoreductase (MRET_2531), partial mRNA | blastn | 286 | 529 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 16698310 | 16698310 | PRJEB55250_P_NODE_11094_length_253_cov_1.711111_g10970_i0 | PRJEB55250 | 11094 | 253 | 1.711111 | 4.32911083 | Polyporus melanopus | 40486 | Fungi | Fungi | 401 | 1.9799999999999994e-107 | NTclustered | gi|1859735583|gb|MT644901.1| | 40486 | g10970 | i0 | 95.257 | 103.343873517787 | 253 | 12 | 100 | 0 | 1 | 253 | 1860 | 2112 | Polyporus melanopus isolate DM1069 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 26146 | 401 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Polyporus | Polyporus melanopus | |
| 17569714 | 17569714 | PRJEB55250_P_NODE_2654_length_405_cov_4.030120_g2531_i0 | PRJEB55250 | 2654 | 405 | 4.03012 | 16.321986 | Malassezia | 55193 | Fungi | Fungi | 743 | 0 | NTclustered | gi|953821272|gb|KT310070.1| | 76773 | g2531 | i0 | 99.753 | 86.9308641975309 | 405 | 1 | 100 | 0 | 1 | 405 | 333 | 737 | Malassezia globosa isolate 1242 large subunit ribosomal RNA gene, partial sequence | blastn | 35207 | 743 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 19247286 | 19247286 | PRJEB55250_P_NODE_14156_length_246_cov_0.890173_g14032_i0 | PRJEB55250 | 14156 | 246 | 0.890173 | 2.18982558 | Malassezia restricta | 76775 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|1546636883|ref|XM_027630084.1| | 76775 | g14032 | i0 | 100 | 1 | 246 | 0 | 100 | 0 | 1 | 246 | 1215 | 970 | Malassezia restricta serine/threonine-protein phosphatase 5 (MRET_3457), partial mRNA | blastn | 246 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20522848 | 20522848 | PRJEB55250_P_NODE_9257_length_267_cov_1.293814_g9133_i0 | PRJEB55250 | 9257 | 267 | 1.293814 | 3.45448338 | Malassezia restricta | 76775 | Fungi | Fungi | 483 | 7.31e-132 | NTclustered | gi|1546635392|ref|XM_027629355.1| | 76775 | g9133 | i0 | 99.251 | 1 | 267 | 2 | 100 | 0 | 1 | 267 | 459 | 193 | Malassezia restricta DNA-(apurinic or apyrimidinic site) lyase (MRET_2728), partial mRNA | blastn | 267 | 483 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 22668736 | 22668736 | PRJEB55250_P_NODE_14798_length_244_cov_1.801170_g14674_i0 | PRJEB55250 | 14798 | 244 | 1.80117 | 4.3948548 | Malassezia | 55193 | Fungi | Fungi | 451 | 1.86e-122 | NTclustered | gi|398360769|gb|JX132826.1| | 338567 | g14674 | i0 | 100 | 100.954918032787 | 244 | 0 | 100 | 0 | 1 | 244 | 269 | 26 | Uncultured Malassezia clone CEas161 26S ribosomal RNA gene, partial sequence | blastn | 24633 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | uncultured Malassezia |
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);;