RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA1175041" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1175041 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
7418934 7418934 PRJNA1175041_P_NODE_107266_length_240_cov_0.868263_g104398_i0 PRJNA1175041 107266 240 0.868263 2.0838312 Escherichia 561 Bacteria Bacteria 438 1.4199999999999995e-118   NTclustered gi|2653344983|gb|CP142438.1| 562 g104398 i0 99.583 100 240 1 100 0 1 240 3927579 3927340 Escherichia coli strain Case 2 chromosome, complete genome blastn 24000 438 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
8694064 8694064 PRJNA1175041_P_NODE_72287_length_320_cov_1.170040_g69419_i0 PRJNA1175041 72287 320 1.17004 3.744128 Brevundimonas 41275 Bacteria Bacteria 575 1.44e-159   NTclustered gi|937996820|gb|CP012897.1| 1532555 g69419 i0 99.062 40.75625 320 3 100 0 1 320 1269491 1269810 Brevundimonas sp. DS20 chromosome, complete genome blastn 13042 575 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Brevundimonas Brevundimonas sp. DS20
9244888 9244888 PRJNA1175041_P_NODE_55708_length_400_cov_1.275229_g52840_i0 PRJNA1175041 55708 400 1.275229 5.100916 Chromobacterium paludis 2605945 Bacteria Bacteria 52.8 0.038   NTclustered gi|1735038415|gb|CP043473.1| 2605945 g52840 i0 100 0.07 28 0 7 0 97 124 1064057 1064030 Chromobacterium paludis strain IIBBL 257-1 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chromobacteriaceae Chromobacterium Chromobacterium paludis
9969200 9969200 PRJNA1175041_P_NODE_105168_length_241_cov_1.821429_g102300_i0 PRJNA1175041 105168 241 1.821429 4.38964389 Enterobacteriaceae 543 Bacteria Bacteria 446 8.519999999999999e-121   NTclustered gi|2650988455|gb|CP142548.1| 562 g102300 i0 100 698.838174273859 241 0 100 0 1 241 188619 188379 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 168420 446 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
12519812 12519812 PRJNA1175041_P_NODE_98410_length_247_cov_1.747126_g95542_i0 PRJNA1175041 98410 247 1.747126 4.31540122 Pseudomonadota 1224 Bacteria Bacteria 457 4.05e-124   NTclustered gi|2103567975|gb|OK326642.1| 479 g95542 i0 100 106 247 0 100 0 1 247 329 83 Moraxella sp. strain Y2-U-1 16S ribosomal RNA gene, partial sequence blastn 26182 457 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Moraxella Moraxella sp.
13794387 13794387 PRJNA1175041_P_NODE_104911_length_242_cov_0.899408_g102043_i0 PRJNA1175041 104911 242 0.899408 2.17656736 Enterobacteriaceae 543 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|2161252967|gb|CP088071.1| 562 g102043 i0 100 100 242 0 100 0 1 242 1322607 1322848 Escherichia coli strain 427603 chromosome, complete genome blastn 24200 448 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
20167398 20167398 PRJNA1175041_P_NODE_104916_length_242_cov_0.899408_g102048_i0 PRJNA1175041 104916 242 0.899408 2.17656736 Escherichia 561 Bacteria Bacteria 442 1.1099999999999995e-119   NTclustered gi|2562439222|gb|CP132022.1| 562 g102048 i0 99.587 100 242 1 100 0 1 242 3274088 3274329 Escherichia coli strain GON1437 chromosome, complete genome blastn 24200 442 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
21993036 21993036 PRJNA1175041_P_NODE_102218_length_244_cov_0.888889_g99350_i0 PRJNA1175041 102218 244 0.888889 2.16888916 Caulobacter sp. FWC26 69665 Bacteria Bacteria 320 5.46e-83   NTclustered gi|1552058772|gb|CP033875.1| 69665 g99350 i0 90.244 2.92622950819672 246 22 100 2 1 244 2299605 2299850 Caulobacter sp. FWC26 chromosome, complete genome blastn 714 320 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Caulobacter Caulobacter sp. FWC26
24542975 24542975 PRJNA1175041_P_NODE_58060_length_385_cov_7.887821_g55192_i0 PRJNA1175041 58060 385 7.887821 30.36811085 Burkholderia stabilis 95485 Bacteria Bacteria 54.7 0.01   NTclustered gi|1494835024|emb|LR025742.1| 95485 g55192 i0 96.97 1.1038961038961 33 0 8 1 322 353 2889494 2889526 Burkholderia stabilis genome assembly, chromosome: I blastn 425 54.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia Burkholderia stabilis

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