contig_metadata
5 rows where bioproject = "PRJNA885753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8514625 | 8514625 | PRJNA885753_S_NODE_3487_length_256_cov_1.491803_g3469_i0 | PRJNA885753 | 3487 | 256 | 1.491803 | 3.81901568 | Penicillium ramusculum | 449096 | Fungi | Fungi | 468 | 1.95e-127 | NTclustered | gi|1804071990|ref|NG_067364.1| | 449096 | g3469 | i0 | 99.609 | 99.90625 | 256 | 1 | 100 | 0 | 1 | 256 | 332 | 587 | Penicillium ramusculum CBS 251.56 28S rRNA gene, partial sequence; from TYPE material | blastn | 25576 | 468 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium ramusculum | |
| 8894213 | 8894213 | PRJNA885753_S_NODE_2047_length_314_cov_1.668050_g2029_i0 | PRJNA885753 | 2047 | 314 | 1.66805 | 5.237677 | Penicillium | 5073 | Fungi | Fungi | 579 | 1.0899999999999999e-160 | NTclustered | gi|2473854176|gb|OQ729762.1| | 5081 | g2029 | i0 | 100 | 99.6783439490446 | 313 | 0 | 99 | 0 | 2 | 314 | 364 | 52 | Penicillium sp. isolate clinic large subunit ribosomal RNA gene, partial sequence | blastn | 31299 | 579 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium sp. | |
| 10169937 | 10169937 | PRJNA885753_S_NODE_3588_length_254_cov_1.121547_g3570_i0 | PRJNA885753 | 3588 | 254 | 1.121547 | 2.84872938 | Pleosporales | 92860 | Fungi | Fungi | 459 | 1.1599999999999999e-124 | NTclustered | gi|154563031|gb|EF590321.2| | 215456 | g3570 | i0 | 99.213 | 119.799212598425 | 254 | 2 | 100 | 0 | 1 | 254 | 1411 | 1664 | Phaeosphaeria avenaria f. sp. avenaria strain ATCC 12277 large subunit ribosomal RNA gene, partial sequence | blastn | 30429 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora avenae | |
| 14889691 | 14889691 | PRJNA885753_S_NODE_2392_length_297_cov_1.607143_g2374_i0 | PRJNA885753 | 2392 | 297 | 1.607143 | 4.77321471 | Radiomyces spectabilis | 64574 | Fungi | Fungi | 71.3 | 7.62e-8 | NTclustered | gi|2323760749|ref|XM_051570446.1| | 64574 | g2374 | i0 | 100 | 0.498316498316498 | 38 | 0 | 13 | 0 | 260 | 297 | 542 | 505 | Radiomyces spectabilis 40S ribosomal protein S16 (BYT42DRAFT_590070), mRNA | blastn | 148 | 71.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 25468009 | 25468009 | PRJNA885753_S_NODE_1380_length_368_cov_2.698305_g1362_i0 | PRJNA885753 | 1380 | 368 | 2.698305 | 9.9297624 | Aspergillaceae | 1131492 | Fungi | Fungi | 647 | 0 | NTclustered | gi|2582615798|ref|XR_009468002.1| | 5061 | g1362 | i0 | 98.37 | 107.010869565217 | 368 | 6 | 100 | 0 | 1 | 368 | 1476 | 1843 | Aspergillus niger 28S ribosomal RNA (28S rRNA), partial rRNA | blastn | 39380 | 647 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger |
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);;