RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1145574" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1145574 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
1033234 1033234 PRJNA1145574_P_NODE_11201_length_253_cov_0.866667_g11017_i0 PRJNA1145574 11201 253 0.866667 2.19266751 Gardnerella 2701 Bacteria Bacteria 462 8.95e-126   NTclustered gi|2235497516|gb|CP083175.1| 2702 g11017 i0 99.605 20.5177865612648 253 1 100 0 1 253 157968 158220 Gardnerella vaginalis strain JNFY4 chromosome, complete genome blastn 5191 462 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Gardnerella Gardnerella vaginalis
5391854 5391854 PRJNA1145574_P_NODE_13305_length_247_cov_0.896552_g13121_i0 PRJNA1145574 13305 247 0.896552 2.21448344 Actinocatenispora sera 390989 Bacteria Bacteria 134 7.750000000000001e-27   NTclustered gi|2020954569|dbj|AP023354.1| 390989 g13121 i0 97.436 36.9433198380567 78 2 32 0 88 165 3634271 3634348 Actinocatenispora sera NBRC 101916 DNA, complete genome blastn 9125 134 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Actinocatenispora Actinocatenispora sera
6136124 6136124 PRJNA1145574_P_NODE_13445_length_246_cov_0.901734_g13261_i0 PRJNA1145574 13445 246 0.901734 2.21826564 Microbacterium 33882 Bacteria Bacteria 433 6.79e-117   NTclustered gi|2488004109|gb|CP121699.1| 2033 g13261 i0 98.374 178.036585365854 246 4 100 0 1 246 4256 4011 Microbacterium testaceum strain HW4 chromosome, complete genome blastn 43797 433 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium testaceum
7941680 7941680 PRJNA1145574_P_NODE_12047_length_250_cov_0.881356_g11863_i0 PRJNA1145574 12047 250 0.881356 2.20339 Gardnerella swidsinskii 2792979 Bacteria Bacteria 457 4.1099999999999985e-124   NTclustered gi|2911086594|gb|CP180513.1| 2792979 g11863 i0 99.6 13.048 250 1 100 0 1 250 156200 156449 Gardnerella swidsinskii strain Marseille-Q9222 chromosome blastn 3262 457 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Gardnerella Gardnerella swidsinskii
9961411 9961411 PRJNA1145574_P_NODE_11928_length_250_cov_1.604520_g11744_i0 PRJNA1145574 11928 250 1.60452 4.0113 Micrococcales 85006 Bacteria Bacteria 279 9.54e-71   NTclustered gi|908724324|gb|CP012070.1| 1658671 g11744 i0 86.8 12.02 250 33 100 0 1 250 503377 503128 Arsenicicoccus sp. oral taxon 190, complete genome blastn 3005 279 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Arsenicicoccus Arsenicicoccus sp. oral taxon 190
13042300 13042300 PRJNA1145574_P_NODE_11151_length_253_cov_0.866667_g10967_i0 PRJNA1145574 11151 253 0.866667 2.19266751 Gardnerella swidsinskii 2792979 Bacteria Bacteria 468 1.92e-127   NTclustered gi|2235499256|gb|CP083176.1| 2792979 g10967 i0 100 13.0237154150198 253 0 100 0 1 253 250065 249813 Gardnerella swidsinskii strain JNFY3 chromosome, complete genome blastn 3295 468 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Gardnerella Gardnerella swidsinskii
13042333 13042333 PRJNA1145574_P_NODE_13631_length_246_cov_0.861272_g13447_i0 PRJNA1145574 13631 246 0.861272 2.11872912 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 200 7.5e-47   NTclustered gi|2874254051|emb|OY970375.1| 2497619 g13447 i0 86.022 0.75609756097561 186 26 76 0 57 242 1970495 1970680 MAG: Ilumatobacteraceae bacterium isolate MFD04651.bin.1.23 genome assembly, chromosome: 1 blastn 186 200 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
13786621 13786621 PRJNA1145574_P_NODE_11031_length_253_cov_0.866667_g10847_i0 PRJNA1145574 11031 253 0.866667 2.19266751 Gardnerella 2701 Bacteria Bacteria 468 1.92e-127   NTclustered gi|1419371358|gb|CP029984.1| 2792978 g10847 i0 100 4 253 0 100 0 1 253 353505 353253 Gardnerella leopoldii strain UGent 06.41 chromosome blastn 1012 468 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Gardnerella Gardnerella leopoldii
15591536 15591536 PRJNA1145574_P_NODE_13033_length_247_cov_0.896552_g12849_i0 PRJNA1145574 13033 247 0.896552 2.21448344 Actinobacteria bacterium IMCC26077 1848755 Bacteria Bacteria 435 1.9e-117   NTclustered gi|1147748924|gb|CP015606.1| 1848755 g12849 i0 98.381 1 247 4 100 0 1 247 1506990 1507236 Actinobacteria bacterium IMCC26077, complete genome blastn 247 435 1 Bacteria   Bacillati Actinomycetota         Actinobacteria bacterium IMCC26077
16335699 16335699 PRJNA1145574_P_NODE_13413_length_246_cov_0.901734_g13229_i0 PRJNA1145574 13413 246 0.901734 2.21826564 Cutibacterium 1912216 Bacteria Bacteria 455 1.4500000000000002e-123   NTclustered gi|966542502|gb|CP012354.1| 1747 g13229 i0 100 51 246 0 100 0 1 246 1884137 1883892 Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome blastn 12546 455 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
16865784 16865784 PRJNA1145574_P_NODE_13094_length_247_cov_0.896552_g12910_i0 PRJNA1145574 13094 247 0.896552 2.21448344 Jatrophihabitans cynanchi 2944128 Bacteria Bacteria 89.8 1.7e-13   NTclustered gi|2416453026|gb|CP097463.1| 2944128 g12910 i0 82.828 0.40080971659919 99 17 40 0 2 100 1161706 1161608 Jatrophihabitans cynanchi strain SB3-54 chromosome, complete genome blastn 99 89.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Jatrophihabitantales Jatrophihabitantaceae Jatrophihabitans Jatrophihabitans cynanchi
18140386 18140386 PRJNA1145574_P_NODE_14975_length_242_cov_0.863905_g14791_i0 PRJNA1145574 14975 242 0.863905 2.0906501 Gardnerella swidsinskii 2792979 Bacteria Bacteria 431 2.4e-116   NTclustered gi|1132489173|gb|CP019058.1| 2792979 g14791 i0 98.76 11.599173553719 242 3 100 0 1 242 1245319 1245078 Gardnerella swidsinskii strain GV37 chromosome, complete genome blastn 2807 431 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Gardnerella Gardnerella swidsinskii
21965540 21965540 PRJNA1145574_P_NODE_8958_length_287_cov_1.457944_g8774_i0 PRJNA1145574 8958 287 1.457944 4.18429928 Serinicoccus profundi 1078471 Bacteria Bacteria 531 2.799999999999999e-146   NTclustered gi|1725275021|gb|CP042862.1| 1078471 g8774 i0 100 70.2369337979094 287 0 100 0 1 287 899719 899433 Serinicoccus profundi strain CGMCC 4.5582 chromosome, complete genome blastn 20158 531 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Ornithinimicrobiaceae Serinicoccus Serinicoccus profundi
23241016 23241016 PRJNA1145574_P_NODE_12479_length_249_cov_0.886364_g12295_i0 PRJNA1145574 12479 249 0.886364 2.20704636 Gardnerella swidsinskii 2792979 Bacteria Bacteria 455 1.47e-123   NTclustered gi|2235499256|gb|CP083176.1| 2792979 g12295 i0 99.598 8 249 1 100 0 1 249 361521 361273 Gardnerella swidsinskii strain JNFY3 chromosome, complete genome blastn 1992 455 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Gardnerella Gardnerella swidsinskii
23985538 23985538 PRJNA1145574_P_NODE_13699_length_245_cov_0.906977_g13515_i0 PRJNA1145574 13699 245 0.906977 2.22209365 Cutibacterium 1912216 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|1446500593|gb|CP031442.1| 1747 g13515 i0 100 46 245 0 100 0 1 245 2355066 2355310 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 11270 453 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes

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