RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Fibrobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fibrobacterota · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB64798 · 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
27286603 27286603 PRJEB64798_P_NODE_184083_length_172_cov_20.617886_g182317_i0 PRJEB64798 184083 172 20.617886 35.46276392 Fibrobacteria bacterium 2725311 Bacteria Bacteria 65.5 1.38e-10   NR MCD6023671.1 2725311 g182317 i0 49.1 0.994186046511628 57 29 99.4 0 172 2 254 310 MCD6023671.1 putative phosphatase [Fibrobacteria bacterium] diamond 171 65.5 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria       Fibrobacteria bacterium
27349987 27349987 PRJEB64798_P_NODE_113943_length_209_cov_5.568750_g112177_i0 PRJEB64798 113943 209 5.56875 11.6386875 Fibrobacteria bacterium 2725311 Bacteria Bacteria 57.4 1.61e-7   NR HLP42917.1 2725311 g112177 i0 81.3 0.904306220095694 32 6 45.9 0 112 207 354 385 HLP42917.1 sulfite reductase subunit alpha [Fibrobacteria bacterium] diamond 189 57.4 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria       Fibrobacteria bacterium
27697627 27697627 PRJEB64798_P_NODE_241784_length_154_cov_8.257143_g240018_i0 PRJEB64798 241784 154 8.257143 12.71600022 uncultured Fibrobacter sp. 261512 Bacteria Bacteria 41.2 0.0378   NR WP_297702374.1 261512 g240018 i0 34.5 1.12987012987013 58 29 95.5 2 3 149 160 217 WP_297702374.1 Rpn family recombination-promoting nuclease/putative transposase [uncultured Fibrobacter sp.] diamond 174 41.2 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter uncultured Fibrobacter sp.
28518073 28518073 PRJEB64798_P_NODE_100247_length_212_cov_3.055215_g98481_i0 PRJEB64798 100247 212 3.055215 6.4770558 Fibrobacteria bacterium 2725311 Bacteria Bacteria 50.8 2.65e-5   NR MCD6024480.1 2725311 g98481 i0 77.4 0.438679245283019 31 7 43.9 0 98 6 29 59 MCD6024480.1 hypothetical protein [Fibrobacteria bacterium] diamond 93 50.8 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria       Fibrobacteria bacterium
29876052 29876052 PRJEB64798_P_NODE_98111_length_212_cov_3.496933_g96345_i0 PRJEB64798 98111 212 3.496933 7.41349796 Fibrobacter sp. 35828 Bacteria Bacteria 43.1 0.0169   NR NLD93806.1 35828 g96345 i0 50 0.39622641509434 28 14 39.6 0 128 211 7 34 NLD93806.1 hypothetical protein [Fibrobacter sp.] diamond 84 43.1 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter sp.
30792037 30792037 PRJEB64798_P_NODE_219634_length_162_cov_3.327434_g217868_i0 PRJEB64798 219634 162 3.327434 5.39044308 Fibrobacterota bacterium 2052160 Bacteria Bacteria 87.4 6.9e-20   NR MEN9352870.1 2052160 g217868 i0 86.5 0.962962962962963 52 7 96.3 0 7 162 7 58 MEN9352870.1 ribosomal protein [Fibrobacterota bacterium] diamond 156 87.4 1 Bacteria FCB group Pseudomonadati Fibrobacterota         Fibrobacterota bacterium
31171091 31171091 PRJEB64798_P_NODE_92315_length_212_cov_5.429448_g90549_i0 PRJEB64798 92315 212 5.429448 11.51042976 Fibrobacter sp. UWB8 1896207 Bacteria Bacteria 88.6 2.29e-19   NR WP_073056964.1 1896207 g90549 i0 62.9 0.990566037735849 70 24 96.2 1 205 2 140 209 WP_073056964.1 class I SAM-dependent methyltransferase [Fibrobacter sp. UWB8] diamond 210 88.6 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter sp. UWB8
31487664 31487664 PRJEB64798_P_NODE_178976_length_175_cov_1.373016_g177210_i0 PRJEB64798 178976 175 1.373016 2.402778 Fibrobacterota bacterium 2052160 Bacteria Bacteria 87.4 2.57e-20   NR MEN9353540.1 2052160 g177210 i0 95.5 0.754285714285714 44 2 75.4 0 43 174 1 44 MEN9353540.1 hypothetical protein [Fibrobacterota bacterium] diamond 132 87.4 1 Bacteria FCB group Pseudomonadati Fibrobacterota         Fibrobacterota bacterium
31708755 31708755 PRJEB64798_P_NODE_102997_length_212_cov_2.558282_g101231_i0 PRJEB64798 102997 212 2.558282 5.42355784 Fibrobacter sp. 35828 Bacteria Bacteria 87 6.99e-19   NR WP_405338213.1 35828 g101231 i0 55.1 2.16509433962264 78 26 97.6 1 208 2 1 78 WP_405338213.1 class I SAM-dependent methyltransferase [Fibrobacter sp.] diamond 459 87 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter sp.
31740354 31740354 PRJEB64798_P_NODE_202097_length_167_cov_0.881356_g200331_i0 PRJEB64798 202097 167 0.881356 1.47186452 Fibrobacterota bacterium 2052160 Bacteria Bacteria 74.3 1.57e-15   NR MDB5102902.1 2052160 g200331 i0 86.1 1.29341317365269 36 5 64.7 0 166 59 16 51 MDB5102902.1 hypothetical protein [Fibrobacterota bacterium] diamond 216 74.3 1 Bacteria FCB group Pseudomonadati Fibrobacterota         Fibrobacterota bacterium
31930099 31930099 PRJEB64798_P_NODE_104977_length_211_cov_20.598765_g103211_i0 PRJEB64798 104977 211 20.598765 43.46339415 Fibrobacterota bacterium 2052160 Bacteria Bacteria 66.2 1.28e-10   NR MEN9353465.1 2052160 g103211 i0 93.5 0.440758293838863 31 2 44.1 0 94 2 369 399 MEN9353465.1 hypothetical protein [Fibrobacterota bacterium] diamond 93 66.2 1 Bacteria FCB group Pseudomonadati Fibrobacterota         Fibrobacterota bacterium
32018332 32018332 PRJEB64798_P_NODE_87798_length_212_cov_10.693252_g86032_i0 PRJEB64798 87798 212 10.693252 22.66969424 Pseudomonadati 3379134 Bacteria Bacteria 45.1 0.00393   NR MDB5106241.1 2052160 g86032 i0 51.8 2.91509433962264 56 24 79.2 2 195 28 1329 1381 MDB5106241.1 repeat-containing protein [Fibrobacterota bacterium] diamond 618 45.4 0.993392070484582 Bacteria FCB group Pseudomonadati Fibrobacterota         Fibrobacterota bacterium
32341726 32341726 PRJEB64798_P_NODE_105039_length_211_cov_18.962963_g103273_i0 PRJEB64798 105039 211 18.962963 40.01185193 Fibrobacteria bacterium 2725311 Bacteria Bacteria 44.3 0.00255   NR MEO6096779.1 2725311 g103273 i0 42.6 0.867298578199052 61 29 86.7 1 2 184 32 86 MEO6096779.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Fibrobacteria bacterium] diamond 183 44.3 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria       Fibrobacteria bacterium
32493089 32493089 PRJEB64798_P_NODE_88299_length_212_cov_9.226994_g86533_i0 PRJEB64798 88299 212 9.226994 19.56122728 Bacteria 2 Bacteria Bacteria 47.8 4.26e-4   NR MEN9353945.1 2052160 g86533 i0 37.8 2.77358490566038 82 30 86.3 1 196 14 514 595 MEN9353945.1 hypothetical protein [Fibrobacterota bacterium] diamond 588 48.1 0.993762993762994 Bacteria FCB group Pseudomonadati Fibrobacterota         Fibrobacterota bacterium
32752032 32752032 PRJEB64798_P_NODE_158640_length_184_cov_2.992593_g156874_i0 PRJEB64798 158640 184 2.992593 5.50637112 Fibrobacteria bacterium 2725311 Bacteria Bacteria 53.1 3.63e-6   NR HLP42602.1 2725311 g156874 i0 42.1 0.929347826086957 57 33 92.9 0 13 183 347 403 HLP42602.1 IS1634 family transposase [Fibrobacteria bacterium] diamond 171 53.1 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria       Fibrobacteria bacterium
32783417 32783417 PRJEB64798_P_NODE_218720_length_162_cov_6.371681_g216954_i0 PRJEB64798 218720 162 6.371681 10.32212322 Fibrobacteria bacterium 2725311 Bacteria Bacteria 53.1 1e-6   NR HNY31279.1 2725311 g216954 i0 46.9 1.77777777777778 49 26 90.7 0 152 6 95 143 HNY31279.1 hypothetical protein [Fibrobacteria bacterium] diamond 288 53.1 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria       Fibrobacteria 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);;