RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA1108009", tax_phylum = "Elusimicrobiota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 16 ✖

tax_phylum 1

  • Elusimicrobiota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1108009 · 16 ✖

analysis 1

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
6591006 6591006 PRJNA1108009_P_NODE_19746_length_289_cov_1.694444_g19428_i0 PRJNA1108009 19746 289 1.694444 4.89694316 Candidatus Avelusimicrobium gallicola 2562704 Bacteria Bacteria 132 1.7299999999999999e-34   NR MBE6421551.1 2562704 g19428 i0 95.3 0.664359861591695 64 3 66.4 0 98 289 328 391 MBE6421551.1 terminase [Elusimicrobium sp.] diamond 192 132 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae Candidatus Avelusimicrobium Candidatus Avelusimicrobium gallicola
26687830 26687830 PRJNA1108009_P_NODE_25881_length_249_cov_1.721591_g25563_i0 PRJNA1108009 25881 249 1.721591 4.28676159 Candidatus Avelusimicrobium gallicola 2562704 Bacteria Bacteria 120 1.15e-31   NR MBE6421051.1 2562704 g25563 i0 98.3 0.698795180722892 58 1 69.9 0 2 175 185 242 MBE6421051.1 tRNA lysidine(34) synthetase TilS [Elusimicrobium sp.] diamond 174 120 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae Candidatus Avelusimicrobium Candidatus Avelusimicrobium gallicola
26846456 26846456 PRJNA1108009_P_NODE_26181_length_249_cov_0.875000_g25863_i0 PRJNA1108009 26181 249 0.875 2.17875 Elusimicrobiaceae bacterium 2735568 Bacteria Bacteria 157 2.83e-46   NR MBQ9970574.1 2735568 g25863 i0 98.8 1.97590361445783 82 1 98.8 0 2 247 51 132 MBQ9970574.1 hypothetical protein [Elusimicrobiaceae bacterium] diamond 492 157 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae   Elusimicrobiaceae bacterium
27257362 27257362 PRJNA1108009_P_NODE_31163_length_242_cov_0.911243_g30845_i0 PRJNA1108009 31163 242 0.911243 2.20520806 Candidatus Avelusimicrobium gallicola 2562704 Bacteria Bacteria 155 6.6599999999999986e-43   NR MBE6421594.1 2562704 g30845 i0 97.5 0.991735537190083 80 2 99.2 0 2 241 415 494 MBE6421594.1 hypothetical protein [Elusimicrobium sp.] diamond 240 155 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae Candidatus Avelusimicrobium Candidatus Avelusimicrobium gallicola
28583758 28583758 PRJNA1108009_P_NODE_25747_length_250_cov_0.870056_g25429_i0 PRJNA1108009 25747 250 0.870056 2.17514 Candidatus Avelusimicrobium gallicola 2562704 Bacteria Bacteria 153 2.1399999999999993e-43   NR MBE6421576.1 2562704 g25429 i0 98.8 0.996 83 1 99.6 0 249 1 51 133 MBE6421576.1 protein translocase subunit SecF [Elusimicrobium sp.] diamond 249 153 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae Candidatus Avelusimicrobium Candidatus Avelusimicrobium gallicola
28615257 28615257 PRJNA1108009_P_NODE_22807_length_265_cov_1.270833_g22489_i0 PRJNA1108009 22807 265 1.270833 3.36770745 Candidatus Avelusimicrobium gallicola 2562704 Bacteria Bacteria 106 2.3e-26   NR MBE6421521.1 2562704 g22489 i0 98 0.577358490566038 51 1 57.7 0 111 263 1 51 MBE6421521.1 CYTH domain-containing protein [Elusimicrobium sp.] diamond 153 106 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae Candidatus Avelusimicrobium Candidatus Avelusimicrobium gallicola
29057331 29057331 PRJNA1108009_P_NODE_30828_length_242_cov_0.911243_g30510_i0 PRJNA1108009 30828 242 0.911243 2.20520806 Elusimicrobiaceae bacterium 2735568 Bacteria Bacteria 140 3.52e-41   NR MBQ9970828.1 2735568 g30510 i0 100 0.979338842975207 79 0 97.9 0 239 3 1 79 MBQ9970828.1 hypothetical protein [Elusimicrobiaceae bacterium] diamond 237 140 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae   Elusimicrobiaceae bacterium
29395851 29395851 PRJNA1108009_P_NODE_27569_length_247_cov_0.885057_g27251_i0 PRJNA1108009 27569 247 0.885057 2.18609079 Bacteria 2 Bacteria Bacteria 161 6.91e-44   NR MDD6152556.1 2030800 g27251 i0 98.8 3.93522267206478 81 1 98.4 0 245 3 427 507 MDD6152556.1 ATPase, T2SS/T4P/T4SS family [Elusimicrobiota bacterium] diamond 972 161 1 Bacteria   Pseudomonadati Elusimicrobiota         Elusimicrobiota bacterium
29530888 29530888 PRJNA1108009_P_NODE_29470_length_244_cov_0.900585_g29152_i0 PRJNA1108009 29470 244 0.900585 2.1974274 Elusimicrobiaceae bacterium 2735568 Bacteria Bacteria 149 4.279999999999999e-41   NR MBQ9971389.1 2735568 g29152 i0 98.8 0.995901639344262 81 1 99.6 0 1 243 343 423 MBQ9971389.1 efflux RND transporter periplasmic adaptor subunit [Elusimicrobiaceae bacterium] diamond 243 149 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae   Elusimicrobiaceae bacterium
29972931 29972931 PRJNA1108009_P_NODE_31191_length_242_cov_0.911243_g30873_i0 PRJNA1108009 31191 242 0.911243 2.20520806 Elusimicrobium sp. An273 2562704 Bacteria Bacteria 137 2.19e-36   NR WP_087289189.1 1965617 g30873 i0 81.3 0.991735537190083 80 15 99.2 0 1 240 309 388 WP_087289189.1 NADPH-dependent glutamate synthase [Elusimicrobium sp. An273] diamond 240 137 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae Elusimicrobium Elusimicrobium sp. An273
30162272 30162272 PRJNA1108009_P_NODE_27392_length_247_cov_0.885057_g27074_i0 PRJNA1108009 27392 247 0.885057 2.18609079 Elusimicrobiaceae bacterium 2735568 Bacteria Bacteria 148 1.1e-40   NR MBQ9971471.1 2735568 g27074 i0 97.6 0.995951417004049 82 2 99.6 0 246 1 66 147 MBQ9971471.1 trypsin-like peptidase domain-containing protein [Elusimicrobiaceae bacterium] diamond 246 148 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae   Elusimicrobiaceae bacterium
30193964 30193964 PRJNA1108009_P_NODE_26052_length_249_cov_0.875000_g25734_i0 PRJNA1108009 26052 249 0.875 2.17875 Elusimicrobiota bacterium 2030800 Bacteria Bacteria 57.8 1.78e-7   NR MFA5975716.1 2030800 g25734 i0 40 1.97590361445783 80 46 94 1 235 2 239 318 MFA5975716.1 zinc-binding dehydrogenase [Elusimicrobiota bacterium] diamond 492 57.8 1 Bacteria   Pseudomonadati Elusimicrobiota         Elusimicrobiota bacterium
30447027 30447027 PRJNA1108009_P_NODE_11153_length_401_cov_2.396341_g10835_i0 PRJNA1108009 11153 401 2.396341 9.60932741 Elusimicrobiaceae bacterium 2735568 Bacteria Bacteria 44.7 0.0403   NR MBP3513593.1 2735568 g10835 i0 34.2 0.56857855361596 76 50 56.9 0 60 287 120 195 MBP3513593.1 hypothetical protein [Elusimicrobiaceae bacterium] diamond 228 44.7 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae   Elusimicrobiaceae bacterium
30762904 30762904 PRJNA1108009_P_NODE_23914_length_256_cov_1.306011_g23596_i0 PRJNA1108009 23914 256 1.306011 3.34338816 Elusimicrobiaceae bacterium 2735568 Bacteria Bacteria 149 1.8499999999999993e-43   NR MCQ2409983.1 2735568 g23596 i0 86.9 0.984375 84 11 98.4 0 3 254 106 189 MCQ2409983.1 MBL fold metallo-hydrolase [Elusimicrobiaceae bacterium] diamond 252 149 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae   Elusimicrobiaceae bacterium
31047468 31047468 PRJNA1108009_P_NODE_29035_length_245_cov_0.895349_g28717_i0 PRJNA1108009 29035 245 0.895349 2.19360505 Elusimicrobiaceae bacterium 2735568 Bacteria Bacteria 159 1.08e-43   NR MBQ9971171.1 2735568 g28717 i0 100 4.91020408163265 81 0 99.2 0 244 2 75 155 MBQ9971171.1 DNA polymerase III subunit gamma/tau [Elusimicrobiaceae bacterium] diamond 1203 159 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae   Elusimicrobiaceae bacterium
32597093 32597093 PRJNA1108009_P_NODE_28040_length_246_cov_0.890173_g27722_i0 PRJNA1108009 28040 246 0.890173 2.18982558 Elusimicrobiaceae bacterium 2735568 Bacteria Bacteria 147 5.45e-40   NR MBR2865457.1 2735568 g27722 i0 86.4 0.98780487804878 81 11 98.8 0 245 3 281 361 MBR2865457.1 YfcC family protein [Elusimicrobiaceae bacterium] diamond 243 147 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae   Elusimicrobiaceae 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);;