RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA800053" 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 · 3 ✖

bioproject 1

  • PRJNA800053 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
28190877 28190877 PRJNA800053_P_NODE_23686_length_241_cov_0.916667_g23522_i0 PRJNA800053 23686 241 0.916667 2.20916747 Scenedesmus sp. NREL 46B-D3 2650976 Plants Plants 72 1.53e-12   NR KAF6252184.1 2650976 g23522 i0 47.8 5.47717842323651 90 36 98.3 1 238 2 289 378 KAF6252184.1 mitochondrial carrier domain-containing protein [Scenedesmus sp. NREL 46B-D3] diamond 1320 72 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Scenedesmus Scenedesmus sp. NREL 46B-D3
28294688 28294688 PRJNA800053_P_NODE_23946_length_241_cov_0.916667_g23782_i0 PRJNA800053 23946 241 0.916667 2.20916747 Chlorophyta 3041 Plants Plants 107 6.77e-25   NR KAK9810134.1 41462 g23782 i0 64.6 9.83402489626556 79 28 98.3 0 3 239 333 411 KAK9810134.1 hypothetical protein WJX72_005428 [[Myrmecia] bisecta] diamond 2370 107 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Myrmecia [Myrmecia] bisecta
31033840 31033840 PRJNA800053_P_NODE_20515_length_246_cov_0.890173_g20351_i0 PRJNA800053 20515 246 0.890173 2.18982558 Scenedesmus sp. NREL 46B-D3 2650976 Plants Plants 51.6 2.87e-5   NR KAF6251104.1 2650976 g20351 i0 62.2 0.451219512195122 37 14 45.1 0 163 53 196 232 KAF6251104.1 hypothetical protein COO60DRAFT_672416 [Scenedesmus sp. NREL 46B-D3] diamond 111 51.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Scenedesmus Scenedesmus sp. NREL 46B-D3

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