RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 3 ✖

bioproject 1

  • PRJNA784298 · 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
31096184 31096184 PRJNA784298_P_NODE_10075_length_396_cov_0.953560_g9874_i0 PRJNA784298 10075 396 0.95356 3.7760976 Methanosarcina sp. 2213 Archaea Archaea 63.5 2.65e-9   NR HET8688382.1 2213 g9874 i0 35.5 0.916666666666667 121 69 85.6 5 362 24 22 141 HET8688382.1 RNase H family protein [Methanosarcina sp.] diamond 363 63.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
32686507 32686507 PRJNA784298_P_NODE_20700_length_271_cov_1.388889_g20499_i0 PRJNA784298 20700 271 1.388889 3.76388919 root 1 Root_unresolved Root_unresolved 58.5 5.12e-8   NR MFA5398780.1 2196 g20499 i0 36.3 3.34317343173432 80 44 84.1 2 268 41 25 101 MFA5398780.1 6-carboxytetrahydropterin synthase [Methanogenium sp.] diamond 906 58.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanogenium Methanogenium sp.
32866235 32866235 PRJNA784298_P_NODE_15380_length_317_cov_2.176230_g15179_i0 PRJNA784298 15380 317 2.17623 6.8986491 Methanosarcina sp. 2213 Archaea Archaea 79 1.48e-14   NR HET8686511.1 2213 g15179 i0 40.4 1.03154574132492 109 60 98.4 1 316 5 235 343 HET8686511.1 class I SAM-dependent methyltransferase [Methanosarcina sp.] diamond 327 79 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.

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