RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA559720" and tax_clade = "FCB group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • FCB group · 23 ✖

bioproject 1

  • PRJNA559720 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
543486 543486 PRJNA559720_P_NODE_16301_length_241_cov_0.916667_g16162_i0 PRJNA559720 16301 241 0.916667 2.20916747 Bacteria 2 Bacteria Bacteria 144 3.77e-39   NR HWC53233.1 1869212 g16162 i0 72.5 9.93360995850622 80 22 99.6 0 1 240 39 118 HWC53233.1 hypothetical protein [Chitinophagaceae bacterium] diamond 2394 144 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
15846306 15846306 PRJNA559720_P_NODE_13913_length_250_cov_0.870056_g13774_i0 PRJNA559720 13913 250 0.870056 2.17514 Bacteroidota 976 Bacteria Bacteria 113 1.32e-27   NR SDB60874.1 1250295 g13774 i0 64.2 9.624 81 29 97.2 0 3 245 23 103 SDB60874.1 2-amino-3-ketobutyrate coenzyme A ligase [Flavobacteriaceae bacterium MAR_2010_188] diamond 2406 113 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium MAR_2010_188
26730368 26730368 PRJNA559720_P_NODE_13661_length_251_cov_0.865169_g13522_i0 PRJNA559720 13661 251 0.865169 2.17157419 Bacteroidetes/Chlorobi group bacterium Naka2 2382227 Bacteria Bacteria 112 1.17e-28   NR ROL58632.1 2382229 g13522 i0 67.1 4.94820717131474 82 27 98 0 6 251 43 124 ROL58632.1 MAG: pyridoxamine 5'-phosphate oxidase [Bacteroidetes/Chlorobi group bacterium Naka2016] diamond 1242 112 1 Bacteria FCB group Pseudomonadati           Bacteroidetes/Chlorobi group bacterium Naka2016
26952245 26952245 PRJNA559720_P_NODE_15242_length_245_cov_0.895349_g15103_i0 PRJNA559720 15242 245 0.895349 2.19360505 Prevotella amnii 419005 Bacteria Bacteria 155 1.29e-44   NR WP_008450324.1 419005 g15103 i0 100 0.991836734693878 81 0 99.2 0 1 243 33 113 WP_008450324.1 RluA family pseudouridine synthase [Prevotella amnii] diamond 243 155 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella amnii
27332000 27332000 PRJNA559720_P_NODE_14603_length_247_cov_1.367816_g14464_i0 PRJNA559720 14603 247 1.367816 3.37850552 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 162 4.6500000000000004e-49   NR MCA6447593.1 1869212 g14464 i0 97.6 0.995951417004049 82 2 99.6 0 247 2 44 125 MCA6447593.1 ATP-binding protein [Chitinophagaceae bacterium] diamond 246 162 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
27395224 27395224 PRJNA559720_P_NODE_14863_length_246_cov_1.710983_g14724_i0 PRJNA559720 14863 246 1.710983 4.20901818 Catalinimonas sp. 4WD22 3133978 Bacteria Bacteria 114 9.65e-28   NR WP_341296555.1 3133978 g14724 i0 65.4 0.951219512195122 78 27 95.1 0 5 238 350 427 WP_341296555.1 aminotransferase class V-fold PLP-dependent enzyme [Catalinimonas sp. 4WD22] diamond 234 114 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Catalimonadaceae Catalinimonas Catalinimonas locisalis
27900049 27900049 PRJNA559720_P_NODE_8925_length_331_cov_1.476744_g8786_i0 PRJNA559720 8925 331 1.476744 4.88802264 Psychroserpens luteus 1434066 Bacteria Bacteria 43.9 0.0385   NR WP_194506124.1 1434066 g8786 i0 29.3 0.897280966767372 99 59 79.8 3 283 20 205 303 WP_194506124.1 hypothetical protein [Psychroserpens luteus] diamond 297 43.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Psychroserpens Psychroserpens luteus
28261349 28261349 PRJNA559720_P_NODE_13906_length_250_cov_0.870056_g13767_i0 PRJNA559720 13906 250 0.870056 2.17514 Cytophagales 768507 Bacteria Bacteria 156 3.1799999999999992e-43   NR MDZ4715964.1 2053541 g13767 i0 91.6 12.948 83 7 99.6 0 1 249 322 404 MDZ4715964.1 GH3 auxin-responsive promoter family protein [Cytophagales bacterium] diamond 3237 157 0.993630573248408 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales     Cytophagales bacterium
28500239 28500239 PRJNA559720_P_NODE_9607_length_316_cov_3.798354_g9468_i0 PRJNA559720 9607 316 3.798354 12.00279864 Algoriphagus ornithinivorans 226506 Bacteria Bacteria 45.8 0.00681   NR WP_091654510.1 226506 g9468 i0 29.2 0.683544303797468 72 51 68.4 0 270 55 52 123 WP_091654510.1 acyltransferase family protein [Algoriphagus ornithinivorans] diamond 216 45.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cyclobacteriaceae Algoriphagus Algoriphagus ornithinivorans
28594986 28594986 PRJNA559720_P_NODE_14827_length_247_cov_0.885057_g14688_i0 PRJNA559720 14827 247 0.885057 2.18609079 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 134 1.17e-38   NR MDB5223560.1 1869212 g14688 i0 85.2 1.96761133603239 81 12 98.4 0 3 245 17 97 MDB5223560.1 hypothetical protein [Chitinophagaceae bacterium] diamond 486 134 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
28626622 28626622 PRJNA559720_P_NODE_11907_length_275_cov_1.524752_g11768_i0 PRJNA559720 11907 275 1.524752 4.193068 Prevotella sp. 59823 Bacteria Bacteria 156 1.04e-43   NR MBB1538225.1 59823 g11768 i0 90.1 0.992727272727273 91 9 99.3 0 274 2 104 194 MBB1538225.1 hypothetical protein [Prevotella sp.] diamond 273 156 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella sp.
28956414 28956414 PRJNA559720_P_NODE_968_length_942_cov_11.525892_g897_i0 PRJNA559720 968 942 11.525892 108.57390264 Bacteroidota 976 Bacteria Bacteria 211 3.27e-63   NR RYG06432.1 1869212 g897 i0 40.8 9.67197452229299 284 152 90.4 5 915 64 3 270 RYG06432.1 MAG: purine-nucleoside phosphorylase [Chitinophagaceae bacterium] diamond 9111 211 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
29555910 29555910 PRJNA559720_P_NODE_9790_length_312_cov_1.288703_g9651_i0 PRJNA559720 9790 312 1.288703 4.02075336 Bacteroidota 976 Bacteria Bacteria 42 0.0387   NR MBR4792940.1 2212467 g9651 i0 32.8 1.08653846153846 61 40 57.7 1 39 218 2 62 MBR4792940.1 nucleotidyltransferase domain-containing protein [Bacteroidaceae bacterium] diamond 339 42.4 0.990566037735849 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae   Bacteroidaceae bacterium
29636420 29636420 PRJNA559720_P_NODE_8830_length_334_cov_0.885057_g8691_i0 PRJNA559720 8830 334 0.885057 2.95609038 Balneolaceae bacterium 2053516 Bacteria Bacteria 89.7 2.69e-18   NR MEQ9266325.1 2053516 g8691 i0 43.4 1.91317365269461 106 59 94.3 1 323 9 36 141 MEQ9266325.1 aldehyde dehydrogenase [Balneolaceae bacterium] diamond 639 89.7 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
29952571 29952571 PRJNA559720_P_NODE_6791_length_392_cov_1.144201_g6652_i0 PRJNA559720 6791 392 1.144201 4.48526792 Flavobacterium magnum 2162713 Bacteria Bacteria 44.3 0.0483   NR WP_108372214.1 2162713 g6652 i0 36.1 0.466836734693878 61 34 44.4 2 98 271 22 80 WP_108372214.1 serine hydrolase domain-containing protein [Flavobacterium magnum] diamond 183 44.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium magnum
30236946 30236946 PRJNA559720_P_NODE_4952_length_466_cov_2.653944_g4814_i0 PRJNA559720 4952 466 2.653944 12.36737904 Bacteroidota bacterium 1898104 Bacteria Bacteria 62 1.84e-9   NR MCP3658986.1 1898104 g4814 i0 42.7 0.482832618025751 75 42 47.6 1 179 400 1 75 MCP3658986.1 acyl carrier protein [Bacteroidota bacterium] diamond 225 62 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
30300563 30300563 PRJNA559720_P_NODE_13612_length_251_cov_0.865169_g13473_i0 PRJNA559720 13612 251 0.865169 2.17157419 Dyadobacter sediminis 1493691 Bacteria Bacteria 150 3.98e-40   NR WP_138283381.1 1493691 g13473 i0 89.2 0.99203187250996006 83 9 99.2 0 249 1 405 487 WP_138283381.1 DUF1553 domain-containing protein [Dyadobacter sediminis] diamond 249 150 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Dyadobacter Dyadobacter sediminis
30332226 30332226 PRJNA559720_P_NODE_16312_length_241_cov_0.916667_g16173_i0 PRJNA559720 16312 241 0.916667 2.20916747 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 162 7.479999999999999e-45   NR MCA6438634.1 1869212 g16173 i0 100 0.995850622406639 80 0 99.6 0 241 2 108 187 MCA6438634.1 PAS domain-containing protein [Chitinophagaceae bacterium] diamond 240 162 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
30900565 30900565 PRJNA559720_P_NODE_12214_length_270_cov_1.563452_g12075_i0 PRJNA559720 12214 270 1.563452 4.2213204 Sediminibacterium sp. 1917865 Bacteria Bacteria 113 5.18e-30   NR WP_295203868.1 1917865 g12075 i0 61.4 0.977777777777778 88 34 97.8 0 266 3 5 92 WP_295203868.1 hypothetical protein [Sediminibacterium sp.] diamond 264 113 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Sediminibacterium Sediminibacterium sp.
31437712 31437712 PRJNA559720_P_NODE_10656_length_295_cov_2.828829_g10517_i0 PRJNA559720 10656 295 2.828829 8.34504555 Segetibacter sp. 2231182 Bacteria Bacteria 43.5 0.0082   NR MDB5193873.1 2231182 g10517 i0 34.8 1.08813559322034 46 30 46.8 0 63 200 2 47 MDB5193873.1 hypothetical protein [Segetibacter sp.] diamond 321 43.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Segetibacter Segetibacter sp.
31912270 31912270 PRJNA559720_P_NODE_11497_length_282_cov_1.105263_g11358_i0 PRJNA559720 11497 282 1.105263 3.11684166 Bacteroidota bacterium 1898104 Bacteria Bacteria 52.4 2.29e-5   NR MEA3317381.1 1898104 g11358 i0 38.2 0.946808510638298 89 50 94.7 3 5 271 319 402 MEA3317381.1 ectonucleotide pyrophosphatase/phosphodiesterase [Bacteroidota bacterium] diamond 267 52.4 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
32450416 32450416 PRJNA559720_P_NODE_9539_length_318_cov_1.412245_g9400_i0 PRJNA559720 9539 318 1.412245 4.4909391 Pedobacter sp. 1411316 Bacteria Bacteria 43.9 0.0336   NR MFA5244554.1 1411316 g9400 i0 29 0.943396226415094 100 64 87.7 3 286 8 153 252 MFA5244554.1 Ig-like domain-containing domain [Pedobacter sp.] diamond 300 43.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pedobacter Pedobacter sp.
32873981 32873981 PRJNA559720_P_NODE_7260_length_376_cov_1.504950_g7121_i0 PRJNA559720 7260 376 1.50495 5.658612 Bacteria 2 Bacteria Bacteria 154 5.99e-42   NR OFX31566.1 1797320 g7121 i0 60 18.9494680851064 125 50 99.7 0 2 376 15 139 OFX31566.1 MAG: adenosylhomocysteinase [Bacteroidetes bacterium GWA2_42_15] diamond 7125 154 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidetes bacterium GWA2_42_15

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