contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1253303" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 359342 | 359342 | PRJNA1253303_P_NODE_4601_length_260_cov_1.518717_g4579_i0 | PRJNA1253303 | 4601 | 260 | 1.518717 | 3.9486642 | Periconia cynodontis | 2998216 | Fungi | Fungi | 167 | 8.109999999999999e-37 | NTclustered | gi|2459743111|gb|OP961434.1| | 2998216 | g4579 | i0 | 81.773 | 82.5346153846154 | 203 | 33 | 77 | 4 | 23 | 223 | 698 | 498 | Periconia cynodontis isolate Lu4 translation elongation factor 1-alpha (TEF1) gene, partial cds | blastn | 21459 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia cynodontis | |
| 1052600 | 1052600 | PRJNA1253303_P_NODE_4901_length_253_cov_0.950000_g4879_i0 | PRJNA1253303 | 4901 | 253 | 0.95 | 2.4035 | Pleosporales | 92860 | Fungi | Fungi | 462 | 8.95e-126 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g4879 | i0 | 99.605 | 120.786561264822 | 253 | 1 | 100 | 0 | 1 | 253 | 4376 | 4124 | 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 | 30559 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 2910104 | 2910104 | PRJNA1253303_P_NODE_2723_length_322_cov_1.566265_g2701_i0 | PRJNA1253303 | 2723 | 322 | 1.566265 | 5.0433733 | Alternaria alternata | 5599 | Fungi | Fungi | 592 | 1.44e-164 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g2701 | i0 | 100 | 111.562111801242 | 320 | 0 | 99 | 0 | 1 | 320 | 5296 | 5615 | 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 | 35923 | 592 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 2910176 | 2910176 | PRJNA1253303_P_NODE_5943_length_250_cov_0.881356_g5921_i0 | PRJNA1253303 | 5943 | 250 | 0.881356 | 2.20339 | Aspergillus versicolor | 46472 | Fungi | Fungi | 233 | 7.529999999999999e-57 | NTclustered | gi|2028128618|ref|XM_040805787.1| | 1036611 | g5921 | i0 | 98.485 | 3.532 | 132 | 2 | 53 | 0 | 1 | 132 | 132 | 1 | Aspergillus versicolor CBS 583.65 uncharacterized protein (ASPVEDRAFT_120326), partial mRNA | blastn | 883 | 233 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus versicolor | |
| 3603064 | 3603064 | PRJNA1253303_P_NODE_5143_length_253_cov_0.866667_g5121_i0 | PRJNA1253303 | 5143 | 253 | 0.866667 | 2.19266751 | Cladosporium | 5498 | Fungi | Fungi | 414 | 2.54e-111 | NTclustered | gi|1905450536|gb|MN657180.1| | 1707700 | g5121 | i0 | 96.774 | 92.6679841897233 | 248 | 8 | 98 | 0 | 6 | 253 | 5430 | 5183 | Cladosporium sp. strain YFCC8620 mitochondrion, complete genome | blastn | 23445 | 418 | 0.990430622009569 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium sp. | |
| 5462836 | 5462836 | PRJNA1253303_P_NODE_7345_length_246_cov_0.901734_g7323_i0 | PRJNA1253303 | 7345 | 246 | 0.901734 | 2.21826564 | Cryptococcus amylolentus | 104669 | Fungi | Fungi | 178 | 3.5099999999999993e-40 | NTclustered | gi|1101782768|ref|XM_019134367.1| | 1295533 | g7323 | i0 | 84.043 | 24.1585365853659 | 188 | 26 | 76 | 3 | 1 | 186 | 1518 | 1703 | Cryptococcus amylolentus CBS 6039 ATP-dependent RNA helicase ded1 (L202_01067), mRNA | blastn | 5943 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus amylolentus | |
| 10563575 | 10563575 | PRJNA1253303_P_NODE_6789_length_247_cov_0.896552_g6767_i0 | PRJNA1253303 | 6789 | 247 | 0.896552 | 2.21448344 | Calcarisporiella thermophila | 911321 | Fungi | Fungi | 102 | 2.19e-17 | NTclustered | gi|2837879392|ref|XM_069398379.1| | 911321 | g6767 | i0 | 79.72 | 0.578947368421053 | 143 | 28 | 58 | 1 | 9 | 151 | 1113 | 1254 | Calcarisporiella thermophila uncharacterized protein (VTP21DRAFT_7618), partial mRNA | blastn | 143 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila | ||
| 11255874 | 11255874 | PRJNA1253303_P_NODE_1749_length_386_cov_2.696486_g1727_i0 | PRJNA1253303 | 1749 | 386 | 2.696486 | 10.40843596 | Ascomycota | 4890 | Fungi | Fungi | 713 | 0 | NTclustered | gi|1840379205|gb|MT453271.1| | 5599 | g1727 | i0 | 100 | 100 | 386 | 0 | 100 | 0 | 1 | 386 | 951 | 566 | Alternaria alternata isolate DSM100286_DF09_RLCS10 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 | 38600 | 713 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 13806010 | 13806010 | PRJNA1253303_P_NODE_8591_length_233_cov_2.068750_g8569_i0 | PRJNA1253303 | 8591 | 233 | 2.06875 | 4.8201875 | root | 1 | Root_unresolved | Root_unresolved | 431 | 2.2899999999999996e-116 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g8569 | i0 | 100 | 37.7811158798283 | 233 | 0 | 100 | 0 | 1 | 233 | 7370209 | 7369977 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 8803 | 431 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 15080197 | 15080197 | PRJNA1253303_P_NODE_7052_length_246_cov_1.404624_g7030_i0 | PRJNA1253303 | 7052 | 246 | 1.404624 | 3.45537504 | Fungi | 4751 | Fungi | Fungi | 453 | 5.2100000000000006e-123 | NTclustered | gi|2582615798|ref|XR_009468002.1| | 5061 | g7030 | i0 | 100 | 105.573170731707 | 245 | 0 | 99 | 0 | 2 | 246 | 2639 | 2395 | Aspergillus niger 28S ribosomal RNA (28S rRNA), partial rRNA | blastn | 25971 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 15662324 | 15662324 | PRJNA1253303_P_NODE_4633_length_259_cov_1.612903_g4611_i0 | PRJNA1253303 | 4633 | 259 | 1.612903 | 4.17741877 | Scheffersomyces spartinae | 45513 | Fungi | Fungi | 145 | 3.78e-30 | NTclustered | gi|2083601550|ref|XM_043191991.1| | 45513 | g4611 | i0 | 78.261 | 20.0810810810811 | 230 | 46 | 88 | 4 | 9 | 236 | 1177 | 1404 | Scheffersomyces spartinae 70-kilodalton heat shock protein (HSP70_1), partial mRNA | blastn | 5201 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Scheffersomyces | Scheffersomyces spartinae | |
| 16936709 | 16936709 | PRJNA1253303_P_NODE_4754_length_256_cov_1.590164_g4732_i0 | PRJNA1253303 | 4754 | 256 | 1.590164 | 4.07081984 | Talaromyces stipitatus | 28564 | Fungi | Fungi | 222 | 1.68e-53 | NTclustered | gi|242768053|ref|XM_002341451.1| | 441959 | g4732 | i0 | 87.629 | 33.28515625 | 194 | 20 | 75 | 4 | 37 | 228 | 30 | 221 | Talaromyces stipitatus ATCC 10500 S-adenosylmethionine synthetase (TSTA_074840), partial mRNA | blastn | 8521 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces stipitatus | |
| 18904069 | 18904069 | PRJNA1253303_P_NODE_4255_length_269_cov_1.724490_g4233_i0 | PRJNA1253303 | 4255 | 269 | 1.72449 | 4.6388781 | Opisthokonta | 33154 | Fungi | Fungi | 497 | 2.63e-136 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g4233 | i0 | 100 | 113.970260223048 | 269 | 0 | 100 | 0 | 1 | 269 | 4941 | 4673 | 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 | 30658 | 497 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 19485523 | 19485523 | PRJNA1253303_P_NODE_7456_length_245_cov_0.906977_g7434_i0 | PRJNA1253303 | 7456 | 245 | 0.906977 | 2.22209365 | Purpureocillium takamizusanense | 2060973 | Fungi | Fungi | 143 | 1.28e-29 | NTclustered | gi|2234652211|ref|XM_047983266.1| | 2060973 | g7434 | i0 | 82.635 | 12.6408163265306 | 167 | 23 | 67 | 5 | 6 | 169 | 1154 | 1317 | Purpureocillium takamizusanense Glutamine synthetase (GLN1), mRNA | blastn | 3097 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium takamizusanense | |
| 23311730 | 23311730 | PRJNA1253303_P_NODE_7019_length_247_cov_0.885057_g6997_i0 | PRJNA1253303 | 7019 | 247 | 0.885057 | 2.18609079 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 180 | 9.82e-41 | NTclustered | gi|2324081559|ref|XM_051528697.1| | 90255 | g6997 | i0 | 81.092 | 85.1821862348178 | 238 | 33 | 94 | 12 | 1 | 232 | 1113 | 1344 | Cokeromyces recurvatus ATP synthase subunit beta (BX663DRAFT_517217), mRNA | blastn | 21040 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus |
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);;