RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJEB12982" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJEB12982 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
11189020 11189020 PRJEB12982_P_NODE_18969_length_164_cov_0.886957_g18806_i0 PRJEB12982 18969 164 0.886957 1.45460948 Nocardiopsis composta 157465 Bacteria Bacteria 96.3 4.31e-22   NR WP_184390384.1 157465 g18806 i0 97.8 0.823170731707317 45 1 82.3 0 28 162 1 45 WP_184390384.1 YbgA family protein [Nocardiopsis composta] diamond 135 96.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Nocardiopsidaceae Nocardiopsis Nocardiopsis composta
15323160 15323160 PRJEB12982_P_NODE_2093_length_538_cov_2.049080_g1934_i0 PRJEB12982 2093 538 2.04908 11.0240504 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 218 8.8e-70   NR MCP3885490.1 2021380 g1934 i0 71.8 0.830855018587361 149 42 83.1 0 504 58 3 151 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 447 218 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
17872551 17872551 PRJEB12982_P_NODE_16955_length_167_cov_0.864407_g16792_i0 PRJEB12982 16955 167 0.864407 1.44355969 Miltoncostaeales bacterium 3022881 Bacteria Bacteria 115 4.28e-29   NR HRC07934.1 3022881 g16792 i0 94.5 0.988023952095808 55 3 98.8 0 167 3 102 156 HRC07934.1 hypothetical protein [Miltoncostaeales bacterium] diamond 165 115 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Miltoncostaeales     Miltoncostaeales bacterium
26811557 26811557 PRJEB12982_P_NODE_7081_length_273_cov_1.366071_g6918_i0 PRJEB12982 7081 273 1.366071 3.72937383 Actinomycetota bacterium 2900548 Bacteria Bacteria 47.4 7.87e-5   NR MBS1889943.1 2900548 g6918 i0 66.7 0.395604395604396 36 12 39.6 0 162 269 2 37 MBS1889943.1 hypothetical protein [Actinomycetota bacterium] diamond 108 47.4 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
26969660 26969660 PRJEB12982_P_NODE_9862_length_225_cov_1.386364_g9699_i0 PRJEB12982 9862 225 1.386364 3.119319 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 88.6 3.07e-20   NR MCP3885490.1 2021380 g9699 i0 65.7 0.893333333333333 67 23 89.3 0 2 202 85 151 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 201 88.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
28359375 28359375 PRJEB12982_P_NODE_19566_length_163_cov_0.894737_g19403_i0 PRJEB12982 19566 163 0.894737 1.45842131 Lawsonella 1847725 Bacteria Bacteria 111 3.3799999999999993e-28   NR WP_290595444.1 1847725 g19403 i0 100 0.993865030674847 54 0 99.4 0 163 2 202 255 WP_290595444.1 MULTISPECIES: GIY-YIG nuclease family protein [Lawsonella] diamond 162 111 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
28769910 28769910 PRJEB12982_P_NODE_14727_length_181_cov_1.159091_g14564_i0 PRJEB12982 14727 181 1.159091 2.09795471 Bogoriella caseilytica 56055 Bacteria Bacteria 42 0.0302   NR WP_123304230.1 56055 g14564 i0 36 0.828729281767956 50 32 82.9 0 16 165 182 231 WP_123304230.1 hypothetical protein [Bogoriella caseilytica] diamond 150 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Bogoriellaceae Bogoriella Bogoriella caseilytica
30437712 30437712 PRJEB12982_P_NODE_20393_length_162_cov_0.902655_g20230_i0 PRJEB12982 20393 162 0.902655 1.4623011 Blastococcus 38501 Bacteria Bacteria 51.2 1.24e-5   NR WP_208092257.1 1564164 g20230 i0 66.7 2.46296296296296 36 12 66.7 0 53 160 40 75 WP_208092257.1 carboxylesterase/lipase family protein [Blastococcus xanthinilyticus] diamond 399 51.6 0.992248062015504 Bacteria   Bacillati Actinomycetota Actinomycetes Geodermatophilales Geodermatophilaceae Blastococcus Blastococcus xanthinilyticus
31107166 31107166 PRJEB12982_P_NODE_21375_length_161_cov_0.910714_g21212_i0 PRJEB12982 21375 161 0.910714 1.46624954 Coriobacteriales bacterium 2478480 Bacteria Bacteria 52.4 4.82e-6   NR MDR3315660.1 2478480 g21212 i0 48.8 2.16149068322981 41 21 76.4 0 6 128 450 490 MDR3315660.1 RICIN domain-containing protein [Coriobacteriales bacterium] diamond 348 52.4 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales     Coriobacteriales bacterium
31290506 31290506 PRJEB12982_P_NODE_20055_length_162_cov_1.805310_g19892_i0 PRJEB12982 20055 162 1.80531 2.9246022 Bacteria 2 Bacteria Bacteria 50.1 9.85e-6   NR MDH3605859.1 2080302 g19892 i0 41.5 2.81481481481481 53 31 98.1 0 160 2 1 53 MDH3605859.1 SRPBCC family protein [Acidimicrobiia bacterium] diamond 456 50.1 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
31455180 31455180 PRJEB12982_P_NODE_8576_length_245_cov_0.923469_g8413_i0 PRJEB12982 8576 245 0.923469 2.26249905 Nocardia transvalensis 37333 Bacteria Bacteria 40.8 0.0374   NR WP_195111351.1 37333 g8413 i0 46.5 0.52653061224489806 43 19 52.7 1 5 133 42 80 WP_195111351.1 hypothetical protein [Nocardia transvalensis] diamond 129 40.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia transvalensis
31613252 31613252 PRJEB12982_P_NODE_12116_length_202_cov_0.888889_g11953_i0 PRJEB12982 12116 202 0.888889 1.79555578 Glycomyces amatae 2881355 Bacteria Bacteria 42 0.0421   NR WP_230601727.1 2881355 g11953 i0 35.4 0.965346534653465 65 40 96.5 1 4 198 285 347 WP_230601727.1 SCO7613 C-terminal domain-containing membrane protein [Glycomyces amatae] diamond 195 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Glycomycetales Glycomycetaceae Glycomyces Glycomyces amatae
32397993 32397993 PRJEB12982_P_NODE_15139_length_178_cov_1.186047_g14976_i0 PRJEB12982 15139 178 1.186047 2.11116366 Actinomycetes 1760 Bacteria Bacteria 54.7 9.3e-7   NR WP_274044837.1 1384038 g14976 i0 61 2.29213483146067 41 15 69.1 1 132 10 244 283 WP_274044837.1 C40 family peptidase [Streptomyces iconiensis] diamond 408 55.1 0.992740471869329 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces iconiensis

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