RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 8 ✖

bioproject 1

  • PRJNA700095 · 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
23636239 23636239 PRJNA700095_P_NODE_60959_length_244_cov_0.900585_g59695_i0 PRJNA700095 60959 244 0.900585 2.1974274 Methanobrevibacter sp. 66852 Archaea Archaea 164 6.869999999999999e-45   NR MDO5821013.1 66852 g59695 i0 100 0.995901639344262 81 0 99.6 0 244 2 542 622 MDO5821013.1 excinuclease ABC subunit UvrA [Methanobrevibacter sp.] diamond 243 164 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
26956044 26956044 PRJNA700095_P_NODE_31982_length_302_cov_1.340611_g30718_i0 PRJNA700095 31982 302 1.340611 4.04864522 Methanosarcinales archaeon 2250255 Archaea Archaea 118 1.38e-28   NR RYE85578.1 2250255 g30718 i0 59.6 1.78807947019868 89 34 87.4 2 281 18 16 103 RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon] diamond 540 118 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
27651534 27651534 PRJNA700095_P_NODE_10504_length_598_cov_2.975238_g9266_i0 PRJNA700095 10504 598 2.975238 17.79192324 Methanobacteriota archaeon 2026739 Archaea Archaea 278 1.48e-83   NR MAD56215.1 2026739 g9266 i0 71.7 0.993311036789298 198 55 99.3 1 596 3 894 1090 MAD56215.1 hypothetical protein [Methanobacteriota archaeon] diamond 594 278 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
28230663 28230663 PRJNA700095_P_NODE_15106_length_476_cov_1.928040_g13845_i0 PRJNA700095 15106 476 1.92804 9.1774704 root 1 Root_unresolved Root_unresolved 157 1.18e-42   NR WP_343775958.1 926360 g13845 i0 54.9 3.5546218487395 153 59 90.1 4 430 2 12 164 WP_343775958.1 CBM35 domain-containing protein [Natronoarchaeum mannanilyticum] diamond 1692 157 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronoarchaeaceae Natronoarchaeum Natronoarchaeum mannanilyticum
28724952 28724952 PRJNA700095_P_NODE_38827_length_279_cov_1.233010_g37563_i0 PRJNA700095 38827 279 1.23301 3.4400979 Thermoplasmatota archaeon 2806419 Archaea Archaea 56.6 2.43e-8   NR MCJ7570643.1 2806419 g37563 i0 88.9 0.290322580645161 27 3 29 0 3 83 40 66 MCJ7570643.1 hypothetical protein [Thermoplasmatota archaeon] diamond 81 56.6 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
28977655 28977655 PRJNA700095_P_NODE_23848_length_354_cov_1.362989_g22584_i0 PRJNA700095 23848 354 1.362989 4.82498106 Methanothrix sp. 90426 Archaea Archaea 42 0.038   NR HPJ30950.1 90426 g22584 i0 38.9 0.610169491525424 72 34 55.1 4 44 238 2 70 HPJ30950.1 hypothetical protein [Methanothrix sp.] diamond 216 42 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
29304379 29304379 PRJNA700095_P_NODE_24749_length_346_cov_1.593407_g23485_i0 PRJNA700095 24749 346 1.593407 5.51318822 root 1 Root_unresolved Root_unresolved 51.6 9.42e-5   NR WP_221170400.1 2862870 g23485 i0 56.1 3.27745664739884 41 18 35.5 0 126 4 170 210 WP_221170400.1 bacterio-opsin activator domain-containing protein [Salinarchaeum sp. IM2453] diamond 1134 51.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronoarchaeaceae Salinarchaeum Salinarchaeum sp. IM2453
32359311 32359311 PRJNA700095_P_NODE_11259_length_574_cov_2.375250_g10017_i0 PRJNA700095 11259 574 2.37525 13.633935 Methanosarcinales archaeon 2250255 Archaea Archaea 207 1.73e-60   NR RYE85578.1 2250255 g10017 i0 51.3 0.998257839721254 191 89 99.3 3 571 2 248 435 RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon] diamond 573 207 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales 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);;