RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA397733" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA397733 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
1686959 1686959 PRJNA397733_S_NODE_10262_length_188_cov_3.050314_g10174_i0 PRJNA397733 10262 188 3.050314 5.73459032 uncultured Saccharomycetes 212404 Fungi Fungi 326 8.6e-85   NTclustered gi|294861105|gb|GU370918.1| 212404 g10174 i0 99.441 97.2712765957447 179 1 95 0 10 188 1 179 Uncultured Saccharomycetes isolate DGGE gel band 12 26S ribosomal RNA gene, partial sequence blastn 18287 326 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes       uncultured Saccharomycetes
2355313 2355313 PRJNA397733_S_NODE_11682_length_177_cov_4.702703_g11594_i0 PRJNA397733 11682 177 4.702703 8.32378431 Dothideomycetes 147541 Fungi Fungi 315 1.73e-81   NTclustered gi|2811941437|gb|PQ403666.1| 92990 g11594 i0 98.87 100 177 1 100 1 1 177 27 202 Trimmatostroma salinum strain EXF-295 small subunit ribosomal RNA gene, partial sequence blastn 17700 315 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Mycosphaerellales Mycosphaerellaceae Trimmatostroma Trimmatostroma salinum
6182975 6182975 PRJNA397733_S_NODE_6185_length_242_cov_5.450704_g6097_i0 PRJNA397733 6185 242 5.450704 13.19070368 Eukaryota 2759 Fungi Fungi 442 1.1099999999999995e-119   NTclustered gi|2532687033|gb|OR243761.1| 29917 g6097 i0 99.587 99.9380165289256 242 1 100 0 1 242 3676 3917 Cladosporium cladosporioides strain DSM 104381 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 24185 442 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Cladosporiales Cladosporiaceae Cladosporium Cladosporium cladosporioides
10007987 10007987 PRJNA397733_S_NODE_15368_length_157_cov_2.273438_g15280_i0 PRJNA397733 15368 157 2.273438 3.56929766 root 1 Root_unresolved Root_unresolved 291 2.52e-74   NTclustered gi|18147565|dbj|AB054675.1| 4911 g15280 i0 100 107 157 0 100 0 1 157 285 129 Kluyveromyces marxianus gene for 18S rRNA, partial sequence blastn 16799 291 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycetales Saccharomycetaceae Kluyveromyces Kluyveromyces marxianus
12558630 12558630 PRJNA397733_S_NODE_8410_length_207_cov_3.668539_g8322_i0 PRJNA397733 8410 207 3.668539 7.59387573 root 1 Root_unresolved Root_unresolved 383 5.65e-102   NTclustered gi|1389182097|gb|CP029160.1| 4932 g8322 i0 100 117.12077294686 207 0 100 0 1 207 3880389 3880595 Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence blastn 24244 383 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycetales Saccharomycetaceae Saccharomyces Saccharomyces cerevisiae
13833398 13833398 PRJNA397733_S_NODE_5351_length_262_cov_3.476395_g5263_i0 PRJNA397733 5351 262 3.476395 9.1081549 root 1 Root_unresolved Root_unresolved 484 1.99e-132   NTclustered gi|1389182097|gb|CP029160.1| 4932 g5263 i0 100 113.908396946565 262 0 100 0 1 262 3882256 3881995 Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence blastn 29844 484 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycetales Saccharomycetaceae Saccharomyces Saccharomyces cerevisiae
21481601 21481601 PRJNA397733_S_NODE_7497_length_220_cov_9.293194_g7409_i0 PRJNA397733 7497 220 9.293194 20.4450268 Fungi 4751 Fungi Fungi 407 3.61e-109   NTclustered gi|2612872|gb|AF010303.1| 63354 g7409 i0 100 100 220 0 100 0 1 220 234 15 Sclerotium sp. BSC-97 18S ribosomal RNA gene, partial sequence blastn 22000 407 1 Eukaryota Opisthokonta Fungi Ascomycota Leotiomycetes Helotiales Sclerotiniaceae   Sclerotiniaceae sp. BSC-97
22756861 22756861 PRJNA397733_S_NODE_7318_length_223_cov_5.943299_g7230_i0 PRJNA397733 7318 223 5.943299 13.25355677 Parastagonospora 1351751 Fungi Fungi 407 3.67e-109   NTclustered gi|154563031|gb|EF590321.2| 215456 g7230 i0 99.552 118.085201793722 223 1 100 0 1 223 1637 1415 Phaeosphaeria avenaria f. sp. avenaria strain ATCC 12277 large subunit ribosomal RNA gene, partial sequence blastn 26333 407 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales Phaeosphaeriaceae Parastagonospora Parastagonospora avenae
24031663 24031663 PRJNA397733_S_NODE_7199_length_225_cov_7.464286_g7111_i0 PRJNA397733 7199 225 7.464286 16.7946435 Opisthokonta 33154 Fungi Fungi 388 1.34e-103   NTclustered gi|283827952|gb|EU019262.2| 29917 g7111 i0 98.198 98.3822222222222 222 4 99 0 4 225 2580 2359 Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence blastn 22136 388 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Cladosporiales Cladosporiaceae Cladosporium Cladosporium cladosporioides
24031664 24031664 PRJNA397733_S_NODE_8079_length_211_cov_10.483516_g7991_i0 PRJNA397733 8079 211 10.483516 22.12021876 root 1 Root_unresolved Root_unresolved 363 7.539999999999999e-96   NTclustered gi|1354561844|gb|MH023283.1| 4932 g7991 i0 97.63 106 211 5 100 0 1 211 947 737 Saccharomyces cerevisiae strain GITA551 small subunit ribosomal RNA gene, partial sequence blastn 22366 363 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycetales Saccharomycetaceae Saccharomyces Saccharomyces cerevisiae
25306053 25306053 PRJNA397733_S_NODE_1560_length_517_cov_6.290984_g1084_i1 PRJNA397733 1560 517 6.290984 32.52438728 Ascomycota 4890 Fungi Fungi 939 0   NTclustered gi|1846443776|gb|MT536090.1| 5061 g1084 i1 99.42 100 517 3 100 0 1 517 554 38 Aspergillus niger isolate PUD large subunit ribosomal RNA gene, partial sequence blastn 51700 939 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Aspergillus Aspergillus niger

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