RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA577226" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 6 ✖

bioproject 1

  • PRJNA577226 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
26871987 26871987 PRJNA577226_S_NODE_48161_length_180_cov_1.160839_g47222_i0 PRJNA577226 48161 180 1.160839 2.0895102 root 1 Root_unresolved Root_unresolved 102 1.73e-26   NR MDG3548624.1 2162 g47222 i0 96.3 1.8 54 2 90 0 180 19 44 97 MDG3548624.1 tripartite tricarboxylate transporter substrate-binding protein [Methanobacterium formicicum] diamond 324 103 0.990291262135922 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium formicicum
27364397 27364397 PRJNA577226_S_NODE_13943_length_346_cov_4.792880_g13004_i0 PRJNA577226 13943 346 4.79288 16.5833648 Methanohalobium sp. 2837493 Archaea Archaea 62 1.16e-9   NR WP_292486517.1 2837493 g13004 i0 51.4 0.606936416184971 70 28 55.5 1 154 345 4 73 WP_292486517.1 hypothetical protein [Methanohalobium sp.] diamond 210 62 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanohalobium Methanohalobium sp.
27553338 27553338 PRJNA577226_S_NODE_69424_length_152_cov_1.695652_g68485_i0 PRJNA577226 69424 152 1.695652 2.57739104 Pyrococcus horikoshii OT3 70601 Archaea Archaea 49.7 1.92e-6   NR BAA29292.1 70601 g68485 i0 54 0.986842105263158 50 23 98.7 0 152 3 3 52 BAA29292.1 52aa long hypothetical protein [Pyrococcus horikoshii OT3] diamond 150 49.7 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Pyrococcus Pyrococcus horikoshii
28500853 28500853 PRJNA577226_S_NODE_18707_length_295_cov_1.662791_g17768_i0 PRJNA577226 18707 295 1.662791 4.90523345 Thermoplasmata archaeon 1906666 Archaea Archaea 46.2 0.00423   NR HEY1197429.1 1906666 g17768 i0 38.2 0.691525423728814 68 36 63.1 2 240 55 91 158 HEY1197429.1 DUF87 domain-containing protein [Thermoplasmata archaeon] diamond 204 46.2 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
30743129 30743129 PRJNA577226_S_NODE_6594_length_532_cov_2.597980_g5668_i0 PRJNA577226 6594 532 2.59798 13.8212536 Methanobacteriota archaeon 2026739 Archaea Archaea 45.8 0.0463   NR NOZ76890.1 2026739 g5668 i0 32.1 0.473684210526316 84 53 47.4 2 269 520 152 231 NOZ76890.1 minichromosome maintenance protein MCM [Methanobacteriota archaeon] diamond 252 45.8 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
32293019 32293019 PRJNA577226_S_NODE_63599_length_158_cov_1.289256_g62660_i0 PRJNA577226 63599 158 1.289256 2.03702448 Candidatus Alkanophaga volatiphilum 2971472 Archaea Archaea 41.6 0.0232   NR MDF2957853.1 2971472 g62660 i0 51.2 0.778481012658228 41 20 77.8 0 31 153 58 98 MDF2957853.1 hypothetical protein [Candidatus Alkanophaga volatiphilum] diamond 123 41.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Candidatus Alkanophagales   Candidatus Alkanophaga Candidatus Alkanophaga volatiphilum

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