contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1022587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1004142 | 1004142 | PRJNA1022587_S_NODE_721_length_304_cov_6.225108_g719_i0 | PRJNA1022587 | 721 | 304 | 6.225108 | 18.92432832 | Ascomycota | 4890 | Fungi | Fungi | 560 | 3.81e-155 | NTclustered | gi|1134949146|gb|KX237674.1| | 4909 | g719 | i0 | 100 | 99.6710526315789 | 303 | 0 | 99 | 0 | 2 | 304 | 581 | 279 | Pichia kudriavzevii isolate YNCA9005 large subunit ribosomal RNA gene, partial sequence | blastn | 30300 | 560 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia kudriavzevii | |
| 2279320 | 2279320 | PRJNA1022587_S_NODE_1182_length_257_cov_7.054348_g1180_i0 | PRJNA1022587 | 1182 | 257 | 7.054348 | 18.12967436 | root | 1 | Root_unresolved | Root_unresolved | 475 | 1.1699999999999999e-129 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g1180 | i0 | 100 | 113.700389105058 | 257 | 0 | 100 | 0 | 1 | 257 | 3881781 | 3881525 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 29221 | 475 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 2713113 | 2713113 | PRJNA1022587_S_NODE_723_length_304_cov_1.969697_g721_i0 | PRJNA1022587 | 723 | 304 | 1.969697 | 5.98787888 | Botrytis cinerea | 40559 | Fungi | Fungi | 562 | 1.06e-155 | NTclustered | gi|1377701976|ref|XM_001553552.2| | 332648 | g721 | i0 | 100 | 33.7565789473684 | 304 | 0 | 100 | 0 | 1 | 304 | 695 | 392 | Botrytis cinerea B05.10 hypothetical protein (BCIN_01g09530), mRNA | blastn | 10262 | 562 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 4832145 | 4832145 | PRJNA1022587_S_NODE_1064_length_267_cov_6.721649_g1062_i0 | PRJNA1022587 | 1064 | 267 | 6.721649 | 17.94680283 | Opisthokonta | 33154 | Fungi | Fungi | 494 | 3.38e-135 | NTclustered | gi|1134949146|gb|KX237674.1| | 4909 | g1062 | i0 | 100 | 105 | 267 | 0 | 100 | 0 | 1 | 267 | 287 | 21 | Pichia kudriavzevii isolate YNCA9005 large subunit ribosomal RNA gene, partial sequence | blastn | 28035 | 494 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia kudriavzevii | |
| 4832150 | 4832150 | PRJNA1022587_S_NODE_1624_length_212_cov_6.266187_g1622_i0 | PRJNA1022587 | 1624 | 212 | 6.266187 | 13.28431644 | root | 1 | Root_unresolved | Root_unresolved | 392 | 9.67e-105 | NTclustered | gi|1354561844|gb|MH023283.1| | 4932 | g1622 | i0 | 100 | 108 | 212 | 0 | 100 | 0 | 1 | 212 | 82 | 293 | Saccharomyces cerevisiae strain GITA551 small subunit ribosomal RNA gene, partial sequence | blastn | 22896 | 392 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 6540857 | 6540857 | PRJNA1022587_S_NODE_1446_length_245_cov_0.895349_g1444_i0 | PRJNA1022587 | 1446 | 245 | 0.895349 | 2.19360505 | Botrytis cinerea | 40559 | Fungi | Fungi | 442 | 1.1199999999999994e-119 | NTclustered | gi|1377721223|ref|XM_001547393.2| | 332648 | g1444 | i0 | 99.184 | 6.51020408163265 | 245 | 2 | 100 | 0 | 1 | 245 | 783 | 1027 | Botrytis cinerea B05.10 hypothetical protein (BCIN_15g02550), mRNA | blastn | 1595 | 442 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 6540861 | 6540861 | PRJNA1022587_S_NODE_86_length_634_cov_1.495544_g84_i0 | PRJNA1022587 | 86 | 634 | 1.495544 | 9.48174896 | Botrytis cinerea | 40559 | Fungi | Fungi | 1166 | 0 | NTclustered | gi|1377721223|ref|XM_001547393.2| | 332648 | g84 | i0 | 99.842 | 7.57570977917981 | 634 | 1 | 100 | 0 | 1 | 634 | 1023 | 1656 | Botrytis cinerea B05.10 hypothetical protein (BCIN_15g02550), mRNA | blastn | 4803 | 1166 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 9932183 | 9932183 | PRJNA1022587_S_NODE_268_length_419_cov_7.378613_g266_i0 | PRJNA1022587 | 268 | 419 | 7.378613 | 30.91638847 | root | 1 | Root_unresolved | Root_unresolved | 774 | 0 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g266 | i0 | 100 | 113.026252983294 | 419 | 0 | 100 | 0 | 1 | 419 | 3882252 | 3881834 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 47358 | 774 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 11641283 | 11641283 | PRJNA1022587_S_NODE_1310_length_250_cov_0.870056_g1308_i0 | PRJNA1022587 | 1310 | 250 | 0.870056 | 2.17514 | Botrytis cinerea | 40559 | Fungi | Fungi | 462 | 8.83e-126 | NTclustered | gi|1377713460|ref|XM_001552547.2| | 332648 | g1308 | i0 | 100 | 7.4 | 250 | 0 | 100 | 0 | 1 | 250 | 2133 | 2382 | Botrytis cinerea B05.10 Bchex1 (Bchex1), mRNA | blastn | 1850 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 17581921 | 17581921 | PRJNA1022587_S_NODE_274_length_416_cov_2.040816_g272_i0 | PRJNA1022587 | 274 | 416 | 2.040816 | 8.48979456 | Botrytis | 33196 | Fungi | Fungi | 758 | 0 | NTclustered | gi|5830800|emb|AL115584.1| | 40559 | g272 | i0 | 99.758 | 23.3509615384615 | 413 | 1 | 99 | 0 | 4 | 416 | 413 | 1 | Botrytis cinerea strain T4 cDNA library | blastn | 9714 | 758 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 17581923 | 17581923 | PRJNA1022587_S_NODE_654_length_314_cov_1.091286_g652_i0 | PRJNA1022587 | 654 | 314 | 1.091286 | 3.42663804 | Botrytis | 33196 | Fungi | Fungi | 580 | 3.0299999999999992e-161 | NTclustered | gi|5825702|emb|AL111082.1| | 40559 | g652 | i0 | 100 | 7.46496815286624 | 314 | 0 | 100 | 0 | 1 | 314 | 181 | 494 | Botrytis cinerea strain T4 cDNA library | blastn | 2344 | 580 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 18014546 | 18014546 | PRJNA1022587_S_NODE_1315_length_249_cov_1.732955_g1313_i0 | PRJNA1022587 | 1315 | 249 | 1.732955 | 4.31505795 | Botrytis cinerea | 40559 | Fungi | Fungi | 455 | 1.47e-123 | NTclustered | gi|5825825|emb|AL111206.1| | 40559 | g1313 | i0 | 99.6 | 26.8674698795181 | 250 | 0 | 100 | 1 | 1 | 249 | 318 | 69 | Botrytis cinerea strain T4 cDNA library | blastn | 6690 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 18014549 | 18014549 | PRJNA1022587_S_NODE_435_length_360_cov_1.163763_g433_i0 | PRJNA1022587 | 435 | 360 | 1.163763 | 4.1895468 | Botrytis cinerea | 40559 | Fungi | Fungi | 660 | 0 | NTclustered | gi|1377701976|ref|XM_001553552.2| | 332648 | g433 | i0 | 99.722 | 13.3388888888889 | 360 | 1 | 100 | 0 | 1 | 360 | 872 | 1231 | Botrytis cinerea B05.10 hypothetical protein (BCIN_01g09530), mRNA | blastn | 4802 | 660 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 18014552 | 18014552 | PRJNA1022587_S_NODE_735_length_303_cov_1.339130_g733_i0 | PRJNA1022587 | 735 | 303 | 1.33913 | 4.0575639 | Botrytis cinerea | 40559 | Fungi | Fungi | 560 | 3.79e-155 | NTclustered | gi|1377716111|ref|XM_001552365.2| | 332648 | g733 | i0 | 100 | 9 | 303 | 0 | 100 | 0 | 1 | 303 | 960 | 658 | Botrytis cinerea B05.10 Bcgst3 (Bcgst3), mRNA | blastn | 2727 | 560 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 19288412 | 19288412 | PRJNA1022587_S_NODE_1176_length_258_cov_1.248649_g1174_i0 | PRJNA1022587 | 1176 | 258 | 1.248649 | 3.22151442 | Botrytis cinerea | 40559 | Fungi | Fungi | 477 | 3.2699999999999985e-130 | NTclustered | gi|5829118|emb|AL114499.1| | 40559 | g1174 | i0 | 100 | 14.2325581395349 | 258 | 0 | 100 | 0 | 1 | 258 | 76 | 333 | Botrytis cinerea strain T4 cDNA library | blastn | 3672 | 477 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 20563862 | 20563862 | PRJNA1022587_S_NODE_157_length_508_cov_1.742529_g155_i0 | PRJNA1022587 | 157 | 508 | 1.742529 | 8.85204732 | Botrytis cinerea | 40559 | Fungi | Fungi | 933 | 0 | NTclustered | gi|5825968|emb|AL111349.1| | 40559 | g155 | i0 | 99.803 | 19.9055118110236 | 508 | 1 | 100 | 0 | 1 | 508 | 516 | 9 | Botrytis cinerea strain T4 cDNA library | blastn | 10112 | 933 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 23956420 | 23956420 | PRJNA1022587_S_NODE_1059_length_268_cov_1.184615_g1057_i0 | PRJNA1022587 | 1059 | 268 | 1.184615 | 3.1747682 | Botrytis | 33196 | Fungi | Fungi | 490 | 4.39e-134 | NTclustered | gi|5826391|emb|AL111772.1| | 40559 | g1057 | i0 | 99.627 | 79.4216417910448 | 268 | 1 | 100 | 0 | 1 | 268 | 391 | 124 | Botrytis cinerea strain T4 cDNA library | blastn | 21285 | 490 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 23956424 | 23956424 | PRJNA1022587_S_NODE_599_length_321_cov_1.528226_g597_i0 | PRJNA1022587 | 599 | 321 | 1.528226 | 4.90560546 | Botrytis | 33196 | Fungi | Fungi | 582 | 8.639999999999997e-162 | NTclustered | gi|5829227|emb|AL114608.1| | 40559 | g597 | i0 | 99.377 | 28.0467289719626 | 321 | 2 | 100 | 0 | 1 | 321 | 352 | 32 | Botrytis cinerea strain T4 cDNA library | blastn | 9003 | 582 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 24388775 | 24388775 | PRJNA1022587_S_NODE_300_length_409_cov_1.586310_g298_i0 | PRJNA1022587 | 300 | 409 | 1.58631 | 6.4880079 | Botrytis cinerea | 40559 | Fungi | Fungi | 756 | 0 | NTclustered | gi|1377713997|ref|XM_024695026.1| | 332648 | g298 | i0 | 100 | 8.37163814180929 | 409 | 0 | 100 | 0 | 1 | 409 | 1750 | 1342 | Botrytis cinerea B05.10 Bcap1 (Bcap1), mRNA | blastn | 3424 | 756 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 25230354 | 25230354 | PRJNA1022587_S_NODE_360_length_382_cov_4.061489_g358_i0 | PRJNA1022587 | 360 | 382 | 4.061489 | 15.51488798 | root | 1 | Root_unresolved | Root_unresolved | 701 | 0 | NTclustered | gi|1275558205|ref|NG_055690.1| | 4931 | g358 | i0 | 99.738 | 116.581151832461 | 382 | 1 | 100 | 0 | 1 | 382 | 2907 | 3288 | Saccharomyces bayanus NRRL Y-12624 28S rRNA gene, partial sequence; from TYPE material | blastn | 44534 | 706 | 0.992917847025496 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces bayanus |
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);;