RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", tax_clade = "PS1 clade" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 10 ✖

tax_kingdom 1

tax_clade 1

  • PS1 clade · 10 ✖

analysis 1

  • diamond · 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
22046920 22046920 PRJNA274362_S_NODE_15578_length_228_cov_1.435754_g15458_i0 PRJNA274362 15578 228 1.435754 3.27351912 Candidatus Micropelagos thuwalensis 1397666 Bacteria Bacteria 93.2 2.16e-21   NR WP_108912107.1 1397666 g15458 i0 66.7 5.27631578947368 66 20 86.8 1 6 203 151 214 WP_108912107.1 peptide-methionine (S)-S-oxide reductase MsrA [Candidatus Micropelagos thuwalensis] diamond 1203 93.2 1 Bacteria PS1 clade Pseudomonadati Pseudomonadota Alphaproteobacteria     Candidatus Micropelagius Candidatus Micropelagius thuwalensis
26619301 26619301 PRJNA720429_P_NODE_2201_length_288_cov_1.204651_g2144_i0 PRJNA720429 2201 288 1.204651 3.46939488 Bacteria 2 Bacteria Bacteria 60.8 2.53e-8   NR WP_021776968.1 1397666 g2144 i0 44.8 2.76041666666667 87 39 90.6 3 265 5 225 302 WP_021776968.1 saccharopine dehydrogenase family protein [Candidatus Micropelagos thuwalensis] diamond 795 61.2 0.993464052287582 Bacteria PS1 clade Pseudomonadati Pseudomonadota Alphaproteobacteria     Candidatus Micropelagius Candidatus Micropelagius thuwalensis
27072870 27072870 PRJNA1237347_P_NODE_209882_length_420_cov_1.360231_g203310_i0 PRJNA1237347 209882 420 1.360231 5.7129702 Candidatus Micropelagius sp. 2780115 Bacteria Bacteria 92.4 2.98e-19   NR MBL6767206.1 2780115 g203310 i0 38.9 0.935714285714286 131 70 93.6 1 1 393 64 184 MBL6767206.1 sulfatase-like hydrolase/transferase [Candidatus Micropelagos sp.] diamond 393 92.4 1 Bacteria PS1 clade Pseudomonadati Pseudomonadota Alphaproteobacteria     Candidatus Micropelagius Candidatus Micropelagius sp.
27445333 27445333 PRJEB75230_P_NODE_184183_length_241_cov_0.916667_g184001_i0 PRJEB75230 184183 241 0.916667 2.20916747 alpha proteobacterium IMCC14465 1220535 Bacteria Bacteria 44.7 0.00117   NR EJW22093.1 1220535 g184001 i0 39.6 0.597510373443983 48 29 59.8 0 95 238 6 53 EJW22093.1 hypothetical protein IMCC14465_04870 [alpha proteobacterium IMCC14465] diamond 144 44.7 1 Bacteria PS1 clade Pseudomonadati Pseudomonadota Alphaproteobacteria       alpha proteobacterium IMCC14465
28041602 28041602 PRJNA704949_P_NODE_1382385_length_212_cov_1.276074_g1367047_i0 PRJNA704949 1382385 212 1.276074 2.70527688 Candidatus Micropelagius 2175151 Bacteria Bacteria 58.5 5.73e-8   NR WP_021776679.1 1397666 g1367047 i0 71.8 1.65566037735849 39 11 55.2 0 139 23 1 39 WP_021776679.1 ribose-phosphate pyrophosphokinase [Candidatus Micropelagos thuwalensis] diamond 351 58.5 1 Bacteria PS1 clade Pseudomonadati Pseudomonadota Alphaproteobacteria     Candidatus Micropelagius Candidatus Micropelagius thuwalensis
28575722 28575722 PRJNA1204310_P_NODE_56827_length_248_cov_0.891429_g56530_i0 PRJNA1204310 56827 248 0.891429 2.21074392 Alphaproteobacteria 28211 Bacteria Bacteria 89.7 6.83e-20   NR EJW21290.1 1220535 g56530 i0 54.9 11.1653225806452 71 32 85.9 0 247 35 6 76 EJW21290.1 major intrinsic protein [alpha proteobacterium IMCC14465] diamond 2769 90.5 0.991160220994475 Bacteria PS1 clade Pseudomonadati Pseudomonadota Alphaproteobacteria       alpha proteobacterium IMCC14465
29296867 29296867 PRJNA846110_P_NODE_29449_length_242_cov_0.911243_g29204_i0 PRJNA846110 29449 242 0.911243 2.20520806 PS1 clade bacterium 2175152 Bacteria Bacteria 42.4 0.0486   NR MFP6776193.1 2175152 g29204 i0 32.4 0.880165289256198 71 46 86.8 2 236 27 88 157 MFP6776193.1 FAD-dependent monooxygenase [PS1 clade bacterium] diamond 213 42.4 1 Bacteria PS1 clade Pseudomonadati Pseudomonadota Alphaproteobacteria       PS1 clade bacterium
29649980 29649980 PRJNA520845_P_NODE_204190_length_258_cov_1.545946_g202691_i0 PRJNA520845 204190 258 1.545946 3.98854068 Parvibaculum 256616 Bacteria Bacteria 109 4.11e-27   NR EJW22026.1 1220535 g202691 i0 53.6 1.88372093023256 84 39 97.7 0 254 3 3 86 EJW22026.1 hypothetical protein IMCC14465_04200 [alpha proteobacterium IMCC14465] diamond 486 110 0.990909090909091 Bacteria PS1 clade Pseudomonadati Pseudomonadota Alphaproteobacteria       alpha proteobacterium IMCC14465
30693978 30693978 PRJNA674308_P_NODE_16913_length_236_cov_1.951872_g16678_i0 PRJNA674308 16913 236 1.951872 4.60641792 Candidatus Micropelagius 2175151 Bacteria Bacteria 63.5 1.57e-9   NR WP_021776781.1 1397666 g16678 i0 41.4 8.09745762711864 70 40 87.7 1 207 1 387 456 WP_021776781.1 S9 family peptidase [Candidatus Micropelagos thuwalensis] diamond 1911 63.5 1 Bacteria PS1 clade Pseudomonadati Pseudomonadota Alphaproteobacteria     Candidatus Micropelagius Candidatus Micropelagius thuwalensis
32270930 32270930 PRJNA980587_P_NODE_89498_length_244_cov_0.900585_g88705_i0 PRJNA980587 89498 244 0.900585 2.1974274 PS1 clade bacterium 2175152 Bacteria Bacteria 98.6 1.62e-22   NR MBL6786464.1 2175152 g88705 i0 54.4 5.86475409836066 79 36 97.1 0 244 8 226 304 MBL6786464.1 NADPH:quinone oxidoreductase family protein [PS1 clade bacterium] diamond 1431 98.6 1 Bacteria PS1 clade Pseudomonadati Pseudomonadota Alphaproteobacteria       PS1 clade bacterium

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