RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA702290" 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

  • PRJNA702290 · 9 ✖

analysis 1

  • diamond · 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
26987730 26987730 PRJNA702290_P_NODE_662_length_191_cov_17.559211_g654_i0 PRJNA702290 662 191 17.559211 33.53809301 uncultured Novosphingobium sp. 292277 Bacteria Bacteria 43.1 0.00489   NR WP_394659905.1 292277 g654 i0 77.3 0.345549738219895 22 5 34.6 0 77 12 78 99 WP_394659905.1 hypothetical protein [uncultured Novosphingobium sp.] diamond 66 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Novosphingobium uncultured Novosphingobium sp.
28388737 28388737 PRJNA702290_P_NODE_1646_length_158_cov_15.705882_g1638_i0 PRJNA702290 1646 158 15.705882 24.81529356 Polynucleobacter 44013 Bacteria Bacteria 53.9 1.59e-7   NR WP_216229829.1 2689099 g1638 i0 92.6 1.0253164556962 27 2 51.3 0 2 82 35 61 WP_216229829.1 hypothetical protein [Polynucleobacter sp. 78F-HAINBA] diamond 162 53.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Polynucleobacter Polynucleobacter sp. 78F-HAINBA
28724990 28724990 PRJNA702290_P_NODE_2107_length_151_cov_7.669643_g2099_i0 PRJNA702290 2107 151 7.669643 11.58116093 Roseateles cellulosilyticus 2906762 Bacteria Bacteria 83.6 4.34e-17   NR WP_233372837.1 2906762 g2099 i0 78.2 2.20529801324503 55 3 91.4 1 4 141 1704 1758 WP_233372837.1 CARDB domain-containing protein [Roseateles cellulosilyticus] diamond 333 83.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Pelomonas cellulosilytica
29861664 29861664 PRJNA702290_P_NODE_1471_length_161_cov_10.377049_g1463_i0 PRJNA702290 1471 161 10.377049 16.70704889 Methylibium sp. 2067992 Bacteria Bacteria 49.3 5.7e-5   NR MBA4218745.1 2067992 g1463 i0 61.4 0.819875776397516 44 16 82 1 6 137 2 44 MBA4218745.1 hypothetical protein [Methylibium sp.] diamond 132 49.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Methylibium Methylibium sp.
30462361 30462361 PRJNA702290_P_NODE_1713_length_158_cov_5.739496_g1705_i0 PRJNA702290 1713 158 5.739496 9.06840368 Haemophilus sputorum 1078480 Bacteria Bacteria 90.1 4.61e-20   NR WP_007526604.1 1078480 g1705 i0 85.2 1.0253164556962 54 0 87.3 1 8 145 237 290 WP_007526604.1 SAM-dependent methyltransferase TehB [Haemophilus sputorum] diamond 162 90.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Haemophilus Haemophilus sputorum
30904374 30904374 PRJNA702290_P_NODE_1174_length_191_cov_3.967105_g1166_i0 PRJNA702290 1174 191 3.967105 7.57717055 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 42 0.00373   NR MBM3623255.1 1913988 g1166 i0 92.3 1.22513089005236 26 2 40.8 0 114 191 24 49 MBM3623255.1 Flp family type IVb pilin [Alphaproteobacteria bacterium] diamond 234 42 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
31125054 31125054 PRJNA702290_P_NODE_1215_length_191_cov_2.868421_g1207_i0 PRJNA702290 1215 191 2.868421 5.47868411 Ramlibacter sp. AN1133 3133429 Bacteria Bacteria 48.5 4.34e-5   NR WP_340354051.1 3133429 g1207 i0 39.7 1.22513089005236 78 27 92.7 2 8 184 10 86 WP_340354051.1 DUF485 domain-containing protein [Ramlibacter sp. AN1133] diamond 234 48.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Ramlibacter Ramlibacter sp. AN1133
31947574 31947574 PRJNA702290_P_NODE_1157_length_191_cov_4.190789_g1149_i0 PRJNA702290 1157 191 4.190789 8.00440699 Acinetobacter sp. 472 Bacteria Bacteria 48.9 1.13e-4   NR HQZ60399.1 472 g1149 i0 76 0.392670157068063 25 6 39.3 0 188 114 178 202 HQZ60399.1 hypothetical protein [Acinetobacter sp.] diamond 75 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter sp.
32863850 32863850 PRJNA702290_P_NODE_840_length_191_cov_11.822368_g832_i0 PRJNA702290 840 191 11.822368 22.58072288 Roseateles sp. 1971397 Bacteria Bacteria 60.8 7.53e-9   NR WP_373714789.1 1971397 g832 i0 100 0.753926701570681 24 0 37.7 0 115 186 328 351 WP_373714789.1 exosortase A [Roseateles sp.] diamond 144 60.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Roseateles sp.

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