RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA806354" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_clade 2

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 19 ✖

bioproject 1

  • PRJNA806354 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
16108548 16108548 PRJNA806354_P_NODE_40593_length_242_cov_0.911243_g40484_i0 PRJNA806354 40593 242 0.911243 2.20520806 root 1 Root_unresolved Root_unresolved 130 5.06e-33   NR WP_007279800.1 256847 g40484 i0 75.6 417.520661157025 78 19 96.7 0 7 240 631 708 WP_007279800.1 ATP-dependent chaperone ClpB [Lentisphaera araneosa] diamond 101040 130 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Lentisphaerales Lentisphaeraceae Lentisphaera Lentisphaera araneosa
27243785 27243785 PRJNA806354_P_NODE_28923_length_275_cov_2.920792_g28814_i0 PRJNA806354 28923 275 2.920792 8.032178 Planctomycetota bacterium 2026780 Bacteria Bacteria 44.7 0.0104   NR MEM7518636.1 2026780 g28814 i0 58.3 0.392727272727273 36 15 39.3 0 27 134 4 39 MEM7518636.1 DUF1601 domain-containing protein [Planctomycetota bacterium] diamond 108 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27252609 27252609 PRJNA806354_P_NODE_35783_length_250_cov_0.870056_g35674_i0 PRJNA806354 35783 250 0.870056 2.17514 Methylophilus 16 Bacteria Bacteria 145 1.76e-38   NR WP_245652615.1 492660 g35674 i0 88.9 10.692 81 9 97.2 0 3 245 362 442 WP_245652615.1 methyl-accepting chemotaxis protein, partial [Methylophilus rhizosphaerae] diamond 2673 145 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylophilus Methylophilus rhizosphaerae
27505608 27505608 PRJNA806354_P_NODE_39423_length_244_cov_0.900585_g39314_i0 PRJNA806354 39423 244 0.900585 2.1974274 FCB group 1783270 Bacteria Bacteria 139 2.6299999999999996e-37   NR MEI7669962.1 1977087 g39314 i0 81.3 2.95081967213115 80 15 98.4 0 242 3 32 111 MEI7669962.1 AAA family ATPase [Pseudomonadota bacterium] diamond 720 140 0.992857142857143 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27528071 27528071 PRJNA806354_P_NODE_33663_length_256_cov_2.349727_g33554_i0 PRJNA806354 33663 256 2.349727 6.01530112 Marinobacter sp. OP 3.4 3076501 Bacteria Bacteria 41.6 0.0301   NR WP_328189798.1 3076501 g33554 i0 42.3 0.609375 52 29 60.9 1 71 226 27 77 WP_328189798.1 hypothetical protein [Marinobacter sp. OP 3.4] diamond 156 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Marinobacteraceae Marinobacter Marinobacter sp. OP 3.4
28128154 28128154 PRJNA806354_P_NODE_18565_length_335_cov_4.332061_g18456_i0 PRJNA806354 18565 335 4.332061 14.51240435 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 45.8 0.00821   NR RLB60749.1 2026735 g18456 i0 48.9 0.402985074626866 45 23 40.3 0 326 192 175 219 RLB60749.1 MAG: hypothetical protein DRI90_12965, partial [Deltaproteobacteria bacterium] diamond 135 45.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28285695 28285695 PRJNA806354_P_NODE_38846_length_245_cov_0.895349_g38737_i0 PRJNA806354 38846 245 0.895349 2.19360505 Spirochaetia bacterium 2053615 Bacteria Bacteria 50.4 2.95e-5   NR NCB03759.1 2053615 g38737 i0 52.2 0.563265306122449 46 22 56.3 0 229 92 122 167 NCB03759.1 tail fiber domain-containing protein [Spirochaetia bacterium] diamond 138 50.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28412273 28412273 PRJNA806354_P_NODE_27706_length_281_cov_1.086538_g27597_i0 PRJNA806354 27706 281 1.086538 3.05317178 Methylophilus sp. QUAN 2781020 Bacteria Bacteria 188 6.629999999999999e-56   NR WP_194752973.1 2781020 g27597 i0 97.8 0.98220640569395 92 2 98.2 0 4 279 54 145 WP_194752973.1 SAM-dependent methyltransferase [Methylophilus sp. QUAN] diamond 276 188 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylophilus Methylophilus sp. QUAN
29201674 29201674 PRJNA806354_P_NODE_41349_length_241_cov_0.916667_g41240_i0 PRJNA806354 41349 241 0.916667 2.20916747 Omnitrophica bacterium RIFCSPHIGHO2_ 2035772 Bacteria Bacteria 74.7 3.64e-15   NR OGW83799.1 1801823 g41240 i0 57.7 0.647302904564315 52 22 64.7 0 2 157 61 112 OGW83799.1 MAG: hypothetical protein A3C47_04815 [Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_51_18] diamond 156 74.7 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_51_18
29359505 29359505 PRJNA806354_P_NODE_40689_length_242_cov_0.911243_g40580_i0 PRJNA806354 40689 242 0.911243 2.20520806 Massilia sp. YIM B 1882437 Bacteria Bacteria 86.7 1.49e-18   NR WP_290413997.1 3050130 g40580 i0 100 0.433884297520661 35 0 43.4 0 240 136 211 245 WP_290413997.1 DNA-formamidopyrimidine glycosylase family protein [Massilia sp. YIM B02763] diamond 105 86.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Massilia Massilia sp. YIM B02763
29422350 29422350 PRJNA806354_P_NODE_39909_length_243_cov_0.905882_g39800_i0 PRJNA806354 39909 243 0.905882 2.20129326 Leclercia adecarboxylata 83655 Bacteria Bacteria 131 8.319999999999999e-37   NR WP_272714667.1 83655 g39800 i0 84 0.925925925925926 75 12 92.6 0 227 3 1 75 WP_272714667.1 c-type cytochrome, partial [Leclercia adecarboxylata] diamond 225 131 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Leclercia Leclercia adecarboxylata
29683685 29683685 PRJNA806354_P_NODE_36290_length_249_cov_0.875000_g36181_i0 PRJNA806354 36290 249 0.875 2.17875 Pseudomonadati 3379134 Bacteria Bacteria 56.2 6.76e-7   NR MEN9845474.1 1977087 g36181 i0 76.5 2.04819277108434 34 8 41 0 144 245 1 34 MEN9845474.1 hypothetical protein [Pseudomonadota bacterium] diamond 510 56.6 0.992932862190813 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
30370573 30370573 PRJNA806354_P_NODE_36312_length_249_cov_0.875000_g36203_i0 PRJNA806354 36312 249 0.875 2.17875 uncultured Paraglaciecola sp. 1765024 Bacteria Bacteria 43.1 0.00378   NR WP_299078862.1 1765024 g36203 i0 48.6 0.421686746987952 35 18 42.2 0 113 9 2 36 WP_299078862.1 hypothetical protein, partial [uncultured Paraglaciecola sp.] diamond 105 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Paraglaciecola uncultured Paraglaciecola sp.
30694908 30694908 PRJNA806354_P_NODE_33313_length_258_cov_0.832432_g33204_i0 PRJNA806354 33313 258 0.832432 2.14767456 Salmonella 590 Bacteria Bacteria 154 3.23e-44   NR ECB2966014.1 28147 g33204 i0 96.5 10.8488372093023 85 3 98.8 0 2 256 50 134 ECB2966014.1 hypothetical protein [Salmonella enterica subsp. enterica serovar Oranienburg] diamond 2799 154 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
30875644 30875644 PRJNA806354_P_NODE_38754_length_245_cov_0.895349_g38645_i0 PRJNA806354 38754 245 0.895349 2.19360505 Flavobacterium sp. 239 Bacteria Bacteria 66.2 6.99e-11   NR WP_396172038.1 239 g38645 i0 45 0.979591836734694 80 43 96.7 1 5 241 24 103 WP_396172038.1 hypothetical protein, partial [Flavobacterium sp.] diamond 240 66.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
31760868 31760868 PRJNA806354_P_NODE_36037_length_249_cov_5.107955_g35928_i0 PRJNA806354 36037 249 5.107955 12.71880795 Helicobacter pylori 210 Bacteria Bacteria 59.3 2.95e-9   NR GAA8686254.1 210 g35928 i0 100 0.373493975903614 31 0 37.3 0 165 73 1 31 GAA8686254.1 hypothetical protein Kyoto145A_1480 [Helicobacter pylori] diamond 93 59.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32172423 32172423 PRJNA806354_P_NODE_41258_length_241_cov_0.916667_g41149_i0 PRJNA806354 41258 241 0.916667 2.20916747 Pseudomonadota bacterium 1977087 Bacteria Bacteria 86.3 4.1e-18   NR MFH0900681.1 1977087 g41149 i0 55.4 0.921161825726141 74 33 92.1 0 16 237 156 229 MFH0900681.1 hypothetical protein [Pseudomonadota bacterium] diamond 222 86.3 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
32362328 32362328 PRJNA806354_P_NODE_38259_length_246_cov_0.890173_g38150_i0 PRJNA806354 38259 246 0.890173 2.18982558 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 154 5.02e-44   NR MDE2028918.1 2035772 g38150 i0 92.5 1.95121951219512 80 6 97.6 0 4 243 183 262 MDE2028918.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatA [Candidatus Omnitrophota bacterium] diamond 480 154 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
32614982 32614982 PRJNA806354_P_NODE_39960_length_243_cov_0.905882_g39851_i0 PRJNA806354 39960 243 0.905882 2.20129326 Acidobacteriota bacterium 1978231 Bacteria Bacteria 138 2.61e-36   NR MBI1760598.1 1978231 g39851 i0 83.5 0.975308641975309 79 13 97.5 0 239 3 453 531 MBI1760598.1 HDIG domain-containing protein [Acidobacteriota bacterium] diamond 237 138 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota 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);;