RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB39269" 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 · 8 ✖

bioproject 1

  • PRJEB39269 · 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
26716401 26716401 PRJEB39269_P_NODE_55501_length_185_cov_0.787671_g55096_i0 PRJEB39269 55501 185 0.787671 1.45719135 Methanosarcinales archaeon 2250255 Archaea Archaea 42.7 0.0174   NR RLG35020.1 2250255 g55096 i0 39.6 0.778378378378378 48 28 76.2 1 45 185 512 559 RLG35020.1 MAG: hypothetical protein DRN98_01860 [Methanosarcinales archaeon] diamond 144 42.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
26969936 26969936 PRJEB39269_P_NODE_70942_length_167_cov_1.281250_g70537_i0 PRJEB39269 70942 167 1.28125 2.1396875 Methanomicrobiales archaeon 2184052 Archaea Archaea 42 0.0254   NR HVP25139.1 2184052 g70537 i0 40 0.808383233532934 45 27 80.8 0 159 25 694 738 HVP25139.1 PQQ-dependent sugar dehydrogenase [Methanomicrobiales archaeon] diamond 135 42 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales     Methanomicrobiales archaeon
27159490 27159490 PRJEB39269_P_NODE_80622_length_158_cov_2.579832_g80217_i0 PRJEB39269 80622 158 2.579832 4.07613456 Haloferacaceae archaeon 2080321 Archaea Archaea 55.1 3.56e-8   NR MFB6154539.1 2080321 g80217 i0 100 0.512658227848101 27 0 51.3 0 81 1 2 28 MFB6154539.1 chorismate mutase [Haloferacaceae archaeon] diamond 81 55.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae   Haloferacaceae archaeon
29401765 29401765 PRJEB39269_P_NODE_83169_length_156_cov_2.435897_g82764_i0 PRJEB39269 83169 156 2.435897 3.79999932 Salinirubrum litoreum 1126234 Archaea Archaea 51.6 7.85e-6   NR WP_227230988.1 1126234 g82764 i0 78.6 0.538461538461538 28 6 53.8 0 85 2 56 83 WP_227230988.1 ABC transporter permease [Salinirubrum litoreum] diamond 84 51.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Salinirubrum Salinirubrum litoreum
29970145 29970145 PRJEB39269_P_NODE_91511_length_150_cov_1.396396_g91106_i0 PRJEB39269 91511 150 1.396396 2.094594 Natronorubrum daqingense 588898 Archaea Archaea 50.8 7.26e-6   NR WP_076584130.1 588898 g91106 i0 52.2 1.7 46 22 92 0 150 13 113 158 WP_076584130.1 hypothetical protein [Natronorubrum daqingense] diamond 255 50.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronorubrum Natronorubrum daqingense
30216196 30216196 PRJEB39269_P_NODE_67352_length_170_cov_2.595420_g66947_i0 PRJEB39269 67352 170 2.59542 4.412214 Natrialbaceae 1644061 Archaea Archaea 48.9 9.15e-5   NR WP_228442368.1 2044521 g66947 i0 84.6 1.81764705882353 26 4 45.9 0 92 169 349 374 WP_228442368.1 MFS transporter [Natrarchaeobaculum sulfurireducens] diamond 309 48.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natrarchaeobaculum Natrarchaeobaculum sulfurireducens
30791621 30791621 PRJEB39269_P_NODE_90674_length_150_cov_3.468468_g90269_i0 PRJEB39269 90674 150 3.468468 5.202702 Halobacteriales archaeon SW_9_67_25 1919210 Archaea Archaea 105 8.45e-25   NR PSQ58695.1 1919210 g90269 i0 90 3 50 5 100 0 1 150 292 341 PSQ58695.1 MAG: molybdopterin-binding oxidoreductase [Halobacteriales archaeon SW_9_67_25] diamond 450 105 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales     Halobacteriales archaeon SW_9_67_25
31360675 31360675 PRJEB39269_P_NODE_88376_length_152_cov_1.619469_g87971_i0 PRJEB39269 88376 152 1.619469 2.46159288 Natronomonas sp. 2184060 Archaea Archaea 73.6 6.34e-14   NR WP_410321558.1 2184060 g87971 i0 80.5 2.42763157894737 41 8 80.9 0 1 123 64 104 WP_410321558.1 alpha/beta fold hydrolase [Natronomonas sp.] diamond 369 73.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp.

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