RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB50765" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB50765 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
119554 119554 PRJEB50765_P_NODE_1601_length_236_cov_1.733668_g1577_i0 PRJEB50765 1601 236 1.733668 4.09145648 Aquabacterium sp. J223 2898431 Bacteria Bacteria 436 4.999999999999999e-118   NTclustered gi|2285501637|gb|CP088297.1| 2898431 g1577 i0 100 322.483050847458 236 0 100 0 1 236 848538 848773 Aquabacterium sp. J223 chromosome blastn 76106 436 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales   Aquabacterium Aquabacterium sp. J223
1393953 1393953 PRJEB50765_P_NODE_1862_length_214_cov_1.858757_g1838_i0 PRJEB50765 1862 214 1.858757 3.97773998 Rheinheimera sp. D18 2545632 Bacteria Bacteria 294 2.8400000000000003e-75   NTclustered gi|1590159087|gb|CP037745.1| 2545632 g1838 i0 91.943 872.275700934579 211 16 99 1 5 214 44822 44612 Rheinheimera sp. D18 chromosome, complete genome blastn 186667 294 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera sp. D18
1393958 1393958 PRJEB50765_P_NODE_2702_length_169_cov_2.295455_g2678_i0 PRJEB50765 2702 169 2.295455 3.87931895 Undibacterium sp. YM2 2058625 Bacteria Bacteria 300 4.56e-77   NTclustered gi|1798099803|dbj|AP018441.1| 2058625 g2678 i0 98.81 276.159763313609 168 2 99 0 1 168 1530806 1530973 Undibacterium sp. YM2 DNA, complete genome blastn 46671 300 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium sp. YM2
2266599 2266599 PRJEB50765_P_NODE_322_length_584_cov_3.914077_g303_i0 PRJEB50765 322 584 3.914077 22.85820968 Oxalobacteraceae 75682 Bacteria Bacteria 826 0   NTclustered gi|2204876709|gb|CP049334.1| 964 g303 i0 92.295 489.030821917808 584 41 99 4 2 584 522875 522295 Herbaspirillum seropedicae strain Z69 chromosome blastn 285594 832 0.992788461538462 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Herbaspirillum Herbaspirillum seropedicae
6497789 6497789 PRJEB50765_P_NODE_1306_length_268_cov_1.727273_g1282_i0 PRJEB50765 1306 268 1.727273 4.62909164 Undibacterium sp. YM2 2058625 Bacteria Bacteria 401 2.1099999999999995e-107   NTclustered gi|1798099803|dbj|AP018441.1| 2058625 g1282 i0 93.704 347.876865671642 270 13 100 3 1 268 1529466 1529733 Undibacterium sp. YM2 DNA, complete genome blastn 93231 401 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium sp. YM2
9919539 9919539 PRJEB50765_P_NODE_2828_length_165_cov_1.203125_g2804_i0 PRJEB50765 2828 165 1.203125 1.98515625 Enterobacteriaceae 543 Bacteria Bacteria 305 9.59e-79   NTclustered gi|2650988455|gb|CP142548.1| 562 g2804 i0 100 664.157575757576 165 0 100 0 1 165 186384 186548 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 109586 305 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
17971114 17971114 PRJEB50765_P_NODE_3215_length_153_cov_1.310345_g3191_i0 PRJEB50765 3215 153 1.310345 2.00482785 Aquabacterium sp. J223 2898431 Bacteria Bacteria 267 4.1099999999999994e-67   NTclustered gi|2285501637|gb|CP088297.1| 2898431 g3191 i0 98.039 170.888888888889 153 3 100 0 1 153 847785 847633 Aquabacterium sp. J223 chromosome blastn 26146 267 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales   Aquabacterium Aquabacterium sp. J223
18842921 18842921 PRJEB50765_P_NODE_3075_length_157_cov_1.116667_g3051_i0 PRJEB50765 3075 157 1.116667 1.75316719 Gammaproteobacteria 1236 Bacteria Bacteria 291 2.52e-74   NTclustered gi|2321448847|gb|CP107616.1| 470 g3051 i0 100 583.006369426752 157 0 100 0 1 157 23208 23052 Acinetobacter baumannii strain 1326932 chromosome, complete genome blastn 91532 291 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii

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