RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA415636" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA415636 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
419115 419115 PRJNA415636_S_NODE_6561_length_202_cov_2.025806_g6514_i0 PRJNA415636 6561 202 2.025806 4.09212812 Undibacterium sp. YM2 2058625 Bacteria Bacteria 302 1.5800000000000001e-77   NTclustered gi|1798099803|dbj|AP018441.1| 2058625 g6514 i0 93.564 314.282178217822 202 13 100 0 1 202 1529646 1529445 Undibacterium sp. YM2 DNA, complete genome blastn 63485 302 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium sp. YM2
1083270 1083270 PRJNA415636_S_NODE_2701_length_289_cov_1.475207_g2654_i0 PRJNA415636 2701 289 1.475207 4.26334823 root 1 Root_unresolved Root_unresolved 534 2.18e-147   NTclustered gi|2566177108|gb|CP132594.1| 562 g2654 i0 100 88.3044982698962 289 0 100 0 1 289 3914871 3914583 Escherichia coli strain SIJ488 chromosome, complete genome blastn 25520 534 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
4246170 4246170 PRJNA415636_S_NODE_1884_length_330_cov_2.491166_g1837_i0 PRJNA415636 1884 330 2.491166 8.2208478 Phyllobacterium zundukense 1867719 Bacteria Bacteria 344 4.58e-90   NTclustered gi|1276680390|gb|CP017940.1| 1867719 g1837 i0 85.455 2.88787878787879 330 48 100 0 1 330 2250094 2250423 Phyllobacterium zundukense strain Tri-48, complete sequence. blastn 953 344 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Phyllobacterium Phyllobacterium zundukense
8736134 8736134 PRJNA415636_S_NODE_4927_length_229_cov_4.236264_g4880_i0 PRJNA415636 4927 229 4.236264 9.70104456 Pseudomonas 286 Bacteria Bacteria 418 1.7499999999999995e-112   NTclustered gi|858972107|gb|KT215485.1| 294 g4880 i0 99.563 116 229 1 100 0 1 229 1094 1322 Pseudomonas fluorescens strain IC7 16S ribosomal RNA gene, partial sequence blastn 26564 418 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas fluorescens
11897952 11897952 PRJNA415636_S_NODE_2610_length_293_cov_1.902439_g2563_i0 PRJNA415636 2610 293 1.902439 5.57414627 Paucibacter sediminis 3019553 Bacteria Bacteria 481 2.92e-131   NTclustered gi|2517185782|gb|CP116346.1| 3019553 g2563 i0 96.259 309.696245733788 294 9 100 2 1 293 899448 899740 Paucibacter sediminis strain S2-9 chromosome, complete genome blastn 90741 481 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Paucibacter sediminis
17660803 17660803 PRJNA415636_S_NODE_4734_length_233_cov_1.370968_g4687_i0 PRJNA415636 4734 233 1.370968 3.19435544 Pasteurella 745 Bacteria Bacteria 425 1.07e-114   NTclustered gi|2488138257|gb|CP121788.1| 747 g4687 i0 99.571 99.7682403433476 233 1 100 0 1 233 547695 547927 Pasteurella multocida strain PM-3 chromosome, complete genome blastn 23246 425 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Pasteurella Pasteurella multocida
22095533 22095533 PRJNA415636_S_NODE_4658_length_234_cov_3.053476_g4611_i0 PRJNA415636 4658 234 3.053476 7.14513384 Flavobacterium dauae 1563479 Bacteria Bacteria 56.5 0.002   NTclustered gi|2557430891|gb|CP130821.1| 1563479 g4611 i0 100 0.128205128205128 30 0 13 0 11 40 1161438 1161409 Flavobacterium dauae strain TCH3-2 chromosome, complete genome blastn 30 56.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium dauae
22760242 22760242 PRJNA415636_S_NODE_4198_length_244_cov_1.167513_g4151_i0 PRJNA415636 4198 244 1.167513 2.84873172 Undibacterium 401469 Bacteria Bacteria 396 8.829999999999997e-106   NTclustered gi|2634174434|gb|CP133779.1| 3048609 g4151 i0 95.902 438.483606557377 244 10 100 0 1 244 1462454 1462211 Undibacterium sp. CCC3.4 chromosome, complete genome blastn 106990 399 0.992481203007519 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium sp. CCC3.4
24645516 24645516 PRJNA415636_S_NODE_4260_length_242_cov_3.923077_g4213_i0 PRJNA415636 4260 242 3.923077 9.49384634 Roseateles sp. DAIF2 2714952 Bacteria Bacteria 58.4 4.69e-4   NTclustered gi|1934957904|gb|CP049919.1| 2714952 g4213 i0 97.059 0.264462809917355 34 1 14 0 111 144 2008680 2008713 Roseateles sp. DAIF2 chromosome, complete genome blastn 64 58.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Roseateles sp. DAIF2
25309422 25309422 PRJNA415636_S_NODE_560_length_490_cov_6.668172_g515_i0 PRJNA415636 560 490 6.668172 32.6740428 Pseudomonas 286 Bacteria Bacteria 826 0   NTclustered gi|1877575224|dbj|AP022227.1| 303 g515 i0 98.71 636.812244897959 465 6 95 0 1 465 188722 188258 Pseudomonas putida DNA, complete genome, strain: WP8-W18-CRE-01 blastn 312038 826 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas putida

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