RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 5 ✖

bioproject 1

  • PRJNA558770 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
27092924 27092924 PRJNA558770_P_NODE_158002_length_234_cov_5.879397_g155997_i0 PRJNA558770 158002 234 5.879397 13.75778898 Eukaryota 2759 Plants Plants 58.9 6.64e-8   NR XP_002946243.1 3068 g155997 i0 96 150.935897435897 25 1 32.1 0 160 234 384 408 XP_002946243.1 uncharacterized protein VOLCADRAFT_78921 [Volvox carteri f. nagariensis] diamond 35319 59.3 0.993254637436762 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Volvocaceae Volvox Volvox carteri
27377716 27377716 PRJNA558770_P_NODE_246423_length_234_cov_2.386935_g244418_i0 PRJNA558770 246423 234 2.386935 5.5854279 Eukaryota 2759 Plants Plants 45.4 4.14e-4   NR NP_042270.1 3111 g244418 i0 87.5 23.6538461538462 24 3 30.8 0 3 74 26 49 NP_042270.1 H(+)-transporting ATPase, subunit 9 [Prototheca wickerhamii] diamond 5535 45.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Prototheca Prototheca wickerhamii
30363711 30363711 PRJNA558770_P_NODE_328832_length_233_cov_6.530303_g326827_i0 PRJNA558770 328832 233 6.530303 15.21560599 Acetabularia peniculus 35862 Plants Plants 52.4 1.21e-5   NR P48481.1 35862 g326827 i0 91.7 13.5064377682403 24 2 30.9 0 4 75 216 239 P48481.1 RecName: Full=Serine/threonine-protein phosphatase PP1 isozyme 2 [Acetabularia peniculus] diamond 3147 52.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Dasycladales Polyphysaceae Acetabularia Acetabularia peniculus
31026953 31026953 PRJNA558770_P_NODE_285535_length_234_cov_1.648241_g283530_i0 PRJNA558770 285535 234 1.648241 3.85688394 Sanguina aurantia 2578422 Plants Plants 51.2 3.57e-5   NR MEW5302432.1 2578422 g283530 i0 92 0.320512820512821 25 2 32.1 0 1 75 1851 1875 MEW5302432.1 hypothetical protein [Sanguina aurantia] diamond 75 51.2 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Sanguina Sanguina aurantia
31374681 31374681 PRJNA558770_P_NODE_79576_length_235_cov_6.365000_g77571_i0 PRJNA558770 79576 235 6.365 14.95775 Trebouxia sp. A1-2 2608996 Plants Plants 45.4 0.00109   NR QIQ59662.1 2608996 g77571 i0 87.5 0.306382978723404 24 3 30.6 0 4 75 44 67 QIQ59662.1 ribosomal protein S10 [Trebouxia sp. A1-2] diamond 72 45.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. A1-2

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