RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1022587" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1022587 · 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
1004140 1004140 PRJNA1022587_S_NODE_241_length_434_cov_0.991690_g239_i0 PRJNA1022587 241 434 0.99169 4.3039346 Enterobacteriaceae 543 Bacteria Bacteria 795 0   NTclustered gi|1482420149|gb|CP032426.1| 562 g239 i0 99.769 191.552995391705 433 1 99 0 2 434 2565613 2565181 Escherichia coli strain SCEC020001 chromosome, complete genome blastn 83134 795 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
2279321 2279321 PRJNA1022587_S_NODE_1462_length_244_cov_1.350877_g1460_i0 PRJNA1022587 1462 244 1.350877 3.29613988 Escherichia 561 Bacteria Bacteria 451 1.86e-122   NTclustered gi|2281256354|gb|CP101920.1| 562 g1460 i0 100 169.967213114754 244 0 100 0 1 244 2503212 2502969 Escherichia coli strain QA-1986 630 chromosome, complete genome blastn 41472 451 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
4832148 4832148 PRJNA1022587_S_NODE_1424_length_246_cov_0.884393_g1422_i0 PRJNA1022587 1424 246 0.884393 2.17560678 Escherichia 561 Bacteria Bacteria 453 5.2100000000000006e-123   NTclustered gi|2653344983|gb|CP142438.1| 562 g1422 i0 100 99.5934959349593 245 0 99 0 1 245 401737 401493 Escherichia coli strain Case 2 chromosome, complete genome blastn 24500 453 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
6107311 6107311 PRJNA1022587_S_NODE_1065_length_267_cov_3.170103_g1063_i0 PRJNA1022587 1065 267 3.170103 8.46417501 Escherichia 561 Bacteria Bacteria 494 3.38e-135   NTclustered gi|2650988455|gb|CP142548.1| 562 g1063 i0 100 105.640449438202 267 0 100 0 1 267 509020 508754 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 28206 494 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
6107318 6107318 PRJNA1022587_S_NODE_665_length_312_cov_1.744770_g663_i0 PRJNA1022587 665 312 1.74477 5.4436824 Enterobacteriaceae 543 Bacteria Bacteria 577 3.89e-160   NTclustered gi|2650988455|gb|CP142548.1| 562 g663 i0 100 199 312 0 100 0 1 312 2730833 2731144 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 62088 577 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
7381796 7381796 PRJNA1022587_S_NODE_1126_length_263_cov_1.215789_g1124_i0 PRJNA1022587 1126 263 1.215789 3.19752507 Enterobacteriaceae 543 Bacteria Bacteria 486 5.5499999999999986e-133   NTclustered gi|2650988455|gb|CP142548.1| 562 g1124 i0 100 100 263 0 100 0 1 263 814099 813837 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 26300 486 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
9932179 9932179 PRJNA1022587_S_NODE_1548_length_242_cov_0.911243_g1546_i0 PRJNA1022587 1548 242 0.911243 2.20520806 Acinetobacter 469 Bacteria Bacteria 435 1.85e-117   NTclustered gi|2676817394|gb|CP144757.1| 470 g1546 i0 99.58 97.7892561983471 238 1 98 0 5 242 3222935 3223172 Acinetobacter baumannii strain PUMA0248 chromosome, complete genome blastn 23665 435 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
9932189 9932189 PRJNA1022587_S_NODE_648_length_314_cov_4.112033_g646_i0 PRJNA1022587 648 314 4.112033 12.91178362 Enterobacteriaceae 543 Bacteria Bacteria 545 1.11e-150   NTclustered gi|2450726933|gb|CP118601.1| 562 g646 i0 100 93.7929936305732 295 0 94 0 1 295 620587 620881 Escherichia coli strain NB4833 chromosome, complete genome blastn 29451 545 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
12482986 12482986 PRJNA1022587_S_NODE_1330_length_249_cov_0.875000_g1328_i0 PRJNA1022587 1330 249 0.875 2.17875 Enterobacteriaceae 543 Bacteria Bacteria 460 3.16e-125   NTclustered gi|2650988455|gb|CP142548.1| 562 g1328 i0 100 100 249 0 100 0 1 249 786834 786586 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 24900 460 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
17581915 17581915 PRJNA1022587_S_NODE_1174_length_258_cov_3.286486_g1172_i0 PRJNA1022587 1174 258 3.286486 8.47913388 Enterobacteriaceae 543 Bacteria Bacteria 477 3.2699999999999985e-130   NTclustered gi|2650988455|gb|CP142548.1| 562 g1172 i0 100 100 258 0 100 0 1 258 575544 575287 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 25800 477 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
17581916 17581916 PRJNA1022587_S_NODE_1234_length_253_cov_3.811111_g1232_i0 PRJNA1022587 1234 253 3.811111 9.64211083 Enterobacteriaceae 543 Bacteria Bacteria 448 2.5099999999999998e-121   NTclustered gi|2650988455|gb|CP142548.1| 562 g1232 i0 100 95.6521739130435 242 0 96 0 12 253 3441749 3441990 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 24200 448 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
17581917 17581917 PRJNA1022587_S_NODE_1274_length_251_cov_0.865169_g1272_i0 PRJNA1022587 1274 251 0.865169 2.17157419 Enterobacteriaceae 543 Bacteria Bacteria 464 2.47e-126   NTclustered gi|2650988455|gb|CP142548.1| 562 g1272 i0 100 100 251 0 100 0 1 251 1508408 1508158 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 25100 464 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
18855760 18855760 PRJNA1022587_S_NODE_615_length_319_cov_0.939024_g613_i0 PRJNA1022587 615 319 0.939024 2.99548656 Enterobacteriaceae 543 Bacteria Bacteria 590 5.1299999999999986e-164   NTclustered gi|2737310786|gb|CP157132.1| 562 g613 i0 100 100 319 0 100 0 1 319 2470493 2470811 Escherichia coli strain UTAK-18 chromosome, complete genome blastn 31900 590 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
18855763 18855763 PRJNA1022587_S_NODE_835_length_290_cov_1.580645_g833_i0 PRJNA1022587 835 290 1.580645 4.5838705 Enterobacteriaceae 543 Bacteria Bacteria 536 6.079999999999999e-148   NTclustered gi|2244114683|emb|OW968111.1| 562 g833 i0 100 100 290 0 100 0 1 290 3287022 3286733 Escherichia coli isolate 602 genome assembly, chromosome: main blastn 29000 536 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
20130492 20130492 PRJNA1022587_S_NODE_1216_length_255_cov_1.082418_g1214_i0 PRJNA1022587 1216 255 1.082418 2.7601659 Acinetobacter 469 Bacteria Bacteria 472 1.5e-128   NTclustered gi|1995439409|gb|CP070866.1| 40214 g1214 i0 100 637.050980392157 255 0 100 0 1 255 497495 497241 Acinetobacter johnsonii strain XY27 chromosome, complete genome blastn 162448 472 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter johnsonii

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