RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB75230", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 3 ✖

tax_clade 1

bioproject 1

  • PRJEB75230 · 3 ✖

analysis 1

tax_kingdom 0

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
12890645 12890645 PRJEB75230_P_NODE_3291_length_746_cov_12.576523_g3125_i0 PRJEB75230 3291 746 12.576523 93.82086158 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 273 3.6499999999999996e-89   NR MES1912193.1 1215613 g3125 i0 55.5 7.62868632707775 238 106 95.7 0 732 19 1 238 MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] diamond 5691 273 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
15439452 15439452 PRJEB75230_P_NODE_2833_length_802_cov_2.475995_g2674_i0 PRJEB75230 2833 802 2.475995 19.8574799 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 190 6.7699999999999985e-56   NR MES1913935.1 1215613 g2674 i0 50.2 1.54862842892768 217 102 81.2 3 795 145 1 211 MES1913935.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1242 190 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27192120 27192120 PRJEB75230_P_NODE_92342_length_269_cov_2.005102_g92160_i0 PRJEB75230 92342 269 2.005102 5.39372438 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.81e-7   NR MES1909394.1 1215613 g92160 i0 32.6 1.75092936802974 89 51 95.9 3 5 262 220 302 MES1909394.1 hypothetical protein [Cercozoa sp. M6MM] diamond 471 58.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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