contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA753112" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8382410 | 8382410 | PRJNA753112_P_NODE_30527_length_249_cov_0.886364_g30185_i0 | PRJNA753112 | 30527 | 249 | 0.886364 | 2.20704636 | uncultured fungus | 175245 | Fungi | Fungi | 375 | 1.18e-99 | NTclustered | gi|2159200445|emb|OU939076.1| | 175245 | g30185 | i0 | 93.952 | 99.6787148594377 | 248 | 15 | 99 | 0 | 2 | 249 | 921 | 674 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus00371 | blastn | 24820 | 375 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 10933215 | 10933215 | PRJNA753112_P_NODE_5569_length_578_cov_4.958416_g5230_i0 | PRJNA753112 | 5569 | 578 | 4.958416 | 28.65964448 | uncultured Ascomycota | 175243 | Fungi | Fungi | 856 | 0 | NTclustered | gi|313483124|gb|HQ433129.1| | 175243 | g5230 | i0 | 95.064 | 100.384083044983 | 547 | 21 | 94 | 6 | 36 | 578 | 836 | 292 | Uncultured Ascomycota clone asc07192 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 58022 | 856 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | uncultured Ascomycota | |||||
| 16031641 | 16031641 | PRJNA753112_P_NODE_25713_length_269_cov_1.387755_g25371_i0 | PRJNA753112 | 25713 | 269 | 1.387755 | 3.73306095 | Daldinia decipiens | 326647 | Fungi | Fungi | 54.7 | 0.007 | NTclustered | gi|2272156782|ref|XM_049239457.1| | 326647 | g25371 | i0 | 100 | 0.315985130111524 | 29 | 0 | 11 | 0 | 121 | 149 | 331 | 359 | Daldinia decipiens Aldo/keto reductase (F4813DRAFT_193046), mRNA | blastn | 85 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Daldinia | Daldinia decipiens | |
| 17779355 | 17779355 | PRJNA753112_P_NODE_24774_length_274_cov_1.189055_g24432_i0 | PRJNA753112 | 24774 | 274 | 1.189055 | 3.2580107 | Ascomycota | 4890 | Fungi | Fungi | 496 | 9.67e-136 | NTclustered | gi|1758161116|gb|MN543960.1| | 5081 | g24432 | i0 | 99.27 | 99.4124087591241 | 274 | 2 | 100 | 0 | 1 | 274 | 529 | 802 | Penicillium sp. isolate CLE107 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 27239 | 501 | 0.99001996007984 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium sp. | |
| 19053367 | 19053367 | PRJNA753112_P_NODE_27355_length_260_cov_1.454545_g27013_i0 | PRJNA753112 | 27355 | 260 | 1.454545 | 3.781817 | Cladosporium | 5498 | Fungi | Fungi | 481 | 2.55e-131 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g27013 | i0 | 100 | 80.5115384615385 | 260 | 0 | 100 | 0 | 1 | 260 | 3275 | 3016 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 20933 | 481 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 20328177 | 20328177 | PRJNA753112_P_NODE_32756_length_244_cov_0.912281_g32414_i0 | PRJNA753112 | 32756 | 244 | 0.912281 | 2.22596564 | Dothideomycetes | 147541 | Fungi | Fungi | 451 | 1.86e-122 | NTclustered | gi|910265363|gb|KT309625.1| | 5454 | g32414 | i0 | 100 | 100 | 244 | 0 | 100 | 0 | 1 | 244 | 267 | 24 | Didymella rabiei culture-collection ICMP:10299 28S ribosomal RNA gene, partial sequence | blastn | 24400 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Ascochyta | Ascochyta rabiei | |
| 22879137 | 22879137 | PRJNA753112_P_NODE_20838_length_297_cov_3.107143_g20496_i0 | PRJNA753112 | 20838 | 297 | 3.107143 | 9.22821471 | Malassezia | 55193 | Fungi | Fungi | 547 | 2.8899999999999992e-151 | NTclustered | gi|724086716|gb|KM269140.1| | 76773 | g20496 | i0 | 100 | 99.1178451178451 | 296 | 0 | 99 | 0 | 2 | 297 | 1203 | 908 | Malassezia globosa strain 123.1 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 | 29438 | 547 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa |
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);;