RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA235310" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA235310 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
9984734 9984734 PRJNA235310_P_NODE_6068_length_163_cov_1.368421_g6042_i0 PRJNA235310 6068 163 1.368421 2.23052623 Ilumatobacter sp. 1967498 Bacteria Bacteria 95.5 1.7100000000000003e-21   NR NKB42081.1 1967498 g6042 i0 85.2 2.98159509202454 54 8 99.4 0 1 162 149 202 NKB42081.1 IS3 family transposase [Ilumatobacter sp.] diamond 486 95.5 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae Ilumatobacter Ilumatobacter sp.
16944614 16944614 PRJNA235310_P_NODE_1534_length_325_cov_29.094203_g1508_i0 PRJNA235310 1534 325 29.094203 94.55615975 Profundirhabdus halotolerans 2604685 Bacteria Bacteria 135 3.35e-39   NR MTV28656.1 2604685 g1508 i0 98.6 0.646153846153846 70 1 64.6 0 273 64 4 73 MTV28656.1 hypothetical protein [Profundirhabdus halotolerans] diamond 210 135 1 Bacteria   Bacillati Actinomycetota Nitriliruptoria Nitriliruptorales Nitriliruptoraceae Profundirhabdus Profundirhabdus halotolerans
26965140 26965140 PRJNA235310_P_NODE_642_length_484_cov_2.664368_g616_i0 PRJNA235310 642 484 2.664368 12.89554112 Streptomyces 1883 Bacteria Bacteria 195 1.21e-58   NR WP_366480401.1 3154643 g616 i0 70.5 12.7995867768595 129 35 80 2 1 387 205 330 WP_366480401.1 zinc metalloprotease [Streptomyces sp. NPDC051211] diamond 6195 196 0.994897959183674 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC051211
27484809 27484809 PRJNA235310_P_NODE_3263_length_210_cov_0.968944_g3237_i0 PRJNA235310 3263 210 0.968944 2.0347824 Solirubrobacter ginsenosidimutans 490573 Bacteria Bacteria 42 0.0446   NR WP_270045897.1 490573 g3237 i0 30.4 0.8 56 39 80 0 8 175 111 166 WP_270045897.1 cupredoxin domain-containing protein [Solirubrobacter ginsenosidimutans] diamond 168 42 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae Solirubrobacter Solirubrobacter ginsenosidimutans
28653064 28653064 PRJNA235310_P_NODE_2707_length_232_cov_1.278689_g2681_i0 PRJNA235310 2707 232 1.278689 2.96655848 Actinomycetota bacterium 2900548 Bacteria Bacteria 58.5 2.04e-8   NR MDP9168834.1 2900548 g2681 i0 38.2 0.982758620689655 76 44 97 2 231 7 30 103 MDP9168834.1 hypothetical protein [Actinomycetota bacterium] diamond 228 58.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28873990 28873990 PRJNA235310_P_NODE_5988_length_164_cov_0.904348_g5962_i0 PRJNA235310 5988 164 0.904348 1.48313072 Rhodococcus sp. SC4 1793160 Bacteria Bacteria 83.6 2.1e-18   NR KXF53051.1 1793160 g5962 i0 69.8 0.969512195121951 53 16 97 0 159 1 88 140 KXF53051.1 hypothetical protein AXA44_45685 [Rhodococcus sp. SC4] diamond 159 83.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus sp. SC4
29316066 29316066 PRJNA235310_P_NODE_2189_length_264_cov_1.511628_g2163_i0 PRJNA235310 2189 264 1.511628 3.99069792 Profundirhabdus halotolerans 2604685 Bacteria Bacteria 127 3.64e-36   NR MTV29025.1 2604685 g2163 i0 100 0.727272727272727 64 0 72.7 0 3 194 26 89 MTV29025.1 hypothetical protein [Profundirhabdus halotolerans] diamond 192 127 1 Bacteria   Bacillati Actinomycetota Nitriliruptoria Nitriliruptorales Nitriliruptoraceae Profundirhabdus Profundirhabdus halotolerans
29491652 29491652 PRJNA235310_P_NODE_6210_length_163_cov_0.912281_g6184_i0 PRJNA235310 6210 163 0.912281 1.48701803 Microbacteriaceae 85023 Bacteria Bacteria 94.4 2.32e-22   NR TPX00517.1 472059 g6184 i0 86.8 2.92638036809816 53 7 97.5 0 161 3 143 195 TPX00517.1 ATP-binding protein, partial [Schumannella luteola] diamond 477 94.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Schumannella Schumannella luteola
29617645 29617645 PRJNA235310_P_NODE_5670_length_165_cov_1.344828_g5644_i0 PRJNA235310 5670 165 1.344828 2.2189662 root 1 Root_unresolved Root_unresolved 42.7 0.0134   NR HEX8067016.1 2732252 g5644 i0 33.3 3.92727272727273 54 36 98.2 0 4 165 179 232 HEX8067016.1 hypothetical protein [Thermoleophilaceae bacterium] diamond 648 43.1 0.990719257540603 Bacteria   Bacillati Actinomycetota Thermoleophilia Thermoleophilales Thermoleophilaceae   Thermoleophilaceae bacterium
29884614 29884614 PRJNA235310_P_NODE_5891_length_164_cov_1.295652_g5865_i0 PRJNA235310 5891 164 1.295652 2.12486928 Actinomadura parmotrematis 2864039 Bacteria Bacteria 93.2 1.8899999999999998e-20   NR WP_220167124.1 2864039 g5865 i0 77.8 0.98780487804878 54 12 98.8 0 163 2 303 356 WP_220167124.1 M28 family peptidase [Actinomadura parmotrematis] diamond 162 93.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinomadura Actinomadura parmotrematis
30105477 30105477 PRJNA235310_P_NODE_3852_length_192_cov_1.958042_g3826_i0 PRJNA235310 3852 192 1.958042 3.7594406399999998 Nonomuraea maritima 683260 Bacteria Bacteria 41.2 0.0482   NR WP_090770336.1 683260 g3826 i0 38.7 0.96875 62 31 90.6 2 175 2 47 105 WP_090770336.1 C40 family peptidase [Nonomuraea maritima] diamond 186 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea maritima
30168586 30168586 PRJNA235310_P_NODE_5712_length_165_cov_0.896552_g5686_i0 PRJNA235310 5712 165 0.896552 1.4793108 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 55.1 4.97e-7   NR HLG92195.1 2201156 g5686 i0 55.6 2.65454545454545 45 17 81.8 1 14 148 232 273 HLG92195.1 aminoglycoside phosphotransferase family protein [Acidimicrobiales bacterium] diamond 438 55.1 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
31021894 31021894 PRJNA235310_P_NODE_2235_length_260_cov_1.473934_g2209_i0 PRJNA235310 2235 260 1.473934 3.8322284 Streptomyces brevispora 887462 Bacteria Bacteria 42.4 0.037   NR WP_329615100.1 887462 g2209 i0 44.4 0.519230769230769 45 25 51.9 0 138 4 27 71 WP_329615100.1 peptidase inhibitor family I36 protein [Streptomyces brevispora] diamond 135 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces brevispora
31228979 31228979 PRJNA235310_P_NODE_4115_length_185_cov_2.073529_g4089_i0 PRJNA235310 4115 185 2.073529 3.83602865 Actinomycetes 1760 Bacteria Bacteria 60.8 6.96e-9   NR WP_167171912.1 349934 g4089 i0 66.7 2.09189189189189 42 14 68.1 0 38 163 167 208 WP_167171912.1 phosphoenolpyruvate carboxykinase (GTP) [Brooklawnia cerclae] diamond 387 60.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Brooklawnia Brooklawnia cerclae
31496299 31496299 PRJNA235310_P_NODE_6376_length_162_cov_0.920354_g6350_i0 PRJNA235310 6376 162 0.920354 1.49097348 Corynebacterium urealyticum 43771 Bacteria Bacteria 74.7 1.98e-14   NR PZP00953.1 43771 g6350 i0 60.7 2.07407407407407 56 20 100 1 162 1 58 113 PZP00953.1 MAG: N-acetyl-1-D-myo-inositol-2-amino-2-deoxy-alpha-D-glucopyranoside deacetylase, partial [Corynebacterium urealyticum] diamond 336 74.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium urealyticum
31514131 31514131 PRJNA235310_P_NODE_2036_length_276_cov_0.894273_g2010_i0 PRJNA235310 2036 276 0.894273 2.46819348 Actinomycetes 1760 Bacteria Bacteria 46.2 0.00321   NR WP_012835639.1 2054 g2010 i0 34.5 1.14130434782609 58 38 63 0 63 236 423 480 WP_012835639.1 cytochrome P450 [Gordonia bronchialis] diamond 315 46.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia Gordonia bronchialis
31608763 31608763 PRJNA235310_P_NODE_1676_length_310_cov_1.057471_g1650_i0 PRJNA235310 1676 310 1.057471 3.2781601 Geodermatophilaceae 85030 Bacteria Bacteria 97.4 2.29e-21   NR HYX94679.1 52020 g1650 i0 53.8 6.18387096774194 93 41 90 1 3 281 241 331 HYX94679.1 4-hydroxyphenylpyruvate dioxygenase [Geodermatophilus sp.] diamond 1917 97.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Geodermatophilales Geodermatophilaceae Geodermatophilus Geodermatophilus sp.
31780612 31780612 PRJNA235310_P_NODE_5177_length_168_cov_0.873950_g5151_i0 PRJNA235310 5177 168 0.87395 1.468236 Nocardioides 1839 Bacteria Bacteria 83.2 5.62e-17   NR WP_056862838.1 1839 g5151 i0 81.1 8.625 53 10 94.6 0 3 161 317 369 WP_056862838.1 MULTISPECIES: S8 family peptidase [Nocardioides] diamond 1449 83.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides  
32540343 32540343 PRJNA235310_P_NODE_2079_length_272_cov_1.394619_g2053_i0 PRJNA235310 2079 272 1.394619 3.79336368 Profundirhabdus halotolerans 2604685 Bacteria Bacteria 70.9 1.13e-13   NR MTV29340.1 2604685 g2053 i0 100 0.375 34 0 37.5 0 1 102 62 95 MTV29340.1 HIG1 domain-containing protein [Profundirhabdus halotolerans] diamond 102 70.9 1 Bacteria   Bacillati Actinomycetota Nitriliruptoria Nitriliruptorales Nitriliruptoraceae Profundirhabdus Profundirhabdus halotolerans
32872715 32872715 PRJNA235310_P_NODE_2580_length_239_cov_1.915789_g2554_i0 PRJNA235310 2580 239 1.915789 4.57873571 PVC group 1783257 Bacteria Bacteria 46.2 0.00206   NR MCP3937591.1 1883427 g2554 i0 34.7 1.84518828451883 75 49 94.1 0 9 233 168 242 MCP3937591.1 cadherin repeat domain-containing protein [Actinomycetes bacterium] diamond 441 46.6 0.991416309012876 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes 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);;