contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA400171" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1081029 | 1081029 | PRJNA400171_S_NODE_5321_length_190_cov_16.341615_g5231_i0 | PRJNA400171 | 5321 | 190 | 16.341615 | 31.0490685 | Sarocladiaceae | 2502719 | Fungi | Fungi | 351 | 1.4399999999999997e-92 | NTclustered | gi|219960400|gb|FJ567940.1| | 175243 | g5231 | i0 | 100 | 100.015789473684 | 190 | 0 | 100 | 0 | 1 | 190 | 479 | 668 | Uncultured Ascomycota clone A8YN12RM1 large subunit ribosomal RNA gene, partial sequence | blastn | 19003 | 351 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | uncultured Ascomycota | |||||
| 3631795 | 3631795 | PRJNA400171_S_NODE_4183_length_208_cov_6.608939_g4093_i0 | PRJNA400171 | 4183 | 208 | 6.608939 | 13.74659312 | Sarocladiaceae | 2502719 | Fungi | Fungi | 385 | 1.58e-102 | NTclustered | gi|308219083|gb|GQ867783.1| | 885939 | g4093 | i0 | 100 | 103.725961538462 | 208 | 0 | 100 | 0 | 1 | 208 | 3563 | 3770 | Acremonium sp. 11665 DLW-2010 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 | 21575 | 385 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Acremonium | Acremonium sp. 11665 DLW-2010 | ||
| 5517387 | 5517387 | PRJNA400171_S_NODE_1745_length_283_cov_18.846457_g1655_i0 | PRJNA400171 | 1745 | 283 | 18.846457 | 53.33547331 | uncultured Trichocomaceae | 209467 | Fungi | Fungi | 477 | 3.639999999999999e-130 | NTclustered | gi|70002617|gb|DQ069873.1| | 209467 | g1655 | i0 | 97.183 | 99.9151943462898 | 284 | 5 | 100 | 3 | 1 | 283 | 298 | 17 | Uncultured Trichocomaceae clone RFLP13 18S ribosomal RNA gene, partial sequence | blastn | 28276 | 477 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | uncultured Trichocomaceae | ||
| 5517616 | 5517616 | PRJNA400171_S_NODE_7225_length_168_cov_8.064748_g7135_i0 | PRJNA400171 | 7225 | 168 | 8.064748 | 13.54877664 | Acremonium sp. 11665 DLW-2010 | 885939 | Fungi | Fungi | 305 | 9.81e-79 | NTclustered | gi|308219083|gb|GQ867783.1| | 885939 | g7135 | i0 | 99.405 | 90.4940476190476 | 168 | 1 | 100 | 0 | 1 | 168 | 4277 | 4110 | Acremonium sp. 11665 DLW-2010 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 | 15203 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Acremonium | Acremonium sp. 11665 DLW-2010 | ||
| 5517659 | 5517659 | PRJNA400171_S_NODE_8185_length_159_cov_11.615385_g8095_i0 | PRJNA400171 | 8185 | 159 | 11.615385 | 18.46846215 | Scedosporium apiospermum | 563466 | Fungi | Fungi | 283 | 4.29e-72 | NTclustered | gi|225134686|gb|FJ345358.1| | 563466 | g8095 | i0 | 98.742 | 104.465408805031 | 159 | 2 | 100 | 0 | 1 | 159 | 4537 | 4695 | Scedosporium apiospermum strain ATCC 28206 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 | 16610 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Microascaceae | Scedosporium | Scedosporium apiospermum | |
| 6791446 | 6791446 | PRJNA400171_S_NODE_3286_length_227_cov_11.646465_g3196_i0 | PRJNA400171 | 3286 | 227 | 11.646465 | 26.43747555 | Fusarium phaseoli | 120645 | Fungi | Fungi | 411 | 2.8999999999999996e-110 | NTclustered | gi|90436895|gb|DQ452435.1| | 120645 | g3196 | i0 | 100 | 97.7577092511013 | 222 | 0 | 98 | 0 | 6 | 227 | 1 | 222 | Fusarium phaseoli strain MAFF 305607 28S ribosomal RNA gene and 28S-18S ribosomal RNA intergenic spacer, partial sequence | blastn | 22191 | 411 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium phaseoli | |
| 8067069 | 8067069 | PRJNA400171_S_NODE_4187_length_208_cov_4.273743_g4097_i0 | PRJNA400171 | 4187 | 208 | 4.273743 | 8.88938544 | Alternaria alternata | 5599 | Fungi | Fungi | 385 | 1.58e-102 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g4097 | i0 | 100 | 107.634615384615 | 208 | 0 | 100 | 0 | 1 | 208 | 3936 | 3729 | Alternaria alternata isolate Karbala-1 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and external transcribed spacer, partial sequence | blastn | 22388 | 385 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 8733794 | 8733794 | PRJNA400171_S_NODE_1687_length_287_cov_3.507752_g1597_i0 | PRJNA400171 | 1687 | 287 | 3.507752 | 10.06724824 | Scopulariopsis | 40374 | Fungi | Fungi | 508 | 1.31e-139 | NTclustered | gi|670734118|gb|KJ443118.1| | 186361 | g1597 | i0 | 98.944 | 115.693379790941 | 284 | 3 | 99 | 0 | 1 | 284 | 1757 | 1474 | Scopulariopsis fusca strain G414 28S large subunit ribosomal RNA gene, partial sequence | blastn | 33204 | 510 | 0.996078431372549 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Microascaceae | Scopulariopsis | Scopulariopsis fusca | |
| 13834479 | 13834479 | PRJNA400171_S_NODE_2511_length_250_cov_6.339367_g2421_i0 | PRJNA400171 | 2511 | 250 | 6.339367 | 15.8484175 | Ascomycota | 4890 | Fungi | Fungi | 449 | 6.87e-122 | NTclustered | gi|2119889156|gb|OK577963.1| | 1715220 | g2421 | i0 | 99.197 | 99.992 | 249 | 2 | 99 | 0 | 2 | 250 | 959 | 711 | Alternaria sp. isolate LC2 small subunit ribosomal RNA gene, partial sequence | blastn | 24998 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria sp. | |
| 13834480 | 13834480 | PRJNA400171_S_NODE_271_length_537_cov_17.570866_g192_i0 | PRJNA400171 | 271 | 537 | 17.570866 | 94.35555042 | Ascomycota | 4890 | Fungi | Fungi | 915 | 0 | NTclustered | gi|1020738212|emb|LT549088.1| | 45277 | g192 | i0 | 97.398 | 100.048417132216 | 538 | 13 | 100 | 1 | 1 | 537 | 29 | 566 | Sarocladium kiliense genomic DNA sequence contains 18S rRNA gene, ITS1 and 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate G2-16 | blastn | 53726 | 915 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium kiliense | |
| 14442671 | 14442671 | PRJNA400171_S_NODE_4292_length_206_cov_20.129944_g4202_i0 | PRJNA400171 | 4292 | 206 | 20.129944 | 41.46768464 | Acremonium sp. 11665 DLW-2010 | 885939 | Fungi | Fungi | 364 | 2.0399999999999993e-96 | NTclustered | gi|308219083|gb|GQ867783.1| | 885939 | g4202 | i0 | 98.544 | 104.004854368932 | 206 | 3 | 100 | 0 | 1 | 206 | 4489 | 4694 | Acremonium sp. 11665 DLW-2010 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 | 21425 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Acremonium | Acremonium sp. 11665 DLW-2010 | ||
| 15108750 | 15108750 | PRJNA400171_S_NODE_6652_length_174_cov_10.627586_g6562_i0 | PRJNA400171 | 6652 | 174 | 10.627586 | 18.49199964 | Sarocladium | 284134 | Fungi | Fungi | 322 | 1.01e-83 | NTclustered | gi|157366947|gb|EU119045.1| | 175243 | g6562 | i0 | 100 | 100 | 174 | 0 | 100 | 0 | 1 | 174 | 37 | 210 | Uncultured ascomycete clone Biofilm3-16 small subunit ribosomal RNA gene, partial sequence | blastn | 17400 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | uncultured Ascomycota | |||||
| 16991227 | 16991227 | PRJNA400171_S_NODE_2114_length_265_cov_21.576271_g2024_i0 | PRJNA400171 | 2114 | 265 | 21.576271 | 57.17711815 | Corollospora maritima | 45810 | Fungi | Fungi | 472 | 1.5699999999999998e-128 | NTclustered | gi|363544765|gb|JN941653.1| | 45810 | g2024 | i0 | 98.864 | 99.622641509434 | 264 | 3 | 99 | 0 | 1 | 264 | 709 | 972 | Corollospora maritima strain NBRC 32118 18S ribosomal RNA (SSU) gene, partial sequence | blastn | 26400 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Halosphaeriaceae | Corollospora | Corollospora maritima | |
| 21482682 | 21482682 | PRJNA400171_S_NODE_4657_length_200_cov_11.964912_g4567_i0 | PRJNA400171 | 4657 | 200 | 11.964912 | 23.929824 | Microascaceae | 5593 | Fungi | Fungi | 364 | 1.96e-96 | NTclustered | gi|1829519787|gb|MT312850.1| | 129317 | g4567 | i0 | 99.5 | 100 | 200 | 1 | 100 | 0 | 1 | 200 | 763 | 564 | Enterocarpus grenotii strain DTO 401-A9 large subunit ribosomal RNA gene, partial sequence | blastn | 20000 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Microascaceae | Enterocarpus | Enterocarpus grenotii | |
| 22757931 | 22757931 | PRJNA400171_S_NODE_4978_length_195_cov_10.686747_g4888_i0 | PRJNA400171 | 4978 | 195 | 10.686747 | 20.83915665 | Sarocladiaceae | 2502719 | Fungi | Fungi | 361 | 2.46e-95 | NTclustered | gi|308219083|gb|GQ867783.1| | 885939 | g4888 | i0 | 100 | 100.005128205128 | 195 | 0 | 100 | 0 | 1 | 195 | 3752 | 3946 | Acremonium sp. 11665 DLW-2010 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 | 19501 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Acremonium | Acremonium sp. 11665 DLW-2010 | ||
| 22757932 | 22757932 | PRJNA400171_S_NODE_6378_length_177_cov_9.601351_g6288_i0 | PRJNA400171 | 6378 | 177 | 9.601351 | 16.99439127 | Ascomycota | 4890 | Fungi | Fungi | 327 | 2.2199999999999996e-85 | NTclustered | gi|12697549|dbj|AB024046.1| | 89487 | g6288 | i0 | 100 | 100 | 177 | 0 | 100 | 0 | 1 | 177 | 560 | 736 | Basipetospora chlamydospora gene for 18S ribosomal RNA | blastn | 17700 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Basipetospora | Basipetospora chlamydospora | ||
| 23365888 | 23365888 | PRJNA400171_S_NODE_5459_length_188_cov_9.018868_g5369_i0 | PRJNA400171 | 5459 | 188 | 9.018868 | 16.95547184 | Scedosporium apiospermum | 563466 | Fungi | Fungi | 263 | 6.839999999999999e-66 | NTclustered | gi|225134686|gb|FJ345358.1| | 563466 | g5369 | i0 | 92.021 | 98.7606382978723 | 188 | 14 | 100 | 1 | 1 | 188 | 4856 | 4670 | Scedosporium apiospermum strain ATCC 28206 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 | 18567 | 263 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Microascaceae | Scedosporium | Scedosporium apiospermum | |
| 23365899 | 23365899 | PRJNA400171_S_NODE_5799_length_184_cov_18.045161_g5709_i0 | PRJNA400171 | 5799 | 184 | 18.045161 | 33.20309624 | Geopyxis carbonaria | 49969 | Fungi | Fungi | 324 | 3.01e-84 | NTclustered | gi|6017885|gb|AF104665.1|AF104665 | 49969 | g5709 | i0 | 98.37 | 100.005434782609 | 184 | 3 | 100 | 0 | 1 | 184 | 1578 | 1395 | Geopyxis carbonaria 18S ribosomal RNA gene, complete sequence | blastn | 18401 | 324 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Tarzettaceae | Geopyxis | Geopyxis carbonaria | |
| 24032738 | 24032738 | PRJNA400171_S_NODE_8079_length_160_cov_19.175573_g7989_i0 | PRJNA400171 | 8079 | 160 | 19.175573 | 30.6809168 | Ascomycota | 4890 | Fungi | Fungi | 285 | 1.2e-72 | NTclustered | gi|175749|gb|M89782.1|PUCRRNA | 5597 | g7989 | i0 | 98.75 | 100 | 160 | 2 | 100 | 0 | 1 | 160 | 1232 | 1391 | Pseudalllescheria boydii partial 18S ribosomal RNA sequence | blastn | 16000 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Microascaceae | Scedosporium | Scedosporium boydii |
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);;