contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1241156" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 349976 | 349976 | PRJNA1241156_S_NODE_51101_length_273_cov_4.091304_g50641_i0 | PRJNA1241156 | 51101 | 273 | 4.091304 | 11.16925992 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 196 | 1.09e-45 | NTclustered | gi|2837739191|ref|XM_069371929.1| | 1052096 | g50641 | i0 | 84.694 | 1.38461538461538 | 196 | 30 | 72 | 0 | 1 | 196 | 1221 | 1416 | Cladosporium halotolerans Alcohol dehydrogenase 1 (adh-1_0), mRNA | blastn | 378 | 196 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 1050577 | 1050577 | PRJNA1241156_S_NODE_24061_length_350_cov_4.182410_g23601_i0 | PRJNA1241156 | 24061 | 350 | 4.18241 | 14.638435 | Erysiphe | 5121 | Fungi | Fungi | 54.7 | 0.009 | NTclustered | gi|2055404097|ref|NC_056147.1| | 36044 | g23601 | i0 | 87.5 | 0.274285714285714 | 48 | 4 | 13 | 2 | 4 | 50 | 147609 | 147563 | Erysiphe pisi strain Palampur-1 mitochondrion, complete genome | blastn | 96 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Erysiphe | Erysiphe pisi | |
| 1050643 | 1050643 | PRJNA1241156_S_NODE_39841_length_302_cov_2762.494208_g39381_i0 | PRJNA1241156 | 39841 | 302 | 2762.494208 | 8342.73250816 | Ascomycota | 4890 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2259471779|emb|OX032411.1| | 292464 | g39381 | i0 | 100 | 3.94039735099338 | 30 | 0 | 10 | 0 | 204 | 233 | 32 | 3 | uncultured Helotiales genomic DNA sequence contains 5.8S rRNA gene, ITS2, clone OTU_226 | blastn | 1190 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | uncultured Helotiales | |||
| 1050792 | 1050792 | PRJNA1241156_S_NODE_8501_length_439_cov_3.459596_g8045_i0 | PRJNA1241156 | 8501 | 439 | 3.459596 | 15.18762644 | Dothideomycetes | 147541 | Fungi | Fungi | 689 | 0 | NTclustered | gi|1393629737|ref|NG_059076.1| | 112489 | g8045 | i0 | 94.989 | 100.063781321185 | 439 | 22 | 100 | 0 | 1 | 439 | 2012 | 1574 | Dissoconium aciculare 28S rRNA gene, partial sequence; from TYPE material | blastn | 43928 | 691 | 0.997105643994211 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Dissoconiaceae | Dissoconium | Dissoconium aciculare | |
| 1625105 | 1625105 | PRJNA1241156_S_NODE_77642_length_197_cov_7.337662_g77182_i0 | PRJNA1241156 | 77642 | 197 | 7.337662 | 14.45519414 | Penicillium digitatum | 36651 | Fungi | Fungi | 357 | 3.23e-94 | NTclustered | gi|322422434|ref|NC_015080.1| | 36651 | g77182 | i0 | 99.492 | 60.4771573604061 | 197 | 0 | 100 | 1 | 1 | 197 | 23670 | 23865 | Penicillium digitatum mitochondrion, complete genome | blastn | 11914 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium digitatum | |
| 6727859 | 6727859 | PRJNA1241156_S_NODE_44906_length_289_cov_3.260163_g44446_i0 | PRJNA1241156 | 44906 | 289 | 3.260163 | 9.42187107 | Fusarium coffeatum | 231269 | Fungi | Fungi | 202 | 2.51e-47 | NTclustered | gi|1759085411|ref|XM_031155980.1| | 231269 | g44446 | i0 | 84.466 | 9.2318339100346 | 206 | 31 | 71 | 1 | 33 | 237 | 226 | 21 | Fusarium coffeatum uncharacterized protein (FIESC28_01830), partial mRNA | blastn | 2668 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium coffeatum | |
| 6728109 | 6728109 | PRJNA1241156_S_NODE_62546_length_248_cov_3.502439_g62086_i0 | PRJNA1241156 | 62546 | 248 | 3.502439 | 8.68604872 | Kluyveromyces lactis | 28985 | Fungi | Fungi | 196 | 9.79e-46 | NTclustered | gi|431861|emb|X76224.1| | 28985 | g62086 | i0 | 93.284 | 2.09274193548387 | 134 | 7 | 54 | 2 | 109 | 242 | 744 | 613 | Kluyveromyces lactis kanamycin resistance gene | blastn | 519 | 196 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Kluyveromyces | Kluyveromyces lactis | |
| 9277983 | 9277983 | PRJNA1241156_S_NODE_25448_length_345_cov_4.943709_g24988_i0 | PRJNA1241156 | 25448 | 345 | 4.943709 | 17.05579605 | Aspergillus glaucus | 41413 | Fungi | Fungi | 536 | 7.39e-148 | NTclustered | gi|1245857535|ref|XM_022550022.1| | 1160497 | g24988 | i0 | 96.319 | 3.45797101449275 | 326 | 12 | 94 | 0 | 1 | 326 | 1041 | 1366 | Aspergillus glaucus CBS 516.65 uncharacterized protein (ASPGLDRAFT_79504), mRNA | blastn | 1193 | 536 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 11253925 | 11253925 | PRJNA1241156_S_NODE_32169_length_324_cov_2.619217_g31709_i0 | PRJNA1241156 | 32169 | 324 | 2.619217 | 8.48626308 | Alternaria | 5598 | Fungi | Fungi | 327 | 4.52e-85 | NTclustered | gi|2272320249|ref|XM_049381951.1| | 181014 | g31709 | i0 | 98.907 | 4.51851851851852 | 183 | 2 | 56 | 0 | 1 | 183 | 91 | 273 | Alternaria ethzedia uncharacterized protein (J4E87_010377), partial mRNA | blastn | 1464 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria ethzedia | |
| 11828231 | 11828231 | PRJNA1241156_S_NODE_15170_length_388_cov_3.455072_g14710_i0 | PRJNA1241156 | 15170 | 388 | 3.455072 | 13.40567936 | Penicillium digitatum | 36651 | Fungi | Fungi | 717 | 0 | NTclustered | gi|953378614|ref|XM_014678090.1| | 36651 | g14710 | i0 | 100 | 17.9432989690722 | 388 | 0 | 100 | 0 | 1 | 388 | 834 | 447 | Penicillium digitatum Aspartyl-tRNA synthetase, cytoplasmic (Pdw03_8438), partial mRNA | blastn | 6962 | 717 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium digitatum | |
| 13103784 | 13103784 | PRJNA1241156_S_NODE_36051_length_313_cov_3.562963_g35591_i0 | PRJNA1241156 | 36051 | 313 | 3.562963 | 11.15207419 | Aspergillus glaucus | 41413 | Fungi | Fungi | 137 | 7.86e-28 | NTclustered | gi|1245863515|ref|XM_022540174.1| | 1160497 | g35591 | i0 | 80.899 | 0.568690095846645 | 178 | 30 | 56 | 3 | 31 | 206 | 5825 | 6000 | Aspergillus glaucus CBS 516.65 uncharacterized protein (ASPGLDRAFT_120785), partial mRNA | blastn | 178 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 15652658 | 15652658 | PRJNA1241156_S_NODE_22093_length_357_cov_5.108280_g21633_i0 | PRJNA1241156 | 22093 | 357 | 5.10828 | 18.2365596 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 344 | 4.98e-90 | NTclustered | gi|2837748458|ref|XM_069373868.1| | 1052096 | g21633 | i0 | 90.152 | 16.6190476190476 | 264 | 26 | 74 | 0 | 2 | 265 | 850 | 1113 | Cladosporium halotolerans 60S ribosomal protein uL4 (WHR41_05263), partial mRNA | blastn | 5933 | 344 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 18201704 | 18201704 | PRJNA1241156_S_NODE_41595_length_298_cov_2.937255_g41135_i0 | PRJNA1241156 | 41595 | 298 | 2.937255 | 8.7530199 | Histoplasma capsulatum | 5037 | Fungi | Fungi | 58.4 | 5.95e-4 | NTclustered | gi|2163533471|ref|XM_045432860.1| | 447093 | g41135 | i0 | 94.595 | 0.835570469798658 | 37 | 2 | 12 | 0 | 223 | 259 | 71 | 35 | Histoplasma capsulatum G186AR glyceraldehyde-3-phosphate dehydrogenase (HCBG_05811), mRNA | blastn | 249 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ajellomycetaceae | Histoplasma | Histoplasma capsulatum | |
| 21452429 | 21452429 | PRJNA1241156_S_NODE_26037_length_343_cov_4.343333_g25577_i0 | PRJNA1241156 | 26037 | 343 | 4.343333 | 14.89763219 | Kabatiella | 5422 | Fungi | Fungi | 499 | 9.64e-137 | NTclustered | gi|726973813|gb|KM519280.1| | 1576943 | g25577 | i0 | 93.994 | 97.1049562682216 | 333 | 15 | 96 | 5 | 15 | 343 | 834 | 503 | Dothideomycetes sp. genotype css041 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 33307 | 499 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideomycetes sp. genotype css041 | ||||
| 24576362 | 24576362 | PRJNA1241156_S_NODE_46400_length_285_cov_3.578512_g45940_i0 | PRJNA1241156 | 46400 | 285 | 3.578512 | 10.1987592 | Alternaria alternata | 5599 | Fungi | Fungi | 364 | 2.9799999999999998e-96 | NTclustered | gi|1070557281|ref|XM_018525569.1| | 5599 | g45940 | i0 | 99.5 | 3.32280701754386 | 200 | 1 | 70 | 0 | 1 | 200 | 1757 | 1956 | Alternaria alternata acid protease mRNA | blastn | 947 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata |
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);;