RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA896554", tax_kingdom = "Pseudomonadati" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 12 ✖

tax_kingdom 1

  • Pseudomonadati · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA896554 · 12 ✖
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
2144924 2144924 PRJNA896554_P_NODE_108962_length_311_cov_1.915966_g101422_i0 PRJNA896554 108962 311 1.915966 5.95865426 Gemmatimonas phototrophica 1379270 Bacteria Bacteria 54.7 0.008   NTclustered gi|1015602748|gb|CP011454.1| 1379270 g101422 i0 100 0.0932475884244373 29 0 9 0 154 182 550350 550322 Gemmatimonas phototrophica strain AP64, complete genome blastn 29 54.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas phototrophica
5974146 5974146 PRJNA896554_P_NODE_165325_length_245_cov_0.895349_g157785_i0 PRJNA896554 165325 245 0.895349 2.19360505 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 215 2.67e-51   NTclustered gi|2874253978|emb|OY970303.1| 412054 g157785 i0 82.52 4.5469387755102 246 41 100 2 1 245 6075577 6075821 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 1114 215 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
14898863 14898863 PRJNA896554_P_NODE_169212_length_243_cov_1.258824_g161672_i0 PRJNA896554 169212 243 1.258824 3.05894232 Bacteria 2 Bacteria Bacteria 115 1.32e-27   NR MBV9773960.1 2026742 g161672 i0 74.1 3 81 21 100 0 243 1 454 534 MBV9773960.1 copper-translocating P-type ATPase [Gemmatimonadota bacterium] diamond 729 115 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
16174655 16174655 PRJNA896554_P_NODE_64593_length_496_cov_2.475177_g57058_i0 PRJNA896554 64593 496 2.475177 12.27687792 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 361 7.089999999999999e-95   NTclustered gi|2874253755|emb|OY969695.1| 412054 g57058 i0 82.759 204.858870967742 406 68 81 2 91 494 254523 254118 MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 blastn 101610 361 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
27023982 27023982 PRJNA896554_P_NODE_171102_length_242_cov_1.822485_g163562_i0 PRJNA896554 171102 242 1.822485 4.4104137 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 45.4 4.3e-4   NR HXY30292.1 2026741 g163562 i0 70.4 0.334710743801653 27 8 33.5 0 84 4 1 27 HXY30292.1 cation transporter [Gemmatimonadaceae bacterium] diamond 81 45.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27656065 27656065 PRJNA896554_P_NODE_126304_length_281_cov_2.221154_g118764_i0 PRJNA896554 126304 281 2.221154 6.24144274 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 57 5.57e-7   NR HEX6316384.1 2026741 g118764 i0 39.6 0.97153024911032 91 54 96.1 1 5 274 272 362 HEX6316384.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 273 57 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28476847 28476847 PRJNA896554_P_NODE_132866_length_272_cov_1.547739_g125326_i0 PRJNA896554 132866 272 1.547739 4.20985008 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 66.6 2.07e-10   NR HWZ59023.1 2026741 g125326 i0 48.8 0.904411764705882 82 34 90.4 1 270 25 269 342 HWZ59023.1 FUSC family protein [Gemmatimonadaceae bacterium] diamond 246 66.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28547942 28547942 PRJNA896554_P_NODE_138627_length_264_cov_2.277487_g131087_i0 PRJNA896554 138627 264 2.277487 6.01256568 Gemmatimonas 173479 Bacteria Bacteria 126 1.5999999999999999e-31   NR HYW31140.1 1962908 g131087 i0 81.8 2.625 77 14 87.5 0 3 233 561 637 HYW31140.1 glycoside hydrolase family 3 N-terminal domain-containing protein [Gemmatimonas sp.] diamond 693 126 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
28547944 28547944 PRJNA896554_P_NODE_148147_length_253_cov_0.944444_g140607_i0 PRJNA896554 148147 253 0.944444 2.38944332 Pseudomonadati 3379134 Bacteria Bacteria 57 2.41e-7   NR HEX9128783.1 2026741 g140607 i0 61.9 1.43478260869565 42 16 49.8 0 245 120 143 184 HEX9128783.1 invasin domain 3-containing protein [Gemmatimonadaceae bacterium] diamond 363 57 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29684062 29684062 PRJNA896554_P_NODE_157410_length_248_cov_0.880000_g149870_i0 PRJNA896554 157410 248 0.88 2.1824 Pseudomonadati 3379134 Bacteria Bacteria 121 2.06e-30   NR HZK78800.1 2026741 g149870 i0 68.3 6.96774193548387 82 25 98 1 245 3 300 381 HZK78800.1 CRTAC1 family protein [Gemmatimonadaceae bacterium] diamond 1728 122 0.991803278688525 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
30087164 30087164 PRJNA896554_P_NODE_127232_length_280_cov_1.487923_g119692_i0 PRJNA896554 127232 280 1.487923 4.1661844 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 154 4.59e-44   NR HEY9515683.1 2026741 g119692 i0 80.4 0.985714285714286 92 18 98.6 0 3 278 140 231 HEY9515683.1 methyltransferase domain-containing protein [Gemmatimonadaceae bacterium] diamond 276 154 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31477891 31477891 PRJNA896554_P_NODE_118676_length_293_cov_1.590909_g111136_i0 PRJNA896554 118676 293 1.590909 4.66136337 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 49.7 1.08e-4   NR HKG92674.1 2026741 g111136 i0 56 0.511945392491468 50 22 51.2 0 103 252 1 50 HKG92674.1 DUF2975 domain-containing protein [Gemmatimonadaceae bacterium] diamond 150 49.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae 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);;