RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJDB3785" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJDB3785 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
19134368 19134368 PRJDB3785_S_NODE_22756_length_168_cov_1.277311_g22603_i0 PRJDB3785 22756 168 1.277311 2.14588248 root 1 Root_unresolved Root_unresolved 102 4.31e-24   NR WP_055549661.1 1967 g22603 i0 80 6.875 55 11 98.2 0 2 166 165 219 WP_055549661.1 NAD-dependent formate dehydrogenase [Streptomyces kanamyceticus] diamond 1155 102 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces kanamyceticus
26620873 26620873 PRJDB3785_S_NODE_25061_length_164_cov_0.886957_g24908_i0 PRJDB3785 25061 164 0.886957 1.45460948 Allokutzneria oryzae 1378989 Bacteria Bacteria 41.2 0.0455   NR WP_377860197.1 1378989 g24908 i0 44.2 0.786585365853659 43 23 78.7 1 2 130 426 467 WP_377860197.1 N-acetylmuramoyl-L-alanine amidase [Allokutzneria oryzae] diamond 129 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Allokutzneria Allokutzneria oryzae
26842747 26842747 PRJDB3785_S_NODE_5201_length_332_cov_1.773852_g5048_i0 PRJDB3785 5201 332 1.773852 5.88918864 Coriobacteriales bacterium 2478480 Bacteria Bacteria 50.1 2.81e-4   NR MDR0501541.1 2478480 g5048 i0 62.2 0.33433734939759 37 13 32.5 1 311 204 719 755 MDR0501541.1 RICIN domain-containing protein [Coriobacteriales bacterium] diamond 111 50.1 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales     Coriobacteriales bacterium
26969063 26969063 PRJDB3785_S_NODE_12622_length_216_cov_1.173653_g12469_i0 PRJDB3785 12622 216 1.173653 2.53509048 uncultured Nocardioidaceae bacterium 253824 Bacteria Bacteria 44.7 0.00336   NR CAA9324254.1 253824 g12469 i0 54 0.694444444444444 50 22 68.1 1 182 36 69 118 CAA9324254.1 MAG: hypothetical protein AVDCRST_MAG46-1033, partial [uncultured Nocardioidaceae bacterium] diamond 150 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae   uncultured Nocardioidaceae bacterium
27032321 27032321 PRJDB3785_S_NODE_16102_length_195_cov_1.047945_g15949_i0 PRJDB3785 16102 195 1.047945 2.04349275 Microbacteriaceae bacterium 1873462 Bacteria Bacteria 48.9 1.29e-4   NR MDQ1609496.1 1873462 g15949 i0 45.1 7.41538461538462 51 27 76.9 1 154 5 453 503 MDQ1609496.1 putative serine protease PepD [Microbacteriaceae bacterium] diamond 1446 48.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae   Microbacteriaceae bacterium
27032329 27032329 PRJDB3785_S_NODE_21322_length_173_cov_1.225806_g21169_i0 PRJDB3785 21322 173 1.225806 2.12064438 unclassified Streptomyces 2593676 Bacteria Bacteria 96.3 1.82e-21   NR WP_361216383.1 2593676 g21169 i0 71.9 4.94219653179191 57 16 98.8 0 2 172 131 187 WP_361216383.1 MULTISPECIES: S8 family peptidase [unclassified Streptomyces] diamond 855 96.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
27158564 27158564 PRJDB3785_S_NODE_25702_length_163_cov_1.087719_g25549_i0 PRJDB3785 25702 163 1.087719 1.77298197 Streptomyces longispororuber 68230 Bacteria Bacteria 39.7 0.0355   NR WP_391884628.1 68230 g25549 i0 47.1 0.938650306748466 51 25 90.2 1 15 161 2 52 WP_391884628.1 hypothetical protein [Streptomyces longispororuber] diamond 153 39.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces longispororuber
27285301 27285301 PRJDB3785_S_NODE_19603_length_179_cov_1.546154_g19450_i0 PRJDB3785 19603 179 1.546154 2.76761566 Nonomuraea typhae 2603600 Bacteria Bacteria 41.6 0.0412   NR WP_157248744.1 2603600 g19450 i0 48.7 0.653631284916201 39 19 63.7 1 158 45 366 404 WP_157248744.1 hypothetical protein [Nonomuraea typhae] diamond 117 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea typhae
27942655 27942655 PRJDB3785_S_NODE_24325_length_165_cov_1.318966_g24172_i0 PRJDB3785 24325 165 1.318966 2.1762939 Streptosporangiales 85012 Bacteria Bacteria 80.5 2.54e-16   NR WP_344589831.1 115336 g24172 i0 60 12 55 22 100 0 165 1 108 162 WP_344589831.1 SDR family oxidoreductase [Actinomadura vinacea] diamond 1980 80.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinomadura Actinomadura vinacea
28200817 28200817 PRJDB3785_S_NODE_10966_length_229_cov_1.866667_g10813_i0 PRJDB3785 10966 229 1.866667 4.27466743 Microbacteriaceae bacterium 1873462 Bacteria Bacteria 80.9 1.23e-16   NR MBX9718074.1 1873462 g10813 i0 51 1.31004366812227 100 25 99.6 3 229 2 10 109 MBX9718074.1 30S ribosomal protein S17 [Microbacteriaceae bacterium] diamond 300 80.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae   Microbacteriaceae bacterium
28605641 28605641 PRJDB3785_S_NODE_247_length_1493_cov_2.561634_g221_i0 PRJDB3785 247 1493 2.561634 38.24519562 Bacteria 2 Bacteria Bacteria 274 1.68e-82   NR WP_345575331.1 638574 g221 i0 36.1 4.20964501004689 415 244 82.4 9 1268 39 72 470 WP_345575331.1 vanadium-dependent haloperoxidase [Nonomuraea rosea] diamond 6285 275 0.996363636363636 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea rosea
28832451 28832451 PRJDB3785_S_NODE_24688_length_165_cov_0.879310_g24535_i0 PRJDB3785 24688 165 0.87931 1.4508615 Microbacterium sp. P 51671 Bacteria Bacteria 52 6.87e-6   NR WP_378853890.1 3366260 g24535 i0 42.6 0.981818181818182 54 31 98.2 0 3 164 366 419 WP_378853890.1 glutamine synthetase family protein [Microbacterium sp. P02] diamond 162 52 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. P02
29369332 29369332 PRJDB3785_S_NODE_2049_length_553_cov_1.982143_g1903_i0 PRJDB3785 2049 553 1.982143 10.96125079 Dactylosporangium darangshiense 579108 Bacteria Bacteria 47.4 0.00971   NR WP_345128959.1 579108 g1903 i0 32.1 0.5750452079566 106 58 57.5 3 178 495 30 121 WP_345128959.1 hypothetical protein [Dactylosporangium darangshiense] diamond 318 47.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Dactylosporangium Dactylosporangium darangshiense
29463614 29463614 PRJDB3785_S_NODE_23990_length_166_cov_0.871795_g23837_i0 PRJDB3785 23990 166 0.871795 1.4471797 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 50.1 3.44e-5   NR HEX6468256.1 2339230 g23837 i0 43.5 1.75301204819277 46 26 83.1 0 16 153 264 309 HEX6468256.1 rhodanese-like domain-containing protein [Streptosporangiaceae bacterium] diamond 291 50.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
29584120 29584120 PRJDB3785_S_NODE_19450_length_180_cov_1.122137_g19297_i0 PRJDB3785 19450 180 1.122137 2.0198466 Bacteria 2 Bacteria Bacteria 55.8 3.87e-7   NR HNJ98774.1 2497619 g19297 i0 43.6 2.68333333333333 55 31 91.7 0 16 180 388 442 HNJ98774.1 M20/M25/M40 family metallo-hydrolase [Ilumatobacteraceae bacterium] diamond 483 55.8 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
29773718 29773718 PRJDB3785_S_NODE_16271_length_194_cov_1.282759_g16118_i0 PRJDB3785 16271 194 1.282759 2.48855246 Nocardiopsidaceae 83676 Bacteria Bacteria 51.6 1.44e-5   NR WP_248591164.1 53522 g16118 i0 53.8 14.9845360824742 52 24 80.4 0 5 160 467 518 WP_248591164.1 GMC family oxidoreductase [Thermobifida alba] diamond 2907 52 0.992307692307692 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Nocardiopsidaceae Thermobifida Thermobifida alba
29874569 29874569 PRJDB3785_S_NODE_21591_length_172_cov_1.243902_g21438_i0 PRJDB3785 21591 172 1.243902 2.13951144 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 44.3 0.00419   NR HTQ67506.1 2586742 g21438 i0 51.3 0.680232558139535 39 19 68 0 37 153 362 400 HTQ67506.1 FG-GAP repeat protein [Solirubrobacteraceae bacterium] diamond 117 44.3 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
31137981 31137981 PRJDB3785_S_NODE_10835_length_230_cov_1.729282_g10682_i0 PRJDB3785 10835 230 1.729282 3.9773486 Kocuria sp. ZOR 1871328 Bacteria Bacteria 97.4 4.74e-22   NR WP_047687975.1 1339234 g10682 i0 56.9 1.87826086956522 72 31 93.9 0 217 2 30 101 WP_047687975.1 NAD(P)-dependent alcohol dehydrogenase [Kocuria sp. ZOR0020] diamond 432 97.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria sp. ZOR0020
31264766 31264766 PRJDB3785_S_NODE_27315_length_161_cov_0.910714_g27162_i0 PRJDB3785 27315 161 0.910714 1.46624954 Streptomyces brasiliensis 1954 Bacteria Bacteria 51.6 9.1e-6   NR WP_229839936.1 1954 g27162 i0 53.5 1.69565217391304 43 18 76.4 1 35 157 144 186 WP_229839936.1 S8 family serine peptidase [Streptomyces brasiliensis] diamond 273 51.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces brasiliensis
31359799 31359799 PRJDB3785_S_NODE_8316_length_261_cov_1.283019_g8163_i0 PRJDB3785 8316 261 1.283019 3.34867959 Piscicoccus intestinalis 746033 Bacteria Bacteria 43.5 0.023   NR WP_068430052.1 746033 g8163 i0 46.3 0.471264367816092 41 22 47.1 0 59 181 205 245 WP_068430052.1 universal stress protein [Piscicoccus intestinalis] diamond 123 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermatophilaceae Piscicoccus Piscicoccus intestinalis
31865493 31865493 PRJDB3785_S_NODE_23357_length_167_cov_0.864407_g23204_i0 PRJDB3785 23357 167 0.864407 1.44355969 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 52.8 3.8e-6   NR MBM3773112.1 2080302 g23204 i0 49.1 1.02395209580838 57 26 97 2 165 4 268 324 MBM3773112.1 hypothetical protein [Acidimicrobiia bacterium] diamond 171 52.8 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
31928936 31928936 PRJDB3785_S_NODE_7517_length_274_cov_1.240000_g7364_i0 PRJDB3785 7517 274 1.24 3.3976 Mycobacterium numidiamassiliense 1841861 Bacteria Bacteria 86.3 2.2e-17   NR WP_217348935.1 1841861 g7364 i0 47.3 0.996350364963504 91 48 99.6 0 274 2 305 395 WP_217348935.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Mycobacterium numidiamassiliense] diamond 273 86.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium numidiamassiliense

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