RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA1247234", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 16 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 16 ✖

bioproject 1

  • PRJNA1247234 · 16 ✖
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
10555657 10555657 PRJNA1247234_P_NODE_28009_length_242_cov_0.923077_g27853_i0 PRJNA1247234 28009 242 0.923077 2.23384634 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 169 2.07e-37   NTclustered gi|2874254163|emb|OY970395.1| 412054 g27853 i0 83.708 0.735537190082645 178 29 74 0 47 224 1435559 1435382 MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1 blastn 178 169 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
11830067 11830067 PRJNA1247234_P_NODE_22610_length_250_cov_0.881356_g22454_i0 PRJNA1247234 22610 250 0.881356 2.20339 Longimicrobiales bacterium 2910168 Bacteria Bacteria 143 5.81e-39   NR HEU5209272.1 2910168 g22454 i0 90.4 1.992 83 8 99.6 0 249 1 297 379 HEU5209272.1 P1 family peptidase [Longimicrobiales bacterium] diamond 498 143 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
11830110 11830110 PRJNA1247234_P_NODE_24370_length_247_cov_0.896552_g24214_i0 PRJNA1247234 24370 247 0.896552 2.21448344 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 255 1.59e-63   NTclustered gi|2874253728|emb|OY969570.1| 412054 g24214 i0 85.597 5.54655870445344 243 35 98 0 5 247 1742188 1742430 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 1370 255 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
14380472 14380472 PRJNA1247234_P_NODE_15932_length_283_cov_1.114286_g15776_i0 PRJNA1247234 15932 283 1.114286 3.15342938 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 368 2.28e-97   NTclustered gi|2874254107|emb|OY970192.1| 412054 g15776 i0 90.141 99.0388692579505 284 26 100 2 1 283 4301894 4302176 MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 blastn 28028 368 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
15654401 15654401 PRJNA1247234_P_NODE_19353_length_258_cov_0.875676_g19197_i0 PRJNA1247234 19353 258 0.875676 2.25924408 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 366 7.38e-97   NTclustered gi|2874253978|emb|OY970303.1| 412054 g19197 i0 93.173 32.7209302325581 249 17 100 0 1 249 1903236 1903484 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 8442 366 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
19477506 19477506 PRJNA1247234_P_NODE_20396_length_253_cov_0.866667_g20240_i0 PRJNA1247234 20396 253 0.866667 2.19266751 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 127 9.619999999999999e-32   NR RMH16308.1 2026742 g20240 i0 73.8 0.99604743083004 84 22 99.6 0 2 253 407 490 RMH16308.1 MAG: response regulator [Gemmatimonadota bacterium] diamond 252 127 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
19477516 19477516 PRJNA1247234_P_NODE_21076_length_252_cov_0.871508_g20920_i0 PRJNA1247234 21076 252 0.871508 2.19620016 Gaopeijia maritima 3119007 Bacteria Bacteria 180 1e-40   NTclustered gi|2716997671|gb|CP144380.1| 3119007 g20920 i0 84.239 0.73015873015873 184 29 73 0 69 252 4067285 4067102 Gaopeijia maritima strain DH-78 chromosome, complete genome blastn 184 180 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Gaopeijiales Gaopeijiaceae Gaopeijia Gaopeijia maritima
20753049 20753049 PRJNA1247234_P_NODE_27057_length_243_cov_0.917647_g26901_i0 PRJNA1247234 27057 243 0.917647 2.22988221 Longimicrobiales bacterium 2910168 Bacteria Bacteria 149 3.31e-42   NR HEU5210923.1 2910168 g26901 i0 92.6 1.98765432098765 81 5 98.8 1 241 2 37 117 HEU5210923.1 TIGR00730 family Rossman fold protein [Longimicrobiales bacterium] diamond 483 149 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
24577847 24577847 PRJNA1247234_P_NODE_25800_length_245_cov_0.906977_g25644_i0 PRJNA1247234 25800 245 0.906977 2.22209365 Longimicrobiales bacterium 2910168 Bacteria Bacteria 163 3.45e-45   NR HEU5209774.1 2910168 g25644 i0 92.6 0.991836734693878 81 6 99.2 0 245 3 210 290 HEU5209774.1 acetate--CoA ligase [Longimicrobiales bacterium] diamond 243 163 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
26598470 26598470 PRJNA1247234_P_NODE_21721_length_251_cov_0.876404_g21565_i0 PRJNA1247234 21721 251 0.876404 2.19977404 Longimicrobiales bacterium 2910168 Bacteria Bacteria 56.2 1.29e-7   NR HEU5209398.1 2910168 g21565 i0 82.4 0.406374501992032 34 6 40.6 0 149 250 1 34 HEU5209398.1 response regulator [Longimicrobiales bacterium] diamond 102 56.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
28273606 28273606 PRJNA1247234_P_NODE_23826_length_248_cov_0.891429_g23670_i0 PRJNA1247234 23826 248 0.891429 2.21074392 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 162 2.1e-46   NR MBE0591343.1 2448054 g23670 i0 100 0.991935483870968 82 0 99.2 0 246 1 264 345 MBE0591343.1 fatty acid desaturase [Gemmatimonadales bacterium] diamond 246 162 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29631110 29631110 PRJNA1247234_P_NODE_21130_length_252_cov_0.871508_g20974_i0 PRJNA1247234 21130 252 0.871508 2.19620016 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 120 5.6899999999999995e-30   NR NNK62657.1 2026742 g20974 i0 71.6 2.85714285714286 81 23 96.4 0 251 9 148 228 NNK62657.1 insulinase family protein [Gemmatimonadota bacterium] diamond 720 120 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32065034 32065034 PRJNA1247234_P_NODE_25618_length_245_cov_0.906977_g25462_i0 PRJNA1247234 25618 245 0.906977 2.22209365 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 112 4.95e-29   NR NJD19204.1 2026742 g25462 i0 70 2.93877551020408 80 24 98 0 1 240 77 156 NJD19204.1 sodium-independent anion transporter [Gemmatimonadota bacterium] diamond 720 112 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32350047 32350047 PRJNA1247234_P_NODE_23779_length_248_cov_0.891429_g23623_i0 PRJNA1247234 23779 248 0.891429 2.21074392 Longimicrobiales bacterium 2910168 Bacteria Bacteria 124 1.9799999999999996e-31   NR HEU5210464.1 2910168 g23623 i0 89.6 0.810483870967742 67 7 81 0 248 48 431 497 HEU5210464.1 UDP-N-acetylmuramoyl-tripeptide--D-alanyl-D-alanine ligase [Longimicrobiales bacterium] diamond 201 124 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
32697132 32697132 PRJNA1247234_P_NODE_22160_length_250_cov_0.881356_g22004_i0 PRJNA1247234 22160 250 0.881356 2.20339 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 78.6 1.02e-14   NR MBT4188854.1 2448054 g22004 i0 50.6 0.924 77 38 92.4 0 20 250 882 958 MBT4188854.1 NgoFVII family restriction endonuclease [Gemmatimonadales bacterium] diamond 231 78.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32791530 32791530 PRJNA1247234_P_NODE_23800_length_248_cov_0.891429_g23644_i0 PRJNA1247234 23800 248 0.891429 2.21074392 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 98.6 8.86e-22   NR MFC1575951.1 2026742 g23644 i0 60 1.94758064516129 80 31 96.8 1 4 243 187 265 MFC1575951.1 ATP-binding protein [Gemmatimonadota bacterium] diamond 483 98.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota 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);;