RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA1175041" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1175041 · 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
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
21993920 21993920 PRJNA1175041_P_NODE_78038_length_300_cov_1.202643_g75170_i0 PRJNA1175041 78038 300 1.202643 3.607929 Geopseudomonas aromaticivorans 2849492 Bacteria Bacteria 171 9.6e-52   NR WP_217682444.1 2849492 g75170 i0 94.6 0.92 92 5 92 0 280 5 105 196 WP_217682444.1 hypothetical protein [Geopseudomonas aromaticivorans] diamond 276 171 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Geopseudomonas Geopseudomonas aromaticivorans
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
27956666 27956666 PRJNA1175041_P_NODE_91945_length_260_cov_2.213904_g89077_i0 PRJNA1175041 91945 260 2.213904 5.7561504 Oceanicella sp. SM1341 1548889 Bacteria Bacteria 43.9 0.0182   NR WP_118138491.1 1548889 g89077 i0 38.6 0.807692307692308 70 32 78.5 3 6 209 606 666 WP_118138491.1 cytochrome c oxidase subunit I [Oceanicella sp. SM1341] diamond 210 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Oceanicella Oceanicella sp. SM1341
31367999 31367999 PRJNA1175041_P_NODE_70896_length_325_cov_1.250000_g68028_i0 PRJNA1175041 70896 325 1.25 4.0625 Escherichia coli 562 Bacteria Bacteria 87.8 1.63e-19   NR HAI4532814.1 562 g68028 i0 71.6 3.23076923076923 74 21 68.3 0 325 104 69 142 HAI4532814.1 hypothetical protein [Escherichia coli] diamond 1050 87.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31589377 31589377 PRJNA1175041_P_NODE_92596_length_259_cov_1.091398_g89728_i0 PRJNA1175041 92596 259 1.091398 2.82672082 Stenotrophomonas sp. ZAC14A_NAIMI4_1 2072412 Bacteria Bacteria 42.7 0.0444   NR WP_159095046.1 2072412 g89728 i0 46.2 0.602316602316602 52 26 57.9 1 212 63 13 64 WP_159095046.1 hypothetical protein [Stenotrophomonas sp. ZAC14A_NAIMI4_1] diamond 156 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Stenotrophomonas Stenotrophomonas sp. ZAC14A_NAIMI4_1
32285540 32285540 PRJNA1175041_P_NODE_85659_length_278_cov_0.887805_g82791_i0 PRJNA1175041 85659 278 0.887805 2.4680979 uncultured Massilia sp. 169973 Bacteria Bacteria 43.1 0.00992   NR WP_296952003.1 169973 g82791 i0 50 0.517985611510791 48 23 50.7 1 21 161 10 57 WP_296952003.1 hypothetical protein [uncultured Massilia sp.] diamond 144 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Massilia uncultured Massilia sp.
32884693 32884693 PRJNA1175041_P_NODE_94120_length_255_cov_1.049451_g91252_i0 PRJNA1175041 94120 255 1.049451 2.67610005 Trabulsiella odontotermitis 379893 Bacteria Bacteria 46.2 0.00254   NR WP_080993459.1 379893 g91252 i0 30.9 2.85882352941176 81 52 90.6 2 254 24 343 423 WP_080993459.1 type VI secretion system tip protein VgrG [Trabulsiella odontotermitis] diamond 729 46.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Trabulsiella Trabulsiella odontotermitis

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