RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1151638" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

analysis 2

tax_superkingdom 1

  • Archaea · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA1151638 · 4 ✖
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
15064649 15064649 PRJNA1151638_P_NODE_3172_length_288_cov_12.413953_g3105_i0 PRJNA1151638 3172 288 12.413953 35.75218464 root 1 Root_unresolved Root_unresolved 532 7.8e-147   NTclustered gi|2621785414|emb|OY781872.1| 1005933 g3105 i0 100 337.322916666667 288 0 100 0 1 288 3115898 3116185 MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 blastn 97149 532 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula uncultured Methanoregula sp.
28322909 28322909 PRJNA1151638_P_NODE_4306_length_261_cov_1.606383_g4239_i0 PRJNA1151638 4306 261 1.606383 4.19265963 root 1 Root_unresolved Root_unresolved 62.8 1.3e-9   NR MCD4666859.1 1906665 g4239 i0 43.8 4.68965517241379 73 41 83.9 0 43 261 49 121 MCD4666859.1 rhomboid family intramembrane serine protease [archaeon] diamond 1224 63.2 0.993670886075949 Archaea               archaeon
28587959 28587959 PRJNA1151638_P_NODE_4287_length_261_cov_2.851064_g4220_i0 PRJNA1151638 4287 261 2.851064 7.44127704 Nitrososphaerota archaeon 2026795 Archaea Archaea 67.8 5.29e-12   NR MDG6934888.1 2026795 g4220 i0 40.7 3.42528735632184 86 46 98.9 1 2 259 24 104 MDG6934888.1 hypothetical protein [Nitrososphaerota archaeon] diamond 894 67.8 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31557493 31557493 PRJNA1151638_P_NODE_1836_length_349_cov_2.474638_g1769_i0 PRJNA1151638 1836 349 2.474638 8.63648662 Halorubrum trueperi 2004704 Archaea Archaea 44.7 0.024   NR WP_379766114.1 2004704 g1769 i0 36.6 0.70487106017192 82 39 60.2 3 227 18 16 96 WP_379766114.1 transposase [Halorubrum trueperi] diamond 246 44.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum trueperi

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