RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB50765" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB50765 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
27974411 27974411 PRJEB50765_P_NODE_3285_length_151_cov_1.368421_g3261_i0 PRJEB50765 3285 151 1.368421 2.06631571 Ascomycota 4890 Fungi Fungi 45.4 5.88e-4   NR XP_064730136.1 1635080 g3261 i0 34 7.86754966887417 50 33 99.3 0 1 150 7 56 XP_064730136.1 uncharacterized protein PMZ80_005999 [Knufia obscura] diamond 1188 45.4 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Chaetothyriales Trichomeriaceae Knufia Knufia obscura
28258418 28258418 PRJEB50765_P_NODE_786_length_376_cov_1.362832_g762_i0 PRJEB50765 786 376 1.362832 5.12424832 Trypetheliaceae 271822 Fungi Fungi 157 9.43e-46   NR QIW95448.1 286661 g762 i0 58.5 18.6542553191489 123 51 98.1 0 6 374 4 126 QIW95448.1 hypothetical protein AMS68_000966 [Peltaster fructicola] diamond 7014 157 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes     Peltaster Peltaster fructicola
31290621 31290621 PRJEB50765_P_NODE_2675_length_170_cov_2.315789_g2651_i0 PRJEB50765 2675 170 2.315789 3.9368413 Hypocreales 5125 Fungi Fungi 69.7 6.08e-13   NR KAK0386690.1 5046 g2651 i0 62.5 3.93529411764706 56 21 98.8 0 170 3 26 81 KAK0386690.1 hypothetical protein NLU13_6524 [Sarocladium strictum] diamond 669 70.1 0.994293865905849 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Sarocladiaceae Sarocladium Sarocladium strictum
32404784 32404784 PRJEB50765_P_NODE_3199_length_153_cov_1.681034_g3175_i0 PRJEB50765 3199 153 1.681034 2.57198202 Westerdykella ornata 318751 Fungi Fungi 49.3 4.46e-5   NR XP_033654656.1 318751 g3175 i0 53.1 2.64705882352941 49 23 96.1 0 152 6 50 98 XP_033654656.1 60S ribosomal protein L7 [Westerdykella ornata] diamond 405 49.3 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales Sporormiaceae Westerdykella Westerdykella ornata
32499840 32499840 PRJEB50765_P_NODE_779_length_379_cov_1.906433_g755_i0 PRJEB50765 779 379 1.906433 7.22538107 Lipomyces arxii 56418 Fungi Fungi 67.4 2.99e-11   NR XP_066769882.1 56418 g755 i0 40.5 2.02638522427441 84 50 66.5 0 378 127 63 146 XP_066769882.1 ribosomal protein S27a-domain-containing protein [Lipomyces arxii] diamond 768 67.4 1 Eukaryota Opisthokonta Fungi Ascomycota Lipomycetes Lipomycetales Lipomycetaceae Lipomyces Lipomyces arxii
32808055 32808055 PRJEB50765_P_NODE_1500_length_248_cov_1.284360_g1476_i0 PRJEB50765 1500 248 1.28436 3.1852128 Fungi 4751 Fungi Fungi 64.7 5.93e-11   NR KAI5308241.1 51567 g1476 i0 51.8 3.54435483870968 56 27 67.7 0 243 76 54 109 KAI5308241.1 40S ribosomal protein S19, partial [Ascosphaera atra] diamond 879 65.1 0.993855606758833 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Onygenales Ascosphaeraceae Ascosphaera Ascosphaera atra

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