RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA596867" 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

  • PRJNA596867 · 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
8221197 8221197 PRJNA596867_P_NODE_13927_length_244_cov_0.900585_g13852_i0 PRJNA596867 13927 244 0.900585 2.1974274 uncultured Lawsonella sp. 1847727 Bacteria Bacteria 160 3.59e-45   NR WP_298576765.1 1847727 g13852 i0 96.3 0.995901639344262 81 3 99.6 0 244 2 365 445 WP_298576765.1 type I glutamate--ammonia ligase [uncultured Lawsonella sp.] diamond 243 160 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella uncultured Lawsonella sp.
15870723 15870723 PRJNA596867_P_NODE_13273_length_246_cov_0.890173_g13198_i0 PRJNA596867 13273 246 0.890173 2.18982558 Parenemella sanctibonifatiensis 2016505 Bacteria Bacteria 168 3.64e-48   NR WP_094454757.1 2016505 g13198 i0 100 1 82 0 100 0 246 1 166 247 WP_094454757.1 class II 3-deoxy-7-phosphoheptulonate synthase [Parenemella sanctibonifatiensis] diamond 246 168 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Parenemella Parenemella sanctibonifatiensis
28261574 28261574 PRJNA596867_P_NODE_13806_length_244_cov_3.280702_g13731_i0 PRJNA596867 13806 244 3.280702 8.00491288 Lawsonella 1847725 Bacteria Bacteria 159 1.22e-43   NR WP_303678668.1 1528099 g13731 i0 100 1.99180327868852 81 0 99.6 0 2 244 283 363 WP_303678668.1 peptidoglycan D,D-transpeptidase FtsI family protein [Lawsonella clevelandensis] diamond 486 159 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
28690630 28690630 PRJNA596867_P_NODE_11767_length_250_cov_0.870056_g11692_i0 PRJNA596867 11767 250 0.870056 2.17514 Actinomyces naeslundii 1655 Bacteria Bacteria 141 2.25e-40   NR WP_076080639.1 1655 g11692 i0 95.8 0.852 71 3 85.2 0 248 36 124 194 WP_076080639.1 hypothetical protein [Actinomyces naeslundii] diamond 213 141 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces naeslundii
29921993 29921993 PRJNA596867_P_NODE_9451_length_273_cov_1.510000_g9376_i0 PRJNA596867 9451 273 1.51 4.1223 Mycobacterium sp. 11 1785 Bacteria Bacteria 44.7 0.00998   NR OBA62656.1 1834067 g9376 i0 47.2 0.582417582417582 53 26 58.2 2 182 24 120 170 OBA62656.1 hypothetical protein A5647_07230 [Mycobacterium sp. 1100029.7] diamond 159 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp. 1100029.7
29985065 29985065 PRJNA596867_P_NODE_10031_length_266_cov_1.595855_g9956_i0 PRJNA596867 10031 266 1.595855 4.2449743 Aurantimicrobium sp. 1930784 Bacteria Bacteria 148 8.930000000000001e-44   NR WP_332627286.1 1930784 g9956 i0 91.1 0.890977443609023 79 7 89.1 0 265 29 68 146 WP_332627286.1 hypothetical protein [Aurantimicrobium sp.] diamond 237 148 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aurantimicrobium Aurantimicrobium sp.
30333063 30333063 PRJNA596867_P_NODE_14132_length_244_cov_0.900585_g14057_i0 PRJNA596867 14132 244 0.900585 2.1974274 uncultured Pseudonocardia sp. 211455 Bacteria Bacteria 43.5 0.0192   NR WP_298800451.1 211455 g14057 i0 38.6 0.700819672131147 57 29 67.6 2 176 12 359 411 WP_298800451.1 helicase associated domain-containing protein [uncultured Pseudonocardia sp.] diamond 171 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia uncultured Pseudonocardia sp.
30522119 30522119 PRJNA596867_P_NODE_12233_length_249_cov_0.875000_g12158_i0 PRJNA596867 12233 249 0.875 2.17875 Streptomyces sp. NPDC 1931 Bacteria Bacteria 42 0.0415   NR WP_383750080.1 3346213 g12158 i0 34.6 0.626506024096386 52 34 62.7 0 5 160 92 143 WP_383750080.1 hypothetical protein [Streptomyces sp. NPDC057689] diamond 156 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC057689
30711690 30711690 PRJNA596867_P_NODE_10874_length_256_cov_1.502732_g10799_i0 PRJNA596867 10874 256 1.502732 3.84699392 Streptomyces lydicus 47763 Bacteria Bacteria 43.9 0.017   NR MDC7341148.1 47763 g10799 i0 45.5 0.64453125 55 25 62.1 3 67 225 370 421 MDC7341148.1 MMPL family transporter [Streptomyces lydicus] diamond 165 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces lydicus
31027853 31027853 PRJNA596867_P_NODE_12135_length_249_cov_0.875000_g12060_i0 PRJNA596867 12135 249 0.875 2.17875 Nocardioides sp. GXZ 35761 Bacteria Bacteria 42.4 0.0257   NR WP_340539027.1 3136018 g12060 i0 33.3 0.903614457831325 75 46 89.2 2 245 24 38 109 WP_340539027.1 hypothetical protein [Nocardioides sp. GXZ039] diamond 225 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp. GXZ039
31153685 31153685 PRJNA596867_P_NODE_11975_length_249_cov_1.710227_g11900_i0 PRJNA596867 11975 249 1.710227 4.25846523 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 45.1 0.00614   NR HEY5988987.1 2339230 g11900 i0 32.5 1.92771084337349 80 47 91.6 2 243 16 289 365 HEY5988987.1 S9 family peptidase [Streptosporangiaceae bacterium] diamond 480 45.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
32039733 32039733 PRJNA596867_P_NODE_10078_length_266_cov_0.953368_g10003_i0 PRJNA596867 10078 266 0.953368 2.53595888 Baekduia sp. 2600305 Bacteria Bacteria 43.9 0.0176   NR HEY6758934.1 2600305 g10003 i0 46 0.710526315789474 63 32 69.9 2 71 256 123 184 HEY6758934.1 DMT family transporter [Baekduia sp.] diamond 189 43.9 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Baekduiaceae Baekduia Baekduia sp.
32197926 32197926 PRJNA596867_P_NODE_13558_length_245_cov_0.895349_g13483_i0 PRJNA596867 13558 245 0.895349 2.19360505 Rhodococcus zopfii 43772 Bacteria Bacteria 47 0.00116   NR WP_238072421.1 43772 g13483 i0 39.4 1.61632653061224 66 40 80.8 0 22 219 164 229 WP_238072421.1 2Fe-2S iron-sulfur cluster-binding protein [Rhodococcus zopfii] diamond 396 47 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus zopfii

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