RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA944406 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
924488 924488 PRJNA944406_P_NODE_39321_length_273_cov_1.530000_g38362_i0 PRJNA944406 39321 273 1.53 4.1769 Haloarcula litorea 3032579 Archaea Archaea 52.8 0.025   NTclustered gi|2463595526|gb|CP119779.1| 3032579 g38362 i0 100 0.102564102564103 28 0 10 0 188 215 847737 847710 Haloarcula litorea strain GDY20 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Haloarcula Haloarcula litorea
1259421 1259421 PRJNA944406_P_NODE_34121_length_278_cov_1.434146_g33162_i0 PRJNA944406 34121 278 1.434146 3.98692588 Halobacterium 2239 Archaea Archaea 95.3 4.19e-15   NTclustered gi|966204314|emb|LN831302.1| 1407499 g33162 i0 93.651 6.51798561151079 63 4 23 0 190 252 896973 897035 Halobacterium hubeiense strain JI20-1 genome assembly, chromosome: I blastn 1812 95.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium hubeiense
1259546 1259546 PRJNA944406_P_NODE_76141_length_248_cov_1.577143_g75182_i0 PRJNA944406 76141 248 1.577143 3.91131464 Methanobrevibacter 2172 Archaea Archaea 416 6.9e-112   NTclustered gi|1294447101|gb|CP017803.1| 2173 g75182 i0 97.177 138.237903225806 248 4 100 1 1 248 265311 265067 Methanobrevibacter smithii strain KB11 chromosome, complete genome blastn 34283 416 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
6027612 6027612 PRJNA944406_P_NODE_32545_length_279_cov_2.165049_g31586_i0 PRJNA944406 32545 279 2.165049 6.04048671 Halobacterium hubeiense 1407499 Archaea Archaea 52.8 0.026   NTclustered gi|966204314|emb|LN831302.1| 1407499 g31586 i0 100 0.100358422939068 28 0 10 0 11 38 144533 144560 Halobacterium hubeiense strain JI20-1 genome assembly, chromosome: I blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium hubeiense
18776921 18776921 PRJNA944406_P_NODE_97875_length_243_cov_1.676471_g96916_i0 PRJNA944406 97875 243 1.676471 4.0738245300000004 Methanobacterium lacus 877455 Archaea Archaea 337 5.399999999999998e-88   NTclustered gi|325329191|gb|CP002551.1| 877455 g96916 i0 94.118 5.46090534979424 221 13 91 0 1 221 580339 580559 Methanobacterium lacus strain AL-21, complete genome blastn 1327 337 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium lacus
22601351 22601351 PRJNA944406_P_NODE_19618_length_297_cov_2.607143_g18659_i0 PRJNA944406 19618 297 2.607143 7.74321471 Methanogenium organophilum 2199 Archaea Archaea 303 6.9000000000000015e-78   NTclustered gi|2388587735|gb|CP113361.1| 2199 g18659 i0 92.093 0.723905723905724 215 17 72 0 3 217 2242403 2242189 Methanogenium organophilum strain DSM 3596 chromosome, complete genome blastn 215 303 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanogenium Methanogenium organophilum
22601640 22601640 PRJNA944406_P_NODE_45478_length_267_cov_1.587629_g44519_i0 PRJNA944406 45478 267 1.587629 4.23896943 Haloferax mediterranei 2252 Archaea Archaea 52.8 0.024   NTclustered gi|640913992|gb|CP001868.2| 523841 g44519 i0 96.774 0.337078651685393 31 1 12 0 94 124 2373736 2373766 Haloferax mediterranei ATCC 33500, complete genome blastn 90 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloferax Haloferax mediterranei

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