RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA643700" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA643700 · 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
15187087 15187087 PRJNA643700_P_NODE_232492_length_252_cov_1.305419_g230936_i0 PRJNA643700 232492 252 1.305419 3.28965588 Frankia tisae 2950104 Bacteria Bacteria 154 1.16e-46   NR WP_261555556.1 2950104 g230936 i0 81.9 11.8333333333333 83 15 98.8 0 3 251 8 90 WP_261555556.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Frankia tisae] diamond 2982 154 1 Bacteria   Bacillati Actinomycetota Actinomycetes Frankiales Frankiaceae Frankia Frankia tisae
26669470 26669470 PRJNA643700_P_NODE_408161_length_165_cov_0.896552_g406605_i0 PRJNA643700 408161 165 0.896552 1.4793108 Amycolatopsis sp. NBC_ 37632 Bacteria Bacteria 41.2 0.0439   NR WP_328444702.1 2903558 g406605 i0 38.6 0.8 44 27 80 0 2 133 143 186 WP_328444702.1 ferredoxin [Amycolatopsis sp. NBC_00438] diamond 132 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Amycolatopsis Amycolatopsis sp. NBC_00438
26669471 26669471 PRJNA643700_P_NODE_418281_length_163_cov_1.289474_g416725_i0 PRJNA643700 418281 163 1.289474 2.10184262 Microbacterium sp. CSI-V 1933777 Bacteria Bacteria 39.7 0.0314   NR ONI65045.1 1933777 g416725 i0 46.3 1.50920245398773 41 22 75.5 0 153 31 24 64 ONI65045.1 hypothetical protein CSIV_10175 [Microbacterium sp. CSI-V] diamond 246 39.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. CSI-V
26860103 26860103 PRJNA643700_P_NODE_321521_length_199_cov_1.040000_g319965_i0 PRJNA643700 321521 199 1.04 2.0696 Streptomyces sp. 6-11-2 2585753 Bacteria Bacteria 42 0.0386   NR WP_141367918.1 2585753 g319965 i0 45.5 0.663316582914573 44 24 66.3 0 25 156 1 44 WP_141367918.1 GNAT family N-acetyltransferase [Streptomyces sp. 6-11-2] diamond 132 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. 6-11-2
27397507 27397507 PRJNA643700_P_NODE_233783_length_251_cov_1.420792_g232227_i0 PRJNA643700 233783 251 1.420792 3.56618792 Streptosporangiales bacterium 2604148 Bacteria Bacteria 42.7 0.0365   NR MQA79954.1 2604148 g232227 i0 38.5 0.776892430278884 65 32 71.7 2 226 47 134 195 MQA79954.1 SDR family oxidoreductase [Streptosporangiales bacterium] diamond 195 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales     Streptosporangiales bacterium
27397508 27397508 PRJNA643700_P_NODE_248323_length_241_cov_0.843750_g246767_i0 PRJNA643700 248323 241 0.84375 2.0334375 Mycobacterium sp. 1785 Bacteria Bacteria 43.5 0.0185   NR MCW2518072.1 1785 g246767 i0 31 1.9792531120332 58 40 72.2 0 222 49 234 291 MCW2518072.1 hypothetical protein [Mycobacterium sp.] diamond 477 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.
27776402 27776402 PRJNA643700_P_NODE_242004_length_245_cov_1.545918_g240448_i0 PRJNA643700 242004 245 1.545918 3.7874991 Streptomyces sp. NBC_ 1931 Bacteria Bacteria 42.4 0.0213   NR WP_406276223.1 2975674 g240448 i0 50 0.489795918367347 40 20 49 0 2 121 60 99 WP_406276223.1 Imm7 family immunity protein [Streptomyces sp. NBC_00191] diamond 120 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_00191
28407771 28407771 PRJNA643700_P_NODE_124766_length_370_cov_1.305296_g123211_i0 PRJNA643700 124766 370 1.305296 4.8295952 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 44.7 0.0232   NR MDR0990502.1 2021380 g123211 i0 40 0.445945945945946 55 33 44.6 0 29 193 121 175 MDR0990502.1 hemolysin III family protein [Propionibacteriaceae bacterium] diamond 165 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
28470983 28470983 PRJNA643700_P_NODE_187006_length_291_cov_1.070248_g185450_i0 PRJNA643700 187006 291 1.070248 3.11442168 Microtetraspora malaysiensis 161358 Bacteria Bacteria 43.1 0.0375   NR WP_387416783.1 161358 g185450 i0 41.2 0.525773195876289 51 27 52.6 1 56 208 56 103 WP_387416783.1 hypothetical protein [Microtetraspora malaysiensis] diamond 153 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Microtetraspora Microtetraspora malaysiensis
28502466 28502466 PRJNA643700_P_NODE_218227_length_263_cov_1.289720_g216671_i0 PRJNA643700 218227 263 1.28972 3.3919636 Amycolatopsis sp. DSM 11 37632 Bacteria Bacteria 44.7 0.00743   NR WP_220247423.1 2865832 g216671 i0 45.3 0.604562737642586 53 24 60.5 2 186 28 18 65 WP_220247423.1 hypothetical protein [Amycolatopsis sp. DSM 110486] diamond 159 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Amycolatopsis Amycolatopsis sp. DSM 110486
28881213 28881213 PRJNA643700_P_NODE_280528_length_220_cov_2.380117_g278972_i0 PRJNA643700 280528 220 2.380117 5.2362574 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 41.6 0.0242   NR HEX7444429.1 2201156 g278972 i0 35.8 0.722727272727273 53 34 72.3 0 218 60 19 71 HEX7444429.1 nucleotidyltransferase domain-containing protein [Acidimicrobiales bacterium] diamond 159 41.6 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
29228870 29228870 PRJNA643700_P_NODE_235549_length_250_cov_0.910448_g233993_i0 PRJNA643700 235549 250 0.910448 2.27612 Gaiellaceae bacterium 2838783 Bacteria Bacteria 40.4 0.0427   NR HUG65817.1 2838783 g233993 i0 44.7 0.564 47 26 56.4 0 102 242 19 65 HUG65817.1 CDGSH iron-sulfur domain-containing protein [Gaiellaceae bacterium] diamond 141 40.4 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
30302877 30302877 PRJNA643700_P_NODE_193732_length_284_cov_2.042553_g192176_i0 PRJNA643700 193732 284 2.042553 5.80085052 Streptomyces sviceus 285530 Bacteria Bacteria 42 0.0401   NR WP_390105955.1 285530 g192176 i0 42.9 0.591549295774648 56 30 58.1 2 71 235 34 88 WP_390105955.1 hypothetical protein [Streptomyces sviceus] diamond 168 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sviceus
30681344 30681344 PRJNA643700_P_NODE_368013_length_177_cov_1.421875_g366457_i0 PRJNA643700 368013 177 1.421875 2.51671875 Bifidobacteriaceae bacterium 2291324 Bacteria Bacteria 42.7 0.0153   NR MDR2377799.1 2291324 g366457 i0 46.5 0.728813559322034 43 23 72.9 0 166 38 48 90 MDR2377799.1 PH domain-containing protein [Bifidobacteriaceae bacterium] diamond 129 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae   Bifidobacteriaceae bacterium
31092308 31092308 PRJNA643700_P_NODE_307015_length_206_cov_1.324841_g305459_i0 PRJNA643700 307015 206 1.324841 2.72917246 Populibacterium corticicola 1812826 Bacteria Bacteria 42.7 0.0225   NR WP_377468120.1 1812826 g305459 i0 37.9 0.844660194174757 58 36 84.5 0 20 193 253 310 WP_377468120.1 carbohydrate ABC transporter permease [Populibacterium corticicola] diamond 174 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Jonesiaceae Populibacterium Populibacterium corticicola
31198940 31198940 PRJNA643700_P_NODE_185435_length_292_cov_2.300412_g183879_i0 PRJNA643700 185435 292 2.300412 6.71720304 Streptosporangiaceae 2004 Bacteria Bacteria 43.9 0.0247   NR WP_084965431.1 1088767 g183879 i0 37 0.945205479452055 46 26 44.2 1 158 30 307 352 WP_084965431.1 DUF2079 domain-containing protein [Thermoactinospora rubra] diamond 276 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Thermoactinospora Thermoactinospora rubra
31345314 31345314 PRJNA643700_P_NODE_312816_length_203_cov_1.376623_g311260_i0 PRJNA643700 312816 203 1.376623 2.79454469 Bifidobacterium indicum 1691 Bacteria Bacteria 40.4 0.0278   NR PXY80405.1 1691 g311260 i0 53.3 0.443349753694581 30 14 44.3 0 37 126 13 42 PXY80405.1 holin [Bifidobacterium indicum] diamond 90 40.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Bifidobacterium Bifidobacterium indicum
31503541 31503541 PRJNA643700_P_NODE_326796_length_196_cov_1.768707_g325240_i0 PRJNA643700 326796 196 1.768707 3.46666572 Streptomyces sp. IBSBF 239 1931 Bacteria Bacteria 41.2 0.0184   NR WP_333765313.1 2903533 g325240 i0 53.1 0.489795918367347 32 15 49 0 46 141 17 48 WP_333765313.1 hypothetical protein, partial [Streptomyces sp. IBSBF 2390] diamond 96 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. IBSBF 2390
32610467 32610467 PRJNA643700_P_NODE_391580_length_168_cov_1.310924_g390024_i0 PRJNA643700 391580 168 1.310924 2.20235232 Thermocatellispora tengchongensis 1073253 Bacteria Bacteria 42 0.00961   NR WP_386012078.1 1073253 g390024 i0 32.7 2.44642857142857 49 33 87.5 0 4 150 49 97 WP_386012078.1 hypothetical protein [Thermocatellispora tengchongensis] diamond 411 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Thermocatellispora Thermocatellispora tengchongensis

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