RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB83711 · 2 ✖

analysis 1

  • diamond · 2 ✖
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
28448379 28448379 PRJEB83711_P_NODE_82226_length_224_cov_4.377483_g81960_i0 PRJEB83711 82226 224 4.377483 9.80556192 root 1 Root_unresolved Root_unresolved 44.3 0.00835   NR PFX21664.1 50429 g81960 i0 42.2 1.09821428571429 45 26 60.3 0 72 206 230 274 PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata] diamond 246 44.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
28802596 28802596 PRJEB83711_P_NODE_24728_length_358_cov_1.091228_g24462_i0 PRJEB83711 24728 358 1.091228 3.90659624 Sphaeromyxa zaharoni 275449 Cnidaria other_Eukaryota 71.6 5.82e-12   NR YP_011052095.1 275449 g24462 i0 38.8 0.82122905027933 98 59 81.3 1 319 29 184 281 YP_011052095.1 NADH dehydrogenase subunit 1 [Sphaeromyxa zaharoni] diamond 294 71.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Sphaeromyxidae Sphaeromyxa Sphaeromyxa zaharoni

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