RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA674048" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA674048 · 4 ✖

analysis 1

  • diamond · 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
27883289 27883289 PRJNA674048_P_NODE_29805_length_165_cov_1.793103_g29602_i0 PRJNA674048 29805 165 1.793103 2.95861995 root 1 Root_unresolved Root_unresolved 50.4 2.91e-6   NR WP_048102805.1 2208 g29602 i0 52.2 2.32727272727273 46 22 83.6 0 27 164 3 48 WP_048102805.1 hypothetical protein [Methanosarcina barkeri] diamond 384 50.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina barkeri
31946531 31946531 PRJNA674048_P_NODE_29497_length_166_cov_0.888889_g29294_i0 PRJNA674048 29497 166 0.888889 1.47555574 Candidatus Poseidoniales archaeon 2163009 Archaea Archaea 94 3.0300000000000003e-21   NR MEK9694268.1 2163009 g29294 i0 77.8 0.975903614457831 54 12 97.6 0 164 3 277 330 MEK9694268.1 hypothetical protein [Candidatus Poseidoniales archaeon] diamond 162 94 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
31978279 31978279 PRJNA674048_P_NODE_19418_length_200_cov_2.721854_g19215_i0 PRJNA674048 19418 200 2.721854 5.443708 Methanobacteriota archaeon 2026739 Archaea Archaea 44.7 0.00452   NR MAQ04991.1 2026739 g19215 i0 39.6 0.795 53 30 79.5 1 186 28 530 580 MAQ04991.1 hypothetical protein [Methanobacteriota archaeon] diamond 159 44.7 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
32041677 32041677 PRJNA674048_P_NODE_32838_length_162_cov_0.920354_g32635_i0 PRJNA674048 32838 162 0.920354 1.49097348 Methanobacteriota archaeon 2026739 Archaea Archaea 100 1.29e-23   NR MCH7660952.1 2026739 g32635 i0 94.2 0.962962962962963 52 3 96.3 0 160 5 190 241 MCH7660952.1 type II glyceraldehyde-3-phosphate dehydrogenase [Methanobacteriota archaeon] diamond 156 100 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon

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