RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 6 ✖

bioproject 1

  • PRJNA896554 · 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
3421566 3421566 PRJNA896554_P_NODE_165043_length_245_cov_0.895349_g157503_i0 PRJNA896554 165043 245 0.895349 2.19360505 Haloplanus 376170 Archaea Archaea 110 1.03e-28   NR MFB6124115.1 2080321 g157503 i0 88.5 1.49387755102041 61 7 74.7 0 4 186 85 145 MFB6124115.1 universal stress protein [Haloferacaceae archaeon] diamond 366 111 0.990990990990991 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae   Haloferacaceae archaeon
28445441 28445441 PRJNA896554_P_NODE_86466_length_373_cov_1.796667_g78926_i0 PRJNA896554 86466 373 1.796667 6.70156791 Methanobacteriota archaeon 2026739 Archaea Archaea 66.2 9.4e-10   NR MDQ1274818.1 2026739 g78926 i0 58.3 2.10723860589812 48 20 38.6 0 146 3 120 167 MDQ1274818.1 hypothetical protein [Methanobacteriota archaeon] diamond 786 66.2 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
29676303 29676303 PRJNA896554_P_NODE_36970_length_978_cov_2.232044_g30317_i0 PRJNA896554 36970 978 2.232044 21.82939032 Methanoculleus sp. 90427 Archaea Archaea 99.8 2.81e-19   NR WP_346733691.1 90427 g30317 i0 32.9 1.35276073619632 234 134 69.9 7 293 976 57 273 WP_346733691.1 kelch repeat-containing protein [Methanoculleus sp.] diamond 1323 99.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp.
29834505 29834505 PRJNA896554_P_NODE_120151_length_291_cov_1.059633_g112611_i0 PRJNA896554 120151 291 1.059633 3.08353203 Thermoplasmatota archaeon 2806419 Archaea Archaea 53.1 1.25e-5   NR MCL5731025.1 2806419 g112611 i0 39.1 2.08247422680412 64 39 66 0 252 61 225 288 MCL5731025.1 tetratricopeptide repeat protein [Thermoplasmatota archaeon] diamond 606 53.1 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
30972061 30972061 PRJNA896554_P_NODE_172914_length_242_cov_0.911243_g165374_i0 PRJNA896554 172914 242 0.911243 2.20520806 Methanobrevibacter sp. 66852 Archaea Archaea 89 1.41e-18   NR WP_292778043.1 66852 g165374 i0 97.7 2.13223140495868 43 1 53.3 0 3 131 383 425 WP_292778043.1 serine--tRNA ligase [Methanobrevibacter sp.] diamond 516 89 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
32647581 32647581 PRJNA896554_P_NODE_147020_length_254_cov_1.447514_g139480_i0 PRJNA896554 147020 254 1.447514 3.67668556 Natronomonas aquatica 2841590 Archaea Archaea 124 6.53e-33   NR WP_256029701.1 2841590 g139480 i0 85.1 0.874015748031496 74 11 87.4 0 222 1 143 216 WP_256029701.1 enoyl-CoA hydratase/isomerase family protein [Natronomonas aquatica] diamond 222 124 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas aquatica

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