RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA640143" and tax_phylum = "Abditibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Abditibacteriota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA640143 · 16 ✖

analysis 1

  • diamond · 16 ✖

tax_clade 0

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
26764476 26764476 PRJNA640143_S_NODE_31881_length_153_cov_0.939655_g31671_i0 PRJNA640143 31881 153 0.939655 1.43767215 Abditibacteriaceae bacterium 2800791 Bacteria Bacteria 67.4 1.69e-11   NR HEX8237986.1 2800791 g31671 i0 64.6 0.941176470588235 48 17 94.1 0 3 146 57 104 HEX8237986.1 WYL domain-containing protein [Abditibacteriaceae bacterium] diamond 144 67.4 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae   Abditibacteriaceae bacterium
27143808 27143808 PRJNA640143_S_NODE_19482_length_199_cov_1.185185_g19272_i0 PRJNA640143 19482 199 1.185185 2.35851815 Abditibacterium utsteinense 1960156 Bacteria Bacteria 134 1.15e-35   NR WP_105483003.1 1960156 g19272 i0 86.4 0.994974874371859 66 9 99.5 0 198 1 126 191 WP_105483003.1 hypothetical protein [Abditibacterium utsteinense] diamond 198 134 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae Abditibacterium Abditibacterium utsteinense
27428918 27428918 PRJNA640143_S_NODE_30063_length_158_cov_1.611570_g29853_i0 PRJNA640143 30063 158 1.61157 2.5462806 Abditibacterium sp. 2109264 Bacteria Bacteria 89.4 8.85e-21   NR HEX9995928.1 2109264 g29853 i0 89.4 0.892405063291139 47 5 89.2 0 146 6 14 60 HEX9995928.1 AtpZ/AtpI family protein [Abditibacterium sp.] diamond 141 89.4 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae Abditibacterium Abditibacterium sp.
28091674 28091674 PRJNA640143_S_NODE_29585_length_160_cov_0.951220_g29375_i0 PRJNA640143 29585 160 0.95122 1.521952 Abditibacteriota bacterium 2783868 Bacteria Bacteria 89.7 1.47e-19   NR BCM93668.1 2783868 g29375 i0 84.6 2.94375 52 8 97.5 0 159 4 55 106 BCM93668.1 ribose operon repressor [Abditibacteriota bacterium] diamond 471 89.7 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
28155075 28155075 PRJNA640143_S_NODE_9285_length_281_cov_1.680328_g9075_i0 PRJNA640143 9285 281 1.680328 4.72172168 Abditibacterium utsteinense 1960156 Bacteria Bacteria 54.3 1.76e-6   NR WP_105483738.1 1960156 g9075 i0 100 0.288256227758007 27 0 28.8 0 281 201 150 176 WP_105483738.1 50S ribosomal protein L10 [Abditibacterium utsteinense] diamond 81 54.3 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae Abditibacterium Abditibacterium utsteinense
28217738 28217738 PRJNA640143_S_NODE_13986_length_233_cov_1.392857_g13776_i0 PRJNA640143 13986 233 1.392857 3.24535681 Abditibacterium utsteinense 1960156 Bacteria Bacteria 129 2.5399999999999997e-35   NR WP_105483776.1 1960156 g13776 i0 85.3 0.965665236051502 75 11 96.6 0 233 9 118 192 WP_105483776.1 fructose-6-phosphate aldolase [Abditibacterium utsteinense] diamond 225 129 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae Abditibacterium Abditibacterium utsteinense
28880955 28880955 PRJNA640143_S_NODE_29188_length_161_cov_1.508065_g28978_i0 PRJNA640143 29188 161 1.508065 2.42798465 Abditibacteriaceae bacterium 2800791 Bacteria Bacteria 59.3 2.23e-9   NR MBV9470937.1 2800791 g28978 i0 88.5 0.484472049689441 26 3 48.4 0 2 79 108 133 MBV9470937.1 YjbQ family protein [Abditibacteriaceae bacterium] diamond 78 59.3 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae   Abditibacteriaceae bacterium
29259742 29259742 PRJNA640143_S_NODE_27829_length_166_cov_0.906977_g27619_i0 PRJNA640143 27829 166 0.906977 1.50558182 Abditibacterium utsteinense 1960156 Bacteria Bacteria 77 9.39e-15   NR WP_202973524.1 1960156 g27619 i0 86.8 0.686746987951807 38 5 68.7 0 141 28 369 406 WP_202973524.1 spore photoproduct lyase family protein [Abditibacterium utsteinense] diamond 114 77 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae Abditibacterium Abditibacterium utsteinense
29701621 29701621 PRJNA640143_S_NODE_27310_length_168_cov_1.190840_g27100_i0 PRJNA640143 27310 168 1.19084 2.0006112 Abditibacteriota bacterium 2783868 Bacteria Bacteria 92 4.78e-21   NR MDF2439275.1 2783868 g27100 i0 75.9 0.964285714285714 54 13 96.4 0 164 3 180 233 MDF2439275.1 UDP-N-acetylglucosamine--N-acetylmuramyl-(pentapeptide) pyrophosphoryl-undecaprenol [Abditibacteriota bacterium] diamond 162 92 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
29796571 29796571 PRJNA640143_S_NODE_32211_length_152_cov_1.017391_g32001_i0 PRJNA640143 32211 152 1.017391 1.54643432 Abditibacteriaceae bacterium 2800791 Bacteria Bacteria 80.5 1.68e-16   NR HEX8552559.1 2800791 g32001 i0 82 1.97368421052632 50 9 98.7 0 3 152 119 168 HEX8552559.1 bifunctional DNA-formamidopyrimidine glycosylase/DNA-(apurinic or apyrimidinic site) lyase [Abditibacteriaceae bacterium] diamond 300 80.5 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae   Abditibacteriaceae bacterium
30649490 30649490 PRJNA640143_S_NODE_29433_length_160_cov_1.626016_g29223_i0 PRJNA640143 29433 160 1.626016 2.6016256 Abditibacterium utsteinense 1960156 Bacteria Bacteria 53.1 2.21e-6   NR WP_157947675.1 1960156 g29223 i0 57.1 1.575 42 17 78.8 1 158 33 131 171 WP_157947675.1 hypothetical protein [Abditibacterium utsteinense] diamond 252 53.1 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae Abditibacterium Abditibacterium utsteinense
31029107 31029107 PRJNA640143_S_NODE_26255_length_172_cov_1.474074_g26045_i0 PRJNA640143 26255 172 1.474074 2.53540728 Abditibacterium sp. 2109264 Bacteria Bacteria 62 9.35e-10   NR HEX8465309.1 2109264 g26045 i0 50 1.04651162790698 60 27 99.4 1 1 171 30 89 HEX8465309.1 hypothetical protein [Abditibacterium sp.] diamond 180 62 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae Abditibacterium Abditibacterium sp.
31250014 31250014 PRJNA640143_S_NODE_15295_length_223_cov_1.913978_g15085_i0 PRJNA640143 15295 223 1.913978 4.26817094 Abditibacteriaceae bacterium 2800791 Bacteria Bacteria 107 5.01e-25   NR HEX8551834.1 2800791 g15085 i0 86.9 0.820627802690583 61 8 82.1 0 222 40 286 346 HEX8551834.1 endopeptidase La [Abditibacteriaceae bacterium] diamond 183 107 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae   Abditibacteriaceae bacterium
31439789 31439789 PRJNA640143_S_NODE_23236_length_183_cov_1.335616_g23026_i0 PRJNA640143 23236 183 1.335616 2.44417728 Abditibacteriota bacterium 2783868 Bacteria Bacteria 97.8 1.0499999999999999e-23   NR MDF2439475.1 2783868 g23026 i0 78.3 1.9672131147541 60 13 98.4 0 3 182 106 165 MDF2439475.1 large subunit ribosomal protein [Abditibacteriota bacterium] diamond 360 97.8 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
32420666 32420666 PRJNA640143_S_NODE_29159_length_161_cov_1.572581_g28949_i0 PRJNA640143 29159 161 1.572581 2.53185541 Abditibacteriaceae bacterium 2800791 Bacteria Bacteria 49.7 4.36e-5   NR HEY0075897.1 2800791 g28949 i0 43.4 0.987577639751553 53 29 98.8 1 161 3 757 808 HEY0075897.1 tetratricopeptide repeat protein [Abditibacteriaceae bacterium] diamond 159 49.7 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae   Abditibacteriaceae bacterium
32641445 32641445 PRJNA640143_S_NODE_31720_length_153_cov_1.551724_g31510_i0 PRJNA640143 31720 153 1.551724 2.37413772 Abditibacteriaceae bacterium 2800791 Bacteria Bacteria 87.4 2.01e-18   NR HEX8551219.1 2800791 g31510 i0 88.2 1 51 6 100 0 153 1 581 631 HEX8551219.1 hybrid sensor histidine kinase/response regulator [Abditibacteriaceae bacterium] diamond 153 87.4 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae   Abditibacteriaceae bacterium

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