RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJDB12134" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJDB12134 · 19 ✖

analysis 1

  • diamond · 19 ✖

tax_clade 0

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
2549953 2549953 PRJDB12134_P_NODE_13623_length_246_cov_0.901734_g13488_i0 PRJDB12134 13623 246 0.901734 2.21826564 Thermicanus 94008 Bacteria Bacteria 159 8.38e-44   NR WP_028986414.1 94009 g13488 i0 95.1 1.97560975609756 81 4 98.8 0 245 3 333 413 WP_028986414.1 threonine--tRNA ligase [Thermicanus aegyptius] diamond 486 159 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
6378344 6378344 PRJDB12134_P_NODE_12326_length_253_cov_0.866667_g12191_i0 PRJDB12134 12326 253 0.866667 2.19266751 Bacillales Family X. Incertae Sedis 539003 Bacteria Bacteria 97.4 2.4099999999999998e-24   NR WP_005583495.1 94009 g12191 i0 82.8 1.99209486166008 58 10 68.8 0 79 252 1 58 WP_005583495.1 30S ribosomal protein S17 [Thermicanus aegyptius] diamond 504 98.2 0.991853360488798 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
26969003 26969003 PRJDB12134_P_NODE_13662_length_246_cov_0.895954_g13527_i0 PRJDB12134 13662 246 0.895954 2.20404684 uncultured Butyricicoccus sp. 1193532 Bacteria Bacteria 63.5 9.45e-10   NR WP_300129268.1 1193532 g13527 i0 88.2 0.804878048780488 34 4 41.5 0 2 103 221 254 WP_300129268.1 flagellar biosynthetic protein FliR [uncultured Butyricicoccus sp.] diamond 198 63.5 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Butyricicoccaceae Butyricicoccus uncultured Butyricicoccus sp.
27190288 27190288 PRJDB12134_P_NODE_14382_length_242_cov_0.917160_g14247_i0 PRJDB12134 14382 242 0.91716 2.2195272 Staphylococcus aureus 1280 Bacteria Bacteria 59.3 1.28e-9   NR WP_154275089.1 1280 g14247 i0 46.7 0.743801652892562 60 32 74.4 0 32 211 1 60 WP_154275089.1 hypothetical protein, partial [Staphylococcus aureus] diamond 180 59.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
27317030 27317030 PRJDB12134_P_NODE_10163_length_287_cov_1.252336_g10028_i0 PRJDB12134 10163 287 1.252336 3.59420432 Streptococcus hyointestinalis 1337 Bacteria Bacteria 91.7 2.9400000000000003e-21   NR WP_115267910.1 1337 g10028 i0 79.6 3.93031358885017 49 10 51.2 0 286 140 92 140 WP_115267910.1 IS200/IS605 family transposase [Streptococcus hyointestinalis] diamond 1128 91.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus hyointestinalis
27664404 27664404 PRJDB12134_P_NODE_14384_length_242_cov_0.911243_g14249_i0 PRJDB12134 14384 242 0.911243 2.20520806 Streptococcus mitis 28037 Bacteria Bacteria 151 7.63e-41   NR WP_261116908.1 28037 g14249 i0 98.8 0.991735537190083 80 1 99.2 0 1 240 47 126 WP_261116908.1 DUF262 domain-containing protein [Streptococcus mitis] diamond 240 151 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
28138066 28138066 PRJDB12134_P_NODE_10725_length_278_cov_1.521951_g10590_i0 PRJDB12134 10725 278 1.521951 4.23102378 Thermicanus aegyptius 94009 Bacteria Bacteria 101 1.09e-24   NR WP_052329760.1 94009 g10590 i0 98.2 0.593525179856115 55 1 59.4 0 2 166 65 119 WP_052329760.1 PepSY domain-containing protein [Thermicanus aegyptius] diamond 165 101 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
29022275 29022275 PRJDB12134_P_NODE_13348_length_247_cov_1.683908_g13213_i0 PRJDB12134 13348 247 1.683908 4.15925276 Sporolituus thermophilus 608505 Bacteria Bacteria 139 3.02e-38   NR WP_093687041.1 608505 g13213 i0 82.5 3.89878542510121 80 14 97.2 0 6 245 67 146 WP_093687041.1 stage V sporulation protein AD [Sporolituus thermophilus] diamond 963 139 1 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Sporomusaceae Sporolituus Sporolituus thermophilus
29489533 29489533 PRJDB12134_P_NODE_14150_length_243_cov_0.917647_g14015_i0 PRJDB12134 14150 243 0.917647 2.22988221 Streptococcus 1301 Bacteria Bacteria 160 5.54e-49   NR WP_241735667.1 1303 g14015 i0 96.3 3.95061728395062 80 3 98.8 0 2 241 32 111 WP_241735667.1 Rep family protein, partial [Streptococcus oralis] diamond 960 160 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
30158503 30158503 PRJDB12134_P_NODE_12532_length_251_cov_1.719101_g12397_i0 PRJDB12134 12532 251 1.719101 4.31494351 Jeotgalibacillus marinus 86667 Bacteria Bacteria 56.2 3.51e-8   NR WP_367780291.1 86667 g12397 i0 44.6 0.99203187250996006 83 26 99.2 1 251 3 16 78 WP_367780291.1 hypothetical protein [Jeotgalibacillus marinus] diamond 249 56.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Jeotgalibacillus Jeotgalibacillus marinus
30380322 30380322 PRJDB12134_P_NODE_10353_length_284_cov_1.004739_g10218_i0 PRJDB12134 10353 284 1.004739 2.85345876 Anaeroglobus geminatus 156456 Bacteria Bacteria 90.1 3.44e-19   NR WP_006789352.1 156456 g10218 i0 97.7 0.464788732394366 44 1 46.5 0 3 134 269 312 WP_006789352.1 protein translocase subunit SecF [Anaeroglobus geminatus] diamond 132 90.1 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Anaeroglobus Anaeroglobus geminatus
30790635 30790635 PRJDB12134_P_NODE_10014_length_289_cov_1.111111_g9879_i0 PRJDB12134 10014 289 1.111111 3.21111079 Virgibacillus sp. 1872700 Bacteria Bacteria 126 2.91e-32   NR HLR66999.1 1872700 g9879 i0 61.1 1.97231833910035 95 37 98.6 0 1 285 213 307 HLR66999.1 alkyl sulfatase dimerization domain-containing protein [Virgibacillus sp.] diamond 570 126 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Virgibacillus Virgibacillus sp.
31075107 31075107 PRJDB12134_P_NODE_12315_length_253_cov_0.866667_g12180_i0 PRJDB12134 12315 253 0.866667 2.19266751 Thermicanus aegyptius 94009 Bacteria Bacteria 110 3.83e-27   NR WP_039944545.1 94009 g12180 i0 65.5 0.99604743083004 84 29 99.6 0 2 253 98 181 WP_039944545.1 peptide chain release factor N(5)-glutamine methyltransferase [Thermicanus aegyptius] diamond 252 110 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
31486290 31486290 PRJDB12134_P_NODE_12896_length_250_cov_0.864407_g12761_i0 PRJDB12134 12896 250 0.864407 2.1610175 Streptococcus thermophilus 1308 Bacteria Bacteria 75.9 8.91e-14   NR TKW62483.1 1308 g12761 i0 70.2 0.564 47 14 56.4 0 109 249 44 90 TKW62483.1 MAG: hypothetical protein DI612_08705, partial [Streptococcus thermophilus] diamond 141 75.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus thermophilus
31581096 31581096 PRJDB12134_P_NODE_11696_length_263_cov_1.394737_g11561_i0 PRJDB12134 11696 263 1.394737 3.66815831 Thermicanus sp. 2773240 Bacteria Bacteria 45.4 0.00411   NR MBE3553438.1 2773240 g11561 i0 44 0.570342205323194 50 28 57 0 261 112 166 215 MBE3553438.1 stage III sporulation protein AF [Thermicanus sp.] diamond 150 45.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus sp.
32144574 32144574 PRJDB12134_P_NODE_10978_length_274_cov_1.383085_g10843_i0 PRJDB12134 10978 274 1.383085 3.7896529 Paenibacillus 44249 Bacteria Bacteria 93.6 1.41e-21   NR WP_029518094.1 1406 g10843 i0 72.4 3.76642335766423 58 16 63.5 0 274 101 129 186 WP_029518094.1 hypothetical protein [Paenibacillus polymyxa] diamond 1032 94.4 0.991525423728813 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus polymyxa
32372060 32372060 PRJDB12134_P_NODE_14119_length_243_cov_0.917647_g13984_i0 PRJDB12134 14119 243 0.917647 2.22988221 Thermicanus aegyptius 94009 Bacteria Bacteria 137 1.34e-38   NR WP_028987499.1 94009 g13984 i0 78.8 0.987654320987654 80 17 98.8 0 3 242 52 131 WP_028987499.1 5'-methylthioadenosine/adenosylhomocysteine nucleosidase [Thermicanus aegyptius] diamond 240 137 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
32530327 32530327 PRJDB12134_P_NODE_13939_length_244_cov_0.912281_g13804_i0 PRJDB12134 13939 244 0.912281 2.22596564 Thermoanaerobacterium thermosaccharolyticum 1517 Bacteria Bacteria 80.1 1.75e-17   NR WP_164906192.1 1517 g13804 i0 65.6 1.57377049180328 64 22 78.7 0 242 51 9 72 WP_164906192.1 helix-turn-helix domain-containing protein [Thermoanaerobacterium thermosaccharolyticum] diamond 384 80.1 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Thermoanaerobacterium Thermoanaerobacterium thermosaccharolyticum
32719186 32719186 PRJDB12134_P_NODE_10860_length_276_cov_1.305419_g10725_i0 PRJDB12134 10860 276 1.305419 3.60295644 Anoxybacteroides tepidamans 265948 Bacteria Bacteria 85.9 5.48e-20   NR WP_183253673.1 265948 g10725 i0 85.5 0.597826086956522 55 8 59.8 0 276 112 4 58 WP_183253673.1 hypothetical protein [Anoxybacteroides tepidamans] diamond 165 85.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacteroides Anoxybacteroides tepidamans

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