RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB12578 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
28548521 28548521 PRJDB12578_S_NODE_132807_length_223_cov_0.896552_g109749_i0 PRJDB12578 132807 223 0.896552 1.99931096 Paxillus ammoniavirescens 1132860 Fungi Fungi 42 0.0254   NR KAF8843422.1 1132860 g109749 i0 25 0.860986547085202 64 48 86.1 0 192 1 70 133 KAF8843422.1 hypothetical protein BDN67DRAFT_964545 [Paxillus ammoniavirescens] diamond 192 42 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Boletales Paxillaceae Paxillus Paxillus ammoniavirescens
30790658 30790658 PRJDB12578_S_NODE_174254_length_182_cov_1.526316_g151196_i0 PRJDB12578 174254 182 1.526316 2.77789512 Austropuccinia psidii 181123 Fungi Fungi 43.9 0.00641   NR MBW0511442.1 1389203 g151196 i0 44.9 0.807692307692308 49 25 77.5 1 27 167 359 407 MBW0511442.1 hypothetical protein [Austropuccinia psidii MF-1] diamond 147 43.9 1 Eukaryota Opisthokonta Fungi Basidiomycota Pucciniomycetes Pucciniales Sphaerophragmiaceae Austropuccinia Austropuccinia psidii
31296237 31296237 PRJDB12578_S_NODE_144335_length_209_cov_1.281250_g121277_i0 PRJDB12578 144335 209 1.28125 2.6778125 Sparassis crispa 139825 Fungi Fungi 55.1 1.08e-6   NR XP_027620327.1 139825 g121277 i0 58.5 2.35406698564593 41 17 58.9 0 123 1 1347 1387 XP_027620327.1 hypothetical protein SCP_1600760 [Sparassis crispa] diamond 492 55.1 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Polyporales Sparassidaceae Sparassis Sparassis crispa
32213783 32213783 PRJDB12578_S_NODE_158758_length_195_cov_1.068493_g135700_i0 PRJDB12578 158758 195 1.068493 2.08356135 Sphaerobolus stellatus SS14 990650 Fungi Fungi 43.1 0.0145   NR KIJ25936.1 990650 g135700 i0 43.9 0.630769230769231 41 23 63.1 0 135 13 278 318 KIJ25936.1 hypothetical protein M422DRAFT_273077 [Sphaerobolus stellatus SS14] diamond 123 43.1 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Geastrales Sphaerobolaceae Sphaerobolus Sphaerobolus stellatus

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