RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1002570" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1002570 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
3978620 3978620 PRJNA1002570_P_NODE_20944_length_288_cov_2.009302_g20749_i0 PRJNA1002570 20944 288 2.009302 5.78678976 Penicillium hispanicum 1080232 Fungi Fungi 294 4.01e-75   NTclustered gi|2514856005|ref|XM_056948190.1| 1080232 g20749 i0 86.397 5.73611111111111 272 34 94 2 2 273 826 1094 Penicillium hispanicum uncharacterized protein (N7459_009022), partial mRNA blastn 1652 294 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Penicillium Penicillium hispanicum
8653812 8653812 PRJNA1002570_P_NODE_28547_length_271_cov_1.555556_g28352_i0 PRJNA1002570 28547 271 1.555556 4.21555676 Aspergillus 5052 Fungi Fungi 174 5.08e-39   NTclustered gi|1245885905|ref|XM_022549341.1| 1160497 g28352 i0 84.659 16.409594095941 176 25 65 2 70 244 1 175 Aspergillus glaucus CBS 516.65 uncharacterized protein (ASPGLDRAFT_69231), partial mRNA blastn 4447 174 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Aspergillus Aspergillus glaucus
11203985 11203985 PRJNA1002570_P_NODE_25629_length_278_cov_1.502439_g25434_i0 PRJNA1002570 25629 278 1.502439 4.17678042 Ascomycota 4890 Fungi Fungi 514 2.7199999999999996e-141   NTclustered gi|538260854|gb|KF181220.1| 107450 g25434 i0 100 100 278 0 100 0 1 278 579 302 Phoma medicaginis strain MP38 28S ribosomal RNA gene, partial sequence blastn 27800 514 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales Didymellaceae Ascochyta Ascochyta medicaginicola
12906303 12906303 PRJNA1002570_P_NODE_43411_length_242_cov_0.911243_g43216_i0 PRJNA1002570 43411 242 0.911243 2.20520806 Talaromyces rugulosus 121627 Fungi Fungi 54.7 0.006   NTclustered gi|1868456418|ref|XM_035485126.1| 121627 g43216 i0 100 0.119834710743802 29 0 12 0 214 242 1060 1088 Talaromyces rugulosus uncharacterized protein (TRUGW13939_01929), partial mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Trichocomaceae Talaromyces Talaromyces rugulosus
14180770 14180770 PRJNA1002570_P_NODE_16952_length_304_cov_2.601732_g16757_i0 PRJNA1002570 16952 304 2.601732 7.90926528 Aspergillus candidus 41067 Fungi Fungi 56.5 0.002   NTclustered gi|1383789109|ref|XM_024811818.1| 41067 g16757 i0 100 0.0986842105263158 30 0 10 0 115 144 2025 2054 Aspergillus candidus uncharacterized protein (BDW47DRAFT_102225), mRNA blastn 30 56.5 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Aspergillus Aspergillus candidus
16303238 16303238 PRJNA1002570_P_NODE_37033_length_250_cov_0.870056_g36838_i0 PRJNA1002570 37033 250 0.870056 2.17514 root 1 Root_unresolved Root_unresolved 459 1.1399999999999998e-124   NTclustered gi|741042521|gb|CP009960.1| 4932 g36838 i0 99.6 10.016 250 1 100 0 1 250 62821 62572 Saccharomyces cerevisiae strain NCIM3107 chromosome 2 sequence blastn 2504 459 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycetales Saccharomycetaceae Saccharomyces Saccharomyces cerevisiae
17578587 17578587 PRJNA1002570_P_NODE_38174_length_248_cov_1.760000_g37979_i0 PRJNA1002570 38174 248 1.76 4.3648 root 1 Root_unresolved Root_unresolved 52.8 0.022   NTclustered gi|1389182097|gb|CP029160.1| 4932 g37979 i0 100 0.67741935483871 28 0 11 0 14 41 4108553 4108580 Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence blastn 168 52.8 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycetales Saccharomycetaceae Saccharomyces Saccharomyces cerevisiae
17578613 17578613 PRJNA1002570_P_NODE_40674_length_245_cov_1.598837_g40479_i0 PRJNA1002570 40674 245 1.598837 3.91715065 Fungi 4751 Fungi Fungi 453 5.1900000000000006e-123   NTclustered gi|2612872|gb|AF010303.1| 63354 g40479 i0 100 100 245 0 100 0 1 245 39 283 Sclerotium sp. BSC-97 18S ribosomal RNA gene, partial sequence blastn 24500 453 1 Eukaryota Opisthokonta Fungi Ascomycota Leotiomycetes Helotiales Sclerotiniaceae   Sclerotiniaceae sp. BSC-97
17578633 17578633 PRJNA1002570_P_NODE_43614_length_241_cov_2.720238_g43419_i0 PRJNA1002570 43614 241 2.720238 6.55577358 Aspergillaceae 1131492 Fungi Fungi 446 8.519999999999999e-121   NTclustered gi|37786660|gb|AY213699.1| 5054 g43419 i0 100 100.004149377593 241 0 100 0 1 241 51 291 Eurotium amstelodami strain UWFP 1115 28S ribosomal RNA gene, partial sequence blastn 24101 446 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Aspergillus Aspergillus amstelodami
19278102 19278102 PRJNA1002570_P_NODE_38936_length_247_cov_1.770115_g38741_i0 PRJNA1002570 38936 247 1.770115 4.37218405 Talaromyces stipitatus 28564 Fungi Fungi 60.2 1.33e-4   NTclustered gi|242762605|ref|XM_002340370.1| 441959 g38741 i0 100 0.129554655870445 32 0 13 0 110 141 2444 2413 Talaromyces stipitatus ATCC 10500 AP-3 adaptor complex subunit beta, putative (TSTA_064870), partial mRNA blastn 32 60.2 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Trichocomaceae Talaromyces Talaromyces stipitatus
20553471 20553471 PRJNA1002570_P_NODE_24917_length_279_cov_5.844660_g24722_i0 PRJNA1002570 24917 279 5.84466 16.3066014 Colletotrichum karsti 1095194 Fungi Fungi 54.7 0.007   NTclustered gi|1955625415|ref|XM_038893761.1| 1095194 g24722 i0 100 0.706093189964158 29 0 10 0 251 279 48 76 Colletotrichum karsti uncharacterized protein (CkaCkLH20_11047), partial mRNA blastn 197 54.7 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Glomerellales Glomerellaceae Colletotrichum Colletotrichum karsti
23104643 23104643 PRJNA1002570_P_NODE_33039_length_259_cov_1.655914_g32844_i0 PRJNA1002570 33039 259 1.655914 4.28881726 Alternaria arborescens 156630 Fungi Fungi 385 2.05e-102   NTclustered gi|1607833687|ref|XM_028655730.1| 156630 g32844 i0 99.526 3.25868725868726 211 1 81 0 1 211 396 606 Alternaria arborescens hypothetical protein (AA0111_g9199), partial mRNA blastn 844 385 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales Pleosporaceae Alternaria Alternaria arborescens
24378065 24378065 PRJNA1002570_P_NODE_15860_length_310_cov_2.827004_g15665_i0 PRJNA1002570 15860 310 2.827004 8.7637124 Didymella exigua 100019 Fungi Fungi 122 2.1799999999999999e-23   NTclustered gi|1832861850|ref|XM_033590596.1| 1150837 g15665 i0 81.333 1.8741935483871 150 28 48 0 161 310 972 823 Didymella exigua CBS 183.55 multicopper oxidase (M421DRAFT_415172), mRNA blastn 581 122 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales Didymellaceae Didymella Didymella exigua
24378153 24378153 PRJNA1002570_P_NODE_20320_length_289_cov_4.060185_g20125_i0 PRJNA1002570 20320 289 4.060185 11.73393465 Hirsutella rhossiliensis 111463 Fungi Fungi 52.8 0.027   NTclustered gi|2124715236|ref|XM_044860115.1| 111463 g20125 i0 100 0.0968858131487889 28 0 10 0 254 281 152 125 Hirsutella rhossiliensis BRO1-like domain-containing protein (HRG_01644), partial mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Ophiocordycipitaceae Hirsutella Hirsutella rhossiliensis
24378510 24378510 PRJNA1002570_P_NODE_39180_length_247_cov_0.885057_g38985_i0 PRJNA1002570 39180 247 0.885057 2.18609079 Verticillium dahliae 27337 Fungi Fungi 451 1.88e-122   NTclustered gi|697084328|ref|XM_009656871.1| 498257 g38985 i0 99.595 10.663967611336 247 1 100 0 1 247 686 932 Verticillium dahliae VdLs.17 GTP-binding nuclear protein GSP1/Ran (VDAG_03006), mRNA blastn 2634 451 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Glomerellales Plectosphaerellaceae Verticillium Verticillium dahliae

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;