contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA930380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2184807 | 2184807 | PRJNA930380_P_NODE_542_length_812_cov_1.504736_g493_i0 | PRJNA930380 | 542 | 812 | 1.504736 | 12.21845632 | Sclerotinia sclerotiorum | 5180 | Fungi | Fungi | 1495 | 0 | NTclustered | gi|156036075|ref|XM_001586099.1| | 665079 | g493 | i0 | 99.877 | 1.70689655172414 | 812 | 1 | 100 | 0 | 1 | 812 | 1065 | 254 | Sclerotinia sclerotiorum 1980 UF-70 hypothetical protein partial mRNA | blastn | 1386 | 1495 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Sclerotinia | Sclerotinia sclerotiorum | |
| 4737710 | 4737710 | PRJNA930380_P_NODE_13804_length_243_cov_0.905882_g13751_i0 | PRJNA930380 | 13804 | 243 | 0.905882 | 2.20129326 | Penicillium solitum | 60172 | Fungi | Fungi | 449 | 6.65e-122 | NTclustered | gi|357196637|ref|NC_016187.1| | 60172 | g13751 | i0 | 100 | 54.5679012345679 | 243 | 0 | 100 | 0 | 1 | 243 | 6119 | 6361 | Penicillium solitum mitochondrion, complete genome | blastn | 13260 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium solitum | |
| 10183590 | 10183590 | PRJNA930380_P_NODE_3088_length_363_cov_3.010345_g3035_i0 | PRJNA930380 | 3088 | 363 | 3.010345 | 10.92755235 | Elsinoe | 40996 | Fungi | Fungi | 665 | 0 | NTclustered | gi|2166975980|gb|OL898501.1| | 302913 | g3035 | i0 | 99.725 | 95.1900826446281 | 363 | 1 | 100 | 0 | 1 | 363 | 1052 | 690 | Elsinoe ampelina strain CECT 20119 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 34554 | 665 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Myriangiales | Elsinoaceae | Elsinoe | Elsinoe ampelina | |
| 11112908 | 11112908 | PRJNA930380_P_NODE_11109_length_255_cov_1.269231_g11056_i0 | PRJNA930380 | 11109 | 255 | 1.269231 | 3.23653905 | Saccharomycodes ludwigii | 36035 | Fungi | Fungi | 52.8 | 0.023 | NTclustered | gi|2185212228|ref|XM_046078229.1| | 36035 | g11056 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 98 | 125 | 1480 | 1453 | Saccharomycodes ludwigii uncharacterized protein (SCDLUD_003694), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycodales | Saccharomycodaceae | Saccharomycodes | Saccharomycodes ludwigii | |
| 11112937 | 11112937 | PRJNA930380_P_NODE_12129_length_249_cov_0.875000_g12076_i0 | PRJNA930380 | 12129 | 249 | 0.875 | 2.17875 | Thyridium curvatum | 1093900 | Fungi | Fungi | 361 | 3.3e-95 | NTclustered | gi|1758353532|ref|XM_031144458.1| | 1093900 | g12076 | i0 | 92.771 | 1 | 249 | 18 | 100 | 0 | 1 | 249 | 1530 | 1282 | Thyridium curvatum uncharacterized protein (E0L32_009487), partial mRNA | blastn | 249 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Thyridiales | Thyridiaceae | Thyridium | Thyridium curvatum | |
| 12388462 | 12388462 | PRJNA930380_P_NODE_11870_length_250_cov_0.870056_g11817_i0 | PRJNA930380 | 11870 | 250 | 0.870056 | 2.17514 | Thyridium curvatum | 1093900 | Fungi | Fungi | 446 | 8.89e-121 | NTclustered | gi|1758348818|ref|XM_031141840.1| | 1093900 | g11817 | i0 | 98.8 | 3.04 | 250 | 3 | 100 | 0 | 1 | 250 | 298 | 49 | Thyridium curvatum uncharacterized protein (E0L32_007130), partial mRNA | blastn | 760 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Thyridiales | Thyridiaceae | Thyridium | Thyridium curvatum | |
| 12388517 | 12388517 | PRJNA930380_P_NODE_13990_length_242_cov_0.911243_g13937_i0 | PRJNA930380 | 13990 | 242 | 0.911243 | 2.20520806 | Fusarium verticillioides | 117187 | Fungi | Fungi | 442 | 1.1099999999999995e-119 | NTclustered | gi|1092952487|ref|XM_018887963.1| | 334819 | g13937 | i0 | 99.587 | 13.004132231405 | 242 | 1 | 100 | 0 | 1 | 242 | 242 | 1 | Fusarium verticillioides 7600 thymidylate synthase (FVEG_01159), partial mRNA | blastn | 3147 | 442 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium verticillioides | |
| 17487650 | 17487650 | PRJNA930380_P_NODE_2454_length_401_cov_2.384146_g2401_i0 | PRJNA930380 | 2454 | 401 | 2.384146 | 9.56042546 | Dothideomycetes sp. NU200 | 2983309 | Fungi | Fungi | 405 | 2.56e-108 | NTclustered | gi|2328117298|dbj|LC739043.1| | 2983309 | g2401 | i0 | 86.885 | 89.3142144638404 | 366 | 43 | 91 | 5 | 1 | 364 | 2843 | 3205 | Dothideomycetes sp. NU200 gene for 28S ribosomal RNA, partial sequence | blastn | 35815 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideomycetes sp. NU200 | ||||
| 19106291 | 19106291 | PRJNA930380_P_NODE_11515_length_251_cov_0.865169_g11462_i0 | PRJNA930380 | 11515 | 251 | 0.865169 | 2.17157419 | Fusarium | 5506 | Fungi | Fungi | 453 | 5.34e-123 | NTclustered | gi|1092957201|ref|XM_018894462.1| | 334819 | g11462 | i0 | 99.203 | 8.93227091633466 | 251 | 2 | 100 | 0 | 1 | 251 | 663 | 913 | Fusarium verticillioides 7600 hypothetical protein (FVEG_06177), mRNA | blastn | 2242 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium verticillioides | |
| 23861608 | 23861608 | PRJNA930380_P_NODE_12059_length_249_cov_0.875000_g12006_i0 | PRJNA930380 | 12059 | 249 | 0.875 | 2.17875 | Fusarium verticillioides | 117187 | Fungi | Fungi | 455 | 1.47e-123 | NTclustered | gi|1092966203|ref|XM_018892471.1| | 334819 | g12006 | i0 | 99.598 | 73.6506024096386 | 249 | 1 | 100 | 0 | 1 | 249 | 566 | 318 | Fusarium verticillioides 7600 ADP,ATP carrier protein (FVEG_04651), mRNA | blastn | 18339 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium verticillioides |
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);;