RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA448207" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA448207 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
2367691 2367691 PRJNA448207_P_NODE_22182_length_272_cov_1.542714_g22019_i0 PRJNA448207 22182 272 1.542714 4.19618208 Variovorax sp. 1871043 Bacteria Bacteria 167 2.18e-48   NR RZM03870.1 1871043 g22019 i0 98.9 0.992647058823529 90 1 99.3 0 3 272 202 291 RZM03870.1 MAG: ABC transporter ATP-binding protein [Variovorax sp.] diamond 270 167 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Variovorax Variovorax sp.
14467354 14467354 PRJNA448207_P_NODE_22652_length_269_cov_1.357143_g22489_i0 PRJNA448207 22652 269 1.357143 3.65071467 Devosia sp. 1871048 Bacteria Bacteria 144 7.669999999999999e-38   NR WP_395817873.1 1871048 g22489 i0 91 0.992565055762082 89 8 99.3 0 267 1 826 914 WP_395817873.1 hypothetical protein [Devosia sp.] diamond 267 144 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Devosiaceae Devosia Devosia sp.
14467649 14467649 PRJNA448207_S_NODE_3032_length_265_cov_1.291667_g3021_i0 PRJNA448207 3032 265 1.291667 3.42291755 Gammaproteobacteria bacterium SG8_31 1703405 Bacteria Bacteria 142 6.899999999999999e-38   NR KPK60184.1 1703405 g3021 i0 70.1 1.96981132075472 87 26 98.5 0 3 263 212 298 KPK60184.1 MAG: malate synthase [Gammaproteobacteria bacterium SG8_31] diamond 522 142 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium SG8_31
26632868 26632868 PRJNA448207_P_NODE_28081_length_248_cov_0.880000_g27918_i0 PRJNA448207 28081 248 0.88 2.1824 Magnetospirillum sp. 31872 Bacteria Bacteria 43.1 0.0266   NR MCA1907165.1 31872 g27918 i0 37.9 0.798387096774194 66 25 61.7 2 23 175 88 152 MCA1907165.1 DMT family transporter [Magnetospirillum sp.] diamond 198 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Rhodospirillaceae Magnetospirillum Magnetospirillum sp.
26854821 26854821 PRJNA448207_S_NODE_2981_length_267_cov_1.190722_g2970_i0 PRJNA448207 2981 267 1.190722 3.17922774 Pseudomonadota bacterium 1977087 Bacteria Bacteria 98.6 6.31e-22   NR MES2713301.1 1977087 g2970 i0 56.6 4.48314606741573 83 36 93.3 0 17 265 203 285 MES2713301.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis GTPase MnmE [Pseudomonadota bacterium] diamond 1197 98.6 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27755966 27755966 PRJNA448207_P_NODE_28084_length_248_cov_0.880000_g27921_i0 PRJNA448207 28084 248 0.88 2.1824 Burkholderiales 80840 Bacteria Bacteria 131 1.31e-34   NR WP_019572779.1 86182 g27921 i0 69.5 4.95967741935484 82 25 99.2 0 2 247 152 233 WP_019572779.1 hypothetical protein [Curvibacter lanceolatus] diamond 1230 132 0.992424242424242 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Curvibacter Curvibacter lanceolatus
27771214 27771214 PRJNA448207_P_NODE_27664_length_248_cov_0.880000_g27501_i0 PRJNA448207 27664 248 0.88 2.1824 Methylorubrum zatmanii 29429 Bacteria Bacteria 173 5.64e-48   NR WP_192284585.1 29429 g27501 i0 100 0.991935483870968 82 0 99.2 0 247 2 187 268 WP_192284585.1 EAL domain-containing protein [Methylorubrum zatmanii] diamond 246 173 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylorubrum Methylorubrum zatmanii
27865594 27865594 PRJNA448207_P_NODE_29185_length_246_cov_0.890173_g29022_i0 PRJNA448207 29185 246 0.890173 2.18982558 Klebsiella pneumoniae 573 Bacteria Bacteria 44.7 9.52e-4   NR WP_416493070.1 573 g29022 i0 46 0.609756097560976 50 27 61 0 3 152 17 66 WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 150 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28023695 28023695 PRJNA448207_P_NODE_32285_length_242_cov_0.911243_g32122_i0 PRJNA448207 32285 242 0.911243 2.20520806 Frigidibacter sp. MR17.14 3126509 Bacteria Bacteria 117 2.71e-28   NR WP_336468868.1 3126509 g32122 i0 70 0.991735537190083 80 24 99.2 0 2 241 711 790 WP_336468868.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Frigidibacter sp. MR17.14] diamond 240 117 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Frigidibacter Frigidibacter sp. MR17.14
28150043 28150043 PRJNA448207_P_NODE_19845_length_289_cov_0.875000_g19682_i0 PRJNA448207 19845 289 0.875 2.52875 Accumulibacter sp. 2053492 Bacteria Bacteria 43.9 0.0251   NR HPT49865.1 2053492 g19682 i0 36.4 2.28373702422145 55 35 57.1 0 247 83 492 546 HPT49865.1 alpha-D-glucose phosphate-specific phosphoglucomutase [Accumulibacter sp.] diamond 660 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria     Candidatus Accumulibacter Accumulibacter sp.
28781203 28781203 PRJNA448207_P_NODE_29907_length_245_cov_0.895349_g29744_i0 PRJNA448207 29907 245 0.895349 2.19360505 Magnetococcales bacterium 2026759 Bacteria Bacteria 41.6 0.0153   NR MBF0448120.1 2026759 g29744 i0 42.3 0.636734693877551 52 26 63.7 1 9 164 14 61 MBF0448120.1 hypothetical protein [Magnetococcales bacterium] diamond 156 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Magnetococcia Magnetococcales     Magnetococcales bacterium
29601978 29601978 PRJNA448207_P_NODE_31490_length_243_cov_0.905882_g31327_i0 PRJNA448207 31490 243 0.905882 2.20129326 Croceicoccus hydrothermalis 2867964 Bacteria Bacteria 53.9 4.2e-6   NR WP_239805385.1 2867964 g31327 i0 78.8 0.407407407407407 33 7 40.7 0 3 101 643 675 WP_239805385.1 CHAT domain-containing protein [Croceicoccus hydrothermalis] diamond 99 53.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Erythrobacteraceae Croceicoccus Croceicoccus hydrothermalis
30549891 30549891 PRJNA448207_P_NODE_21933_length_274_cov_1.293532_g21770_i0 PRJNA448207 21933 274 1.293532 3.54427768 unclassified Variovorax 663243 Bacteria Bacteria 52 2.98e-5   NR WP_213955315.1 663243 g21770 i0 44.4 0.68978102189781 63 35 69 0 2 190 326 388 WP_213955315.1 MULTISPECIES: hypothetical protein [unclassified Variovorax] diamond 189 52 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Variovorax  
30897687 30897687 PRJNA448207_P_NODE_26434_length_250_cov_0.870056_g26271_i0 PRJNA448207 26434 250 0.870056 2.17514 Neorhizobium galegae 399 Bacteria Bacteria 158 1.53e-47   NR WP_255737910.1 399 g26271 i0 98.8 9.96 83 1 99.6 0 2 250 61 143 WP_255737910.1 IS110 family transposase, partial [Neorhizobium galegae] diamond 2490 158 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Neorhizobium Neorhizobium galegae
31371828 31371828 PRJNA448207_P_NODE_32476_length_242_cov_0.911243_g32313_i0 PRJNA448207 32476 242 0.911243 2.20520806 Gammaproteobacteria bacterium RIFCSPHIGHO2_12_FULL_43_28 1798287 Bacteria Bacteria 75.9 6.8e-14   NR OGT58354.1 1798287 g32313 i0 58.2 0.830578512396694 67 28 83.1 0 37 237 74 140 OGT58354.1 MAG: hypothetical protein A3F14_01905 [Gammaproteobacteria bacterium RIFCSPHIGHO2_12_FULL_43_28] diamond 201 75.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium RIFCSPHIGHO2_12_FULL_43_28
31498314 31498314 PRJNA448207_P_NODE_15616_length_323_cov_1.232000_g15453_i0 PRJNA448207 15616 323 1.232 3.97936 Rickettsiales bacterium 2026788 Bacteria Bacteria 45.1 0.00662   NR MBQ7552309.1 2026788 g15453 i0 28.1 0.891640866873065 96 61 84.5 2 9 281 62 154 MBQ7552309.1 hypothetical protein [Rickettsiales bacterium] diamond 288 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
31624619 31624619 PRJNA448207_P_NODE_15016_length_328_cov_1.811765_g14853_i0 PRJNA448207 15016 328 1.811765 5.9425892 Methylophaga sp. UBA1918 1946869 Bacteria Bacteria 68.9 4.4e-11   NR WP_289285110.1 1946869 g14853 i0 62.5 0.439024390243902 48 18 43.9 0 328 185 268 315 WP_289285110.1 adenylosuccinate synthase, partial [Methylophaga sp. UBA1918] diamond 144 68.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Piscirickettsiaceae Methylophaga Methylophaga sp. UBA1918
31624627 31624627 PRJNA448207_P_NODE_33196_length_241_cov_0.916667_g33033_i0 PRJNA448207 33196 241 0.916667 2.20916747 Methylobacillus glycogenes 406 Bacteria Bacteria 142 2.14e-40   NR WP_025869350.1 406 g33033 i0 97.5 0.983402489626556 79 2 98.3 0 3 239 88 166 WP_025869350.1 RNA methyltransferase [Methylobacillus glycogenes] diamond 237 142 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylobacillus Methylobacillus glycogenes
31687886 31687886 PRJNA448207_P_NODE_28217_length_248_cov_0.880000_g28054_i0 PRJNA448207 28217 248 0.88 2.1824 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 42.7 0.0164   NR WP_395514446.1 251699 g28054 i0 47.1 0.616935483870968 51 26 61.7 1 155 3 3 52 WP_395514446.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 153 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
32131046 32131046 PRJNA448207_P_NODE_9218_length_406_cov_1.135135_g9056_i0 PRJNA448207 9218 406 1.135135 4.6086481 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 66.2 8.37e-10   NR MCP3667323.1 1913989 g9056 i0 45.2 2.09852216748768 93 50 68 1 127 402 112 204 MCP3667323.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 852 66.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
32352603 32352603 PRJNA448207_P_NODE_32759_length_242_cov_0.893491_g32596_i0 PRJNA448207 32759 242 0.893491 2.16224822 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 92.8 1.29e-20   NR MFL2486214.1 1913989 g32596 i0 70.1 0.830578512396694 67 20 83.1 0 203 3 1 67 MFL2486214.1 SDR family oxidoreductase [Gammaproteobacteria bacterium] diamond 201 92.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria 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);;