RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA478247 · 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
19573558 19573558 PRJNA478247_P_NODE_2316_length_220_cov_2.193717_g2210_i0 PRJNA478247 2316 220 2.193717 4.8261774 root 1 Root_unresolved Root_unresolved 119 2.3e-33   NR WP_143213076.1 470 g2210 i0 90.9 1604.91818181818 66 6 90 0 13 210 23 88 WP_143213076.1 hypothetical protein, partial [Acinetobacter baumannii] diamond 353082 120 0.991666666666667 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
26839474 26839474 PRJNA478247_P_NODE_1741_length_273_cov_2.262295_g1635_i0 PRJNA478247 1741 273 2.262295 6.17606535 Pseudomonadati 3379134 Bacteria Bacteria 43.9 0.0216   NR WP_132706126.1 287 g1635 i0 34.7 2.3956043956044 72 43 79.1 1 220 5 252 319 WP_132706126.1 Ig-like domain-containing protein [Pseudomonas aeruginosa] diamond 654 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
27076263 27076263 PRJNA478247_P_NODE_2782_length_190_cov_4.322981_g2676_i0 PRJNA478247 2782 190 4.322981 8.2136639 Aminobacter 31988 Bacteria Bacteria 42.4 0.0249   NR WP_067957026.1 31988 g2676 i0 36.7 2.33684210526316 60 35 91.6 2 176 3 93 151 WP_067957026.1 MULTISPECIES: hydantoinase B/oxoprolinase family protein [Aminobacter] diamond 444 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Aminobacter  
27581732 27581732 PRJNA478247_P_NODE_3444_length_157_cov_2.585938_g3338_i0 PRJNA478247 3444 157 2.585938 4.05992266 Burkholderiales bacterium PBB5 2015567 Bacteria Bacteria 58.2 4.02e-8   NR OYU98086.1 2015567 g3338 i0 54.2 0.917197452229299 48 22 91.7 0 152 9 93 140 OYU98086.1 MAG: hypothetical protein CFE45_17860 [Burkholderiales bacterium PBB5] diamond 144 58.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales     Burkholderiales bacterium PBB5
28197647 28197647 PRJNA478247_P_NODE_1226_length_353_cov_2.250000_g1120_i0 PRJNA478247 1226 353 2.25 7.9425 root 1 Root_unresolved Root_unresolved 167 3.02e-50   NR MDG2599596.1 670 g1120 i0 79.1 81.4589235127479 110 23 93.5 0 330 1 4 113 MDG2599596.1 30S ribosomal protein S3 [Vibrio parahaemolyticus] diamond 28755 168 0.994047619047619 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio parahaemolyticus
28703080 28703080 PRJNA478247_P_NODE_2067_length_241_cov_1.990566_g1961_i0 PRJNA478247 2067 241 1.990566 4.79726406 Hyphomicrobium 81 Bacteria Bacteria 41.2 0.0262   NR WP_325456766.1 82 g1961 i0 45.2 1.15767634854772 42 21 49.8 1 169 50 39 80 WP_325456766.1 cysteine rich repeat-containing protein [Hyphomicrobium sp.] diamond 279 41.6 0.990384615384615 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Hyphomicrobiaceae Hyphomicrobium Hyphomicrobium sp.
29633698 29633698 PRJNA478247_P_NODE_290_length_900_cov_3.584386_g221_i0 PRJNA478247 290 900 3.584386 32.259474 Methylobacter sp. 2051955 Bacteria Bacteria 213 1.88e-63   NR MCK9395149.1 2051955 g221 i0 53.9 0.643333333333333 193 86 63.7 2 322 894 118 309 MCK9395149.1 LysM peptidoglycan-binding domain-containing protein [Methylobacter sp.] diamond 579 213 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Methylococcales Methylococcaceae Methylobacter Methylobacter sp.
29649758 29649758 PRJNA478247_P_NODE_1850_length_260_cov_1.796537_g1744_i0 PRJNA478247 1850 260 1.796537 4.6709962 Gammaproteobacteria 1236 Bacteria Bacteria 75.9 9.93e-14   NR WP_240479534.1 43658 g1744 i0 42.5 3.94615384615385 87 49 99.2 1 2 259 93 179 WP_240479534.1 NAD(P)-binding domain-containing protein [Pseudoalteromonas rubra] diamond 1026 75.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Pseudoalteromonadaceae Pseudoalteromonas Pseudoalteromonas rubra
31181789 31181789 PRJNA478247_P_NODE_2975_length_179_cov_2.280000_g2869_i0 PRJNA478247 2975 179 2.28 4.0812 Aquaspirillum sp. LM1 1938604 Bacteria Bacteria 59.3 2.07e-8   NR WP_171982167.1 1938604 g2869 i0 52.5 0.988826815642458 59 26 98.9 1 1 177 165 221 WP_171982167.1 LysM peptidoglycan-binding domain-containing protein [Aquaspirillum sp. LM1] diamond 177 59.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Aquaspirillaceae Aquaspirillum Aquaspirillum sp. LM1

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