contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA753112" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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);;