RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA1160211 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
27533687 27533687 PRJNA1160211_S_NODE_58923_length_550_cov_7.807128_g57739_i0 PRJNA1160211 58923 550 7.807128 42.939204 root 1 Root_unresolved Root_unresolved 77 8.77e-13   NR MBJ35148.1 2026739 g57739 i0 44.7 2.04545454545455 94 43 46.4 3 453 199 320 413 MBJ35148.1 hypothetical protein [Methanobacteriota archaeon] diamond 1125 77 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
27861576 27861576 PRJNA1160211_S_NODE_274605_length_245_cov_1.924419_g273372_i0 PRJNA1160211 274605 245 1.924419 4.71482655 Halospeciosus flavus 3032283 Archaea Archaea 152 1.0299999999999998e-43   NR WP_382267974.1 3032283 g273372 i0 88.6 0.96734693877551 79 9 96.7 0 8 244 38 116 WP_382267974.1 replication initiation factor domain-containing protein [Halospeciosus flavus] diamond 237 152 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halospeciosus Halospeciosus flavus
28745766 28745766 PRJNA1160211_S_NODE_12547_length_779_cov_4.957507_g11695_i0 PRJNA1160211 12547 779 4.957507 38.61897953 Methanobacteriota archaeon 2026739 Archaea Archaea 184 8.11e-49   NR MAD56215.1 2026739 g11695 i0 73.2 0.489088575096277 127 33 48.9 1 778 398 895 1020 MAD56215.1 hypothetical protein [Methanobacteriota archaeon] diamond 381 184 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
28935294 28935294 PRJNA1160211_S_NODE_209648_length_300_cov_2.590308_g208415_i0 PRJNA1160211 209648 300 2.590308 7.770924 Methanobacteriota archaeon 2026739 Archaea Archaea 44.3 0.00245   NR MBN74715.1 2026739 g208415 i0 58.8 0.34 34 14 34 0 28 129 36 69 MBN74715.1 hypothetical protein [Methanobacteriota archaeon] diamond 102 44.3 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
30451402 30451402 PRJNA1160211_S_NODE_18893_length_717_cov_15.989130_g17911_i0 PRJNA1160211 18893 717 15.98913 114.6420621 Halosimplex aquaticum 3026162 Archaea Archaea 121 1.83e-27   NR WP_274325319.1 3026162 g17911 i0 30 0.97489539748954 233 152 94.6 2 7 684 259 487 WP_274325319.1 PAS domain-containing sensor histidine kinase [Halosimplex aquaticum] diamond 699 121 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halosimplex Halosimplex aquaticum
31430804 31430804 PRJNA1160211_S_NODE_249136_length_262_cov_6.312169_g247903_i0 PRJNA1160211 249136 262 6.312169 16.53788278 Candidatus Poseidoniia archaeon 2666348 Archaea Archaea 41.6 0.022   NR MDP6275084.1 2666348 g247903 i0 40.4 0.595419847328244 52 26 58.4 2 39 191 4 51 MDP6275084.1 hypothetical protein [Candidatus Poseidoniia archaeon] diamond 156 41.6 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia       Candidatus Poseidoniia archaeon
32190169 32190169 PRJNA1160211_S_NODE_45818_length_590_cov_2.456480_g44662_i0 PRJNA1160211 45818 590 2.45648 14.493232 Methanobacteriota archaeon 2026739 Archaea Archaea 84.7 2.93e-15   NR RMG30411.1 2026739 g44662 i0 35.8 0.823728813559322 162 90 76.8 5 137 589 363 521 RMG30411.1 MAG: hypothetical protein D6732_16280 [Methanobacteriota archaeon] diamond 486 84.7 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
32209463 32209463 PRJNA1160211_S_NODE_126458_length_410_cov_21.916914_g125226_i0 PRJNA1160211 126458 410 21.916914 89.8593474 root 1 Root_unresolved Root_unresolved 130 4.1e-32   NR TLZ55728.1 2026739 g125226 i0 61 3.3 105 40 76.1 1 344 33 58 162 TLZ55728.1 MAG: PKD domain-containing protein [Methanobacteriota archaeon] diamond 1353 130 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);;