RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1002570" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 7 ✖

bioproject 1

  • PRJNA1002570 · 7 ✖

analysis 1

  • diamond · 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
2702569 2702569 PRJNA1002570_P_NODE_28343_length_271_cov_2.742424_g28148_i0 PRJNA1002570 28343 271 2.742424 7.43196904 Methanocella sp. 2052833 Archaea Archaea 67 1.54e-10   NR HMK45342.1 2052833 g28148 i0 39.3 0.985239852398524 89 53 98.5 1 2 268 528 615 HMK45342.1 hypothetical protein [Methanocella sp.] diamond 267 67 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanocellales Methanocellaceae Methanocella Methanocella sp.
27128762 27128762 PRJNA1002570_P_NODE_11102_length_354_cov_3.032028_g10907_i0 PRJNA1002570 11102 354 3.032028 10.73337912 Candidatus Methanoperedens sp. 2032688 Archaea Archaea 66.2 7.33e-10   NR HEY9247135.1 2032688 g10907 i0 36.2 2.66101694915254 116 73 97.5 1 5 349 91 206 HEY9247135.1 PAS domain-containing protein [Candidatus Methanoperedens sp.] diamond 942 66.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Candidatus Methanoperedentaceae Candidatus Methanoperedens Candidatus Methanoperedens sp.
27160578 27160578 PRJNA1002570_P_NODE_8862_length_385_cov_2.416667_g8667_i0 PRJNA1002570 8862 385 2.416667 9.30416795 Methanothrix soehngenii 2223 Archaea Archaea 115 1.0600000000000002e-27   NR WP_342474883.1 2223 g8667 i0 58.5 1.78441558441558 106 42 81 1 384 73 290 395 WP_342474883.1 restriction endonuclease subunit S, partial [Methanothrix soehngenii] diamond 687 115 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii
28385020 28385020 PRJNA1002570_P_NODE_12226_length_341_cov_1.436567_g12031_i0 PRJNA1002570 12226 341 1.436567 4.89869347 root 1 Root_unresolved Root_unresolved 166 2.6099999999999997e-47   NR WP_206539401.1 1550566 g12031 i0 75.5 10.574780058651 106 26 93.3 0 336 19 72 177 WP_206539401.1 class I SAM-dependent methyltransferase [Methanoculleus sediminis] diamond 3606 166 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sediminis
29813195 29813195 PRJNA1002570_P_NODE_3351_length_585_cov_2.648438_g3160_i0 PRJNA1002570 3351 585 2.648438 15.4933623 Haloparvum sedimenti 1678448 Archaea Archaea 170 1.38e-50   NR WP_080508407.1 1678448 g3160 i0 54.3 0.707692307692308 138 57 70.8 1 56 469 11 142 WP_080508407.1 CHY zinc finger protein [Haloparvum sedimenti] diamond 414 170 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloparvum Haloparvum sedimenti
31290781 31290781 PRJNA1002570_P_NODE_16495_length_309_cov_1.216102_g16300_i0 PRJNA1002570 16495 309 1.216102 3.75775518 root 1 Root_unresolved Root_unresolved 129 3.27e-33   NR WP_342474883.1 2223 g16300 i0 58.4 4.80582524271845 101 42 98.1 0 7 309 220 320 WP_342474883.1 restriction endonuclease subunit S, partial [Methanothrix soehngenii] diamond 1485 129 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii
32532324 32532324 PRJNA1002570_P_NODE_11099_length_354_cov_3.313167_g10904_i0 PRJNA1002570 11099 354 3.313167 11.72861118 Candidatus Methanofastidiosum methylothiophilum 1705564 Archaea Archaea 66.2 3.89e-11   NR KYC52810.1 1705564 g10904 i0 59.6 0.398305084745763 47 19 39.8 0 4 144 78 124 KYC52810.1 MAG: hypothetical protein AMQ22_00601 [Candidatus Methanofastidiosum methylothiophilum] diamond 141 66.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia Candidatus Methanofastidiosales Candidatus Methanofastidiosaceae Candidatus Methanofastidiosum Candidatus Methanofastidiosum methylothiophilum

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