RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA588137" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA588137 · 16 ✖

analysis 1

  • diamond · 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
5668532 5668532 PRJNA588137_S_NODE_9905_length_243_cov_0.905882_g9872_i0 PRJNA588137 9905 243 0.905882 2.20129326 Porphyromonas catoniae 41976 Bacteria Bacteria 169 1.49e-49   NR WP_005469261.1 41976 g9872 i0 100 3 81 0 100 0 243 1 140 220 WP_005469261.1 NAD(P)H-dependent glycerol-3-phosphate dehydrogenase [Porphyromonas catoniae] diamond 729 169 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas catoniae
23517104 23517104 PRJNA588137_S_NODE_10859_length_241_cov_1.750000_g10826_i0 PRJNA588137 10859 241 1.75 4.2175 Flavobacterium cerinum 2502784 Bacteria Bacteria 177 2.1e-52   NR WP_128390300.1 2502784 g10826 i0 94.9 0.983402489626556 79 4 98.3 0 1 237 306 384 WP_128390300.1 ergothioneine biosynthesis protein EgtB [Flavobacterium cerinum] diamond 237 177 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium cerinum
26921492 26921492 PRJNA588137_S_NODE_8802_length_246_cov_0.890173_g8769_i0 PRJNA588137 8802 246 0.890173 2.18982558 Bacteroidota bacterium 1898104 Bacteria Bacteria 100 1.37e-24   NR MBS1656041.1 1898104 g8769 i0 65.3 0.878048780487805 72 25 87.8 0 242 27 41 112 MBS1656041.1 hypothetical protein [Bacteroidota bacterium] diamond 216 100 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
26966549 26966549 PRJNA588137_S_NODE_11302_length_241_cov_0.916667_g11269_i0 PRJNA588137 11302 241 0.916667 2.20916747 Bacteria 2 Bacteria Bacteria 77.4 1.54e-15   NR WP_013407084.1 316068 g11269 i0 46.1 12.0871369294606 76 41 94.6 0 241 14 35 110 WP_013407084.1 NUDIX domain-containing protein [Leadbetterella byssophila] diamond 2913 77.8 0.994858611825193 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Leadbetterellaceae Leadbetterella Leadbetterella byssophila
27048116 27048116 PRJNA588137_S_NODE_8442_length_247_cov_0.867816_g8409_i0 PRJNA588137 8442 247 0.867816 2.14350552 Flavobacterium rhizophilum 3163296 Bacteria Bacteria 96.7 2.4600000000000003e-21   NR WP_408073799.1 3163296 g8409 i0 64.9 0.898785425101215 74 26 89.9 0 3 224 49 122 WP_408073799.1 conjugative transposon protein TraM [Flavobacterium rhizophilum] diamond 222 96.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium rhizophilum
27806415 27806415 PRJNA588137_S_NODE_2884_length_325_cov_0.916667_g2851_i0 PRJNA588137 2884 325 0.916667 2.97916775 Prevotella sp. P3-12 59823 Bacteria Bacteria 71.6 4.35e-14   NR WP_216822835.1 2024220 g2851 i0 91.4 0.323076923076923 35 3 32.3 0 61 165 3 37 WP_216822835.1 hypothetical protein, partial [Prevotella sp. P3-120] diamond 105 71.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella sp. P3-120
28279619 28279619 PRJNA588137_S_NODE_9546_length_244_cov_0.900585_g9513_i0 PRJNA588137 9546 244 0.900585 2.1974274 Pedobacter xixiisoli 1476464 Bacteria Bacteria 148 5.72e-41   NR WP_097133315.1 1476464 g9513 i0 93.8 1.99180327868852 81 5 99.6 0 1 243 238 318 WP_097133315.1 class I SAM-dependent rRNA methyltransferase [Pedobacter xixiisoli] diamond 486 148 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pedobacter Pedobacter xixiisoli
29542695 29542695 PRJNA588137_S_NODE_5070_length_272_cov_1.487437_g5037_i0 PRJNA588137 5070 272 1.487437 4.04582864 Bizionia paragorgiae 283786 Bacteria Bacteria 43.1 0.0285   NR WP_092133343.1 283786 g5037 i0 45.5 0.606617647058823 55 29 59.6 1 110 271 69 123 WP_092133343.1 glycoside hydrolase family 19 protein [Bizionia paragorgiae] diamond 165 43.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Bizionia Bizionia paragorgiae
29984949 29984949 PRJNA588137_S_NODE_8671_length_246_cov_0.890173_g8638_i0 PRJNA588137 8671 246 0.890173 2.18982558 Fluviicola sp. 1917219 Bacteria Bacteria 45.1 0.00541   NR HRP53004.1 1917219 g8638 i0 68.6 0.426829268292683 35 11 42.7 0 105 1 1 35 HRP53004.1 glycosyltransferase [Fluviicola sp.] diamond 105 45.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Crocinitomicaceae Fluviicola Fluviicola sp.
30016606 30016606 PRJNA588137_S_NODE_9571_length_244_cov_0.900585_g9538_i0 PRJNA588137 9571 244 0.900585 2.1974274 Flavobacterium cerinum 2502784 Bacteria Bacteria 132 7.339999999999998e-35   NR WP_128389844.1 2502784 g9538 i0 84.4 0.94672131147541 77 12 94.7 0 2 232 236 312 WP_128389844.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Flavobacterium cerinum] diamond 231 132 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium cerinum
30187850 30187850 PRJNA588137_S_NODE_7832_length_248_cov_0.880000_g7799_i0 PRJNA588137 7832 248 0.88 2.1824 Spirosoma 107 Bacteria Bacteria 78.2 1.3e-14   NR WP_018620097.1 431553 g7799 i0 94.9 2.83064516129032 39 2 47.2 0 246 130 582 620 WP_018620097.1 ABC transporter ATP-binding protein [Spirosoma luteum] diamond 702 78.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae Spirosoma Spirosoma luteum
30364464 30364464 PRJNA588137_S_NODE_9232_length_245_cov_0.895349_g9199_i0 PRJNA588137 9232 245 0.895349 2.19360505 Chryseobacterium sp. G 1871047 Bacteria Bacteria 130 7.37e-33   NR WP_123942433.1 2487064 g9199 i0 76.3 0.979591836734694 80 19 98 0 244 5 1978 2057 WP_123942433.1 polymorphic toxin type 23 domain-containing protein [Chryseobacterium sp. G0186] diamond 240 130 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium sp. G0186
31153566 31153566 PRJNA588137_S_NODE_8115_length_247_cov_0.885057_g8082_i0 PRJNA588137 8115 247 0.885057 2.18609079 Sediminibacterium sp. 1917865 Bacteria Bacteria 59.3 5.23e-8   NR HEX7692709.1 1917865 g8082 i0 41.1 0.88663967611336 73 39 83.8 1 232 26 59 131 HEX7692709.1 hypothetical protein [Sediminibacterium sp.] diamond 219 59.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Sediminibacterium Sediminibacterium sp.
31185249 31185249 PRJNA588137_S_NODE_7555_length_249_cov_0.875000_g7522_i0 PRJNA588137 7555 249 0.875 2.17875 Taibaiella chishuiensis 1434707 Bacteria Bacteria 153 7.61e-46   NR WP_281257984.1 1434707 g7522 i0 96.3 0.987951807228916 82 3 98.8 0 247 2 15 96 WP_281257984.1 helix-turn-helix domain-containing protein [Taibaiella chishuiensis] diamond 246 153 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Taibaiella Taibaiella chishuiensis
31343711 31343711 PRJNA588137_S_NODE_6696_length_251_cov_0.865169_g6663_i0 PRJNA588137 6696 251 0.865169 2.17157419 Flavobacterium cerinum 2502784 Bacteria Bacteria 165 3.07e-45   NR WP_206619124.1 2502784 g6663 i0 94 0.99203187250996006 83 5 99.2 0 3 251 678 760 WP_206619124.1 T9SS type B sorting domain-containing protein [Flavobacterium cerinum] diamond 249 165 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium cerinum
32640110 32640110 PRJNA588137_S_NODE_10040_length_243_cov_0.905882_g10007_i0 PRJNA588137 10040 243 0.905882 2.20129326 Cytophagaceae bacterium 2026729 Bacteria Bacteria 110 4.1e-28   NR RYF45007.1 2026729 g10007 i0 63.6 1.08641975308642 88 25 100 1 243 1 7 94 RYF45007.1 MAG: ATP-binding cassette domain-containing protein, partial [Cytophagaceae bacterium] diamond 264 110 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae   Cytophagaceae 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);;