RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1192965" 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 · 19 ✖

bioproject 1

  • PRJNA1192965 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
4147406 4147406 PRJNA1192965_P_NODE_144_length_891_cov_2.152812_g131_i0 PRJNA1192965 144 891 2.152812 19.18155492 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 394 6.969999999999998e-128   NR MCA6491779.1 1869212 g131 i0 67.8 0.962962962962963 286 83 96.3 2 1 858 2 278 MCA6491779.1 GTP-binding protein [Chitinophagaceae bacterium] diamond 858 394 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
9248418 9248418 PRJNA1192965_P_NODE_1488_length_335_cov_1.763359_g1469_i0 PRJNA1192965 1488 335 1.763359 5.90725265 Bacteria 2 Bacteria Bacteria 178 2.89e-51   NR MCH2451948.1 2026742 g1469 i0 73.9 4.97014925373134 111 29 99.4 0 334 2 252 362 MCH2451948.1 adenosylhomocysteinase [Gemmatimonadota bacterium] diamond 1665 179 0.994413407821229 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
9248435 9248435 PRJNA1192965_P_NODE_4488_length_244_cov_1.801170_g4469_i0 PRJNA1192965 4488 244 1.80117 4.3948548 Tannerella sp. oral taxon BU 2382127 Bacteria Bacteria 171 2.92e-47   NR ETK10705.1 1411021 g4469 i0 100 0.983606557377049 80 0 98.4 0 242 3 480 559 ETK10705.1 methylase, partial [Tannerella sp. oral taxon BU063 isolate Cell 6/7/9] diamond 240 171 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Tannerellaceae Tannerella Tannerella serpentiformis
21997248 21997248 PRJNA1192965_P_NODE_78_length_1082_cov_2.207136_g69_i0 PRJNA1192965 78 1082 2.207136 23.88121152 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 512 7.019999999999999e-173   NR MCA6491779.1 1869212 g69 i0 67.4 0.995378927911275 359 116 99.5 1 1079 3 329 686 MCA6491779.1 GTP-binding protein [Chitinophagaceae bacterium] diamond 1077 512 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
26755658 26755658 PRJNA1192965_P_NODE_4361_length_245_cov_0.895349_g4342_i0 PRJNA1192965 4361 245 0.895349 2.19360505 Bacteroidota bacterium 1898104 Bacteria Bacteria 82.8 3.06e-16   NR MEM0997395.1 1898104 g4342 i0 50.6 3.97959183673469 81 40 99.2 0 245 3 806 886 MEM0997395.1 T9SS type A sorting domain-containing protein [Bacteroidota bacterium] diamond 975 82.8 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
27293594 27293594 PRJNA1192965_P_NODE_3223_length_252_cov_1.463687_g3204_i0 PRJNA1192965 3223 252 1.463687 3.68849124 Bacteroidota bacterium 1898104 Bacteria Bacteria 97.4 2.51e-21   NR MBK9448845.1 1898104 g3204 i0 57 1.88095238095238 79 34 94 0 10 246 678 756 MBK9448845.1 gliding motility-associated C-terminal domain-containing protein [Bacteroidota bacterium] diamond 474 97.4 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
27420285 27420285 PRJNA1192965_P_NODE_943_length_399_cov_0.944785_g924_i0 PRJNA1192965 943 399 0.944785 3.76969215 Dysgonamonadaceae bacterium 2065189 Bacteria Bacteria 55.1 8.81e-6   NR MDD4727728.1 2065189 g924 i0 31.1 0.992481203007519 132 80 98.5 3 3 395 172 293 MDD4727728.1 DNA polymerase IV [Dysgonamonadaceae bacterium] diamond 396 55.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Dysgonomonadaceae   Dysgonamonadaceae bacterium
27546330 27546330 PRJNA1192965_P_NODE_724_length_444_cov_1.037736_g705_i0 PRJNA1192965 724 444 1.037736 4.60754784 Saprospiraceae bacterium 2202734 Bacteria Bacteria 52.4 1.41e-4   NR MDX1478598.1 2202734 g705 i0 38.4 0.668918918918919 99 58 66.9 1 299 3 997 1092 MDX1478598.1 hypothetical protein [Saprospiraceae bacterium] diamond 297 52.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
28082981 28082981 PRJNA1192965_P_NODE_1465_length_337_cov_2.780303_g1446_i0 PRJNA1192965 1465 337 2.780303 9.36962111 Mesoflavibacter sp. CH_XMU14 1930902 Bacteria Bacteria 88.2 5.54e-19   NR WP_336065625.1 3107766 g1446 i0 53.7 1.45994065281899 82 37 72.1 1 247 5 43 124 WP_336065625.1 glycoside hydrolase family 19 protein [Mesoflavibacter sp. CH_XMU1404-2] diamond 492 88.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Mesoflavibacter Mesoflavibacter sp. CH_XMU1404-2
28082983 28082983 PRJNA1192965_P_NODE_3265_length_251_cov_1.297753_g3246_i0 PRJNA1192965 3265 251 1.297753 3.25736003 Saprospiraceae bacterium 2202734 Bacteria Bacteria 50.4 8.13e-5   NR NNE25220.1 2202734 g3246 i0 37.3 1.69721115537849 83 52 99.2 0 250 2 619 701 NNE25220.1 DUF11 domain-containing protein [Saprospiraceae bacterium] diamond 426 50.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
28525273 28525273 PRJNA1192965_P_NODE_2547_length_276_cov_1.517241_g2528_i0 PRJNA1192965 2547 276 1.517241 4.18758516 Bacteroidia bacterium 2044936 Bacteria Bacteria 46.2 0.00325   NR MFK7972564.1 2044936 g2528 i0 32.1 0.847826086956522 78 42 84.8 2 245 12 330 396 MFK7972564.1 MORN repeat-containing protein [Bacteroidia bacterium] diamond 234 46.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
28620015 28620015 PRJNA1192965_P_NODE_1187_length_366_cov_1.982935_g1168_i0 PRJNA1192965 1187 366 1.982935 7.2575421 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 127 4.48e-31   NR MCA6491779.1 1869212 g1168 i0 52.6 0.934426229508197 114 52 93.4 2 1 342 718 829 MCA6491779.1 GTP-binding protein [Chitinophagaceae bacterium] diamond 342 127 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
28808953 28808953 PRJNA1192965_P_NODE_4688_length_243_cov_1.782353_g4669_i0 PRJNA1192965 4688 243 1.782353 4.33111779 Saprospiraceae bacterium 2202734 Bacteria Bacteria 77.8 1.63e-14   NR MFK7772512.1 2202734 g4669 i0 50.9 2.12345679012346 57 27 69.1 1 172 5 48 104 MFK7772512.1 hypothetical protein [Saprospiraceae bacterium] diamond 516 77.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
28828138 28828138 PRJNA1192965_P_NODE_2608_length_273_cov_2.310000_g2589_i0 PRJNA1192965 2608 273 2.31 6.3063 Pseudomonadati 3379134 Bacteria Bacteria 67.4 2.46e-11   NR WP_092133343.1 283786 g2589 i0 45 1.8021978021978 80 44 87.9 0 271 32 88 167 WP_092133343.1 glycoside hydrolase family 19 protein [Bizionia paragorgiae] diamond 492 67.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Bizionia Bizionia paragorgiae
28967295 28967295 PRJNA1192965_P_NODE_2408_length_281_cov_7.177885_g2389_i0 PRJNA1192965 2408 281 7.177885 20.16985685 Bacteroidota bacterium 1898104 Bacteria Bacteria 110 8.39e-29   NR MFM1913008.1 1898104 g2389 i0 61.9 1.84697508896797 84 32 89.7 0 279 28 7 90 MFM1913008.1 hypothetical protein [Bacteroidota bacterium] diamond 519 110 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
30262186 30262186 PRJNA1192965_P_NODE_4532_length_244_cov_0.900585_g4513_i0 PRJNA1192965 4532 244 0.900585 2.1974274 Gelidibacter salicanalis 291193 Bacteria Bacteria 74.7 2.15e-13   NR WP_146893812.1 291193 g4513 i0 48.1 2.02868852459016 81 38 98.4 2 243 4 1466 1543 WP_146893812.1 gliding motility-associated C-terminal domain-containing protein [Gelidibacter salicanalis] diamond 495 74.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Gelidibacter Gelidibacter salicanalis
30640933 30640933 PRJNA1192965_P_NODE_2333_length_285_cov_1.037736_g2314_i0 PRJNA1192965 2333 285 1.037736 2.9575476 Saprospiraceae bacterium 2202734 Bacteria Bacteria 103 2.5699999999999998e-23   NR MFN4253882.1 2202734 g2314 i0 57.6 0.968421052631579 92 35 96.8 3 3 278 241 328 MFN4253882.1 T9SS type A sorting domain-containing protein [Saprospiraceae bacterium] diamond 276 103 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
31209346 31209346 PRJNA1192965_P_NODE_795_length_424_cov_1.316239_g776_i0 PRJNA1192965 795 424 1.316239 5.58085336 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 62 4.76e-8   NR MDP3774453.1 2448054 g776 i0 36.1 1.0188679245283 144 72 96.2 6 1 408 240 371 MDP3774453.1 reverse transcriptase domain-containing protein [Gemmatimonadales bacterium] diamond 432 62 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31431158 31431158 PRJNA1192965_P_NODE_4036_length_247_cov_0.885057_g4017_i0 PRJNA1192965 4036 247 0.885057 2.18609079 Bacteroidetes bacterium SB0662_bin_6 2604895 Bacteria Bacteria 95.9 7.54e-21   NR MYE04204.1 2604895 g4017 i0 54.3 2.95141700404858 81 35 98.4 1 3 245 329 407 MYE04204.1 glutamine synthetase type III [Bacteroidetes bacterium SB0662_bin_6] diamond 729 95.9 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidetes bacterium SB0662_bin_6

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