RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA702290" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 3

tax_clade 2

tax_superkingdom 1

  • Bacteria · 26 ✖

bioproject 1

  • PRJNA702290 · 26 ✖

analysis 1

  • diamond · 26 ✖
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
23636666 23636666 PRJNA702290_P_NODE_1379_length_175_cov_9.573529_g1371_i0 PRJNA702290 1379 175 9.573529 16.75367575 Lawsonella 1847725 Bacteria Bacteria 110 2.17e-27   NR WP_290595264.1 1847725 g1371 i0 100 0.96 56 0 96 0 8 175 197 252 WP_290595264.1 MULTISPECIES: type I glyceraldehyde-3-phosphate dehydrogenase [Lawsonella] diamond 168 110 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
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.
27019545 27019545 PRJNA702290_P_NODE_902_length_191_cov_10.500000_g894_i0 PRJNA702290 902 191 10.5 20.055 Hymenobacter setariae 2594794 Bacteria Bacteria 95.9 1.88e-22   NR WP_144843868.1 2594794 g894 i0 74.2 2.92146596858639 62 9 97.4 1 190 5 5 59 WP_144843868.1 pirin family protein [Hymenobacter setariae] diamond 558 95.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Hymenobacter Hymenobacter setariae
27903811 27903811 PRJNA702290_P_NODE_1505_length_159_cov_44.408333_g1497_i0 PRJNA702290 1505 159 44.408333 70.60924947 Actinomycetota bacterium 2900548 Bacteria Bacteria 55.1 5.39e-7   NR MEN9962630.1 2900548 g1497 i0 100 0.471698113207547 25 0 47.2 0 7 81 90 114 MEN9962630.1 hypothetical protein [Actinomycetota bacterium] diamond 75 55.1 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28282704 28282704 PRJNA702290_P_NODE_2006_length_153_cov_28.385965_g1998_i0 PRJNA702290 2006 153 28.385965 43.43052645 Lawsonella clevelandensis 1528099 Bacteria Bacteria 99.4 8.809999999999999e-23   NR WP_304161253.1 1528099 g1998 i0 97.9 0.941176470588235 48 1 94.1 0 145 2 177 224 WP_304161253.1 purple acid phosphatase family protein [Lawsonella clevelandensis] diamond 144 99.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
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
28609841 28609841 PRJNA702290_P_NODE_2007_length_153_cov_27.815789_g1999_i0 PRJNA702290 2007 153 27.815789 42.55815717 Pseudomonadati 3379134 Bacteria Bacteria 60.1 7.98e-9   NR OIO03162.1 1805130 g1999 i0 70 3.58823529411765 40 12 78.4 0 128 9 106 145 OIO03162.1 MAG: capsid protein [Desulfovibrionaceae bacterium CG1_02_65_16] diamond 549 60.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium CG1_02_65_16
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
28914163 28914163 PRJNA702290_P_NODE_2108_length_151_cov_7.464286_g2100_i0 PRJNA702290 2108 151 7.464286 11.27107186 uncultured Cellulomonas sp. 189682 Bacteria Bacteria 79.7 2.06e-16   NR WP_315095514.1 189682 g2100 i0 81.5 2.08609271523179 54 6 99.3 1 1 150 16 69 WP_315095514.1 helix-turn-helix transcriptional regulator [uncultured Cellulomonas sp.] diamond 315 79.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Cellulomonas uncultured Cellulomonas sp.
28977697 28977697 PRJNA702290_P_NODE_1708_length_158_cov_6.327731_g1700_i0 PRJNA702290 1708 158 6.327731 9.99781498 Leucobacter manosquensis 2810611 Bacteria Bacteria 50.8 1.09e-5   NR WP_211648413.1 2810611 g1700 i0 64.4 0.854430379746835 45 11 75.9 1 8 127 163 207 WP_211648413.1 hypothetical protein [Leucobacter manosquensis] diamond 135 50.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leucobacter Leucobacter manosquensis
29640264 29640264 PRJNA702290_P_NODE_1130_length_191_cov_4.789474_g1122_i0 PRJNA702290 1130 191 4.789474 9.14789534 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 57.8 8.93e-8   NR RYD79216.1 2026800 g1122 i0 100 0.392670157068063 25 0 39.3 0 188 114 328 352 RYD79216.1 MAG: ATP-binding cassette domain-containing protein, partial [Verrucomicrobiaceae bacterium] diamond 75 57.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
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.
30399225 30399225 PRJNA702290_P_NODE_593_length_191_cov_22.967105_g585_i0 PRJNA702290 593 191 22.967105 43.86717055 Opitutaceae bacterium 2006848 Bacteria Bacteria 52.4 7.36e-6   NR MBL9200456.1 2006848 g585 i0 96 0.392670157068063 25 1 39.3 0 76 2 203 227 MBL9200456.1 hypothetical protein [Opitutaceae bacterium] diamond 75 52.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
30430712 30430712 PRJNA702290_P_NODE_2153_length_150_cov_7.567568_g2145_i0 PRJNA702290 2153 150 7.567568 11.351352 Fimbriiglobus sp. 1914235 Bacteria Bacteria 46.6 1.27e-4   NR MCU0705257.1 1914235 g2145 i0 86.4 0.44 22 3 44 0 4 69 21 42 MCU0705257.1 hypothetical protein [Fimbriiglobus sp.] diamond 66 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Fimbriiglobus Fimbriiglobus 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
30809484 30809484 PRJNA702290_P_NODE_1314_length_187_cov_1.250000_g1306_i0 PRJNA702290 1314 187 1.25 2.3375 Brachybacterium fresconis 173363 Bacteria Bacteria 43.5 6.66e-4   NR GAA1487249.1 173363 g1306 i0 57.1 0.561497326203209 35 15 56.1 0 115 11 2 36 GAA1487249.1 hypothetical protein GCM10009625_40540 [Brachybacterium fresconis] diamond 105 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium Brachybacterium fresconis
30852178 30852178 PRJNA702290_P_NODE_1134_length_191_cov_4.730263_g1126_i0 PRJNA702290 1134 191 4.730263 9.03480233 Lawsonella 1847725 Bacteria Bacteria 77 1.17e-15   NR PZP88504.1 1528099 g1126 i0 78.2 2.59162303664921 55 11 86.4 1 189 25 96 149 PZP88504.1 MAG: nucleotide exchange factor GrpE [Lawsonella clevelandensis] diamond 495 77 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
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
31726224 31726224 PRJNA702290_P_NODE_777_length_191_cov_13.328947_g769_i0 PRJNA702290 777 191 13.328947 25.45828877 Arthrobacter sp. NPDC 1667 Bacteria Bacteria 48.1 2.22e-4   NR WP_400484826.1 3363943 g769 i0 95.8 0.37696335078534 24 1 37.7 0 112 183 115 138 WP_400484826.1 C40 family peptidase [Arthrobacter sp. NPDC092385] diamond 72 48.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter sp. NPDC092385
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.
32105913 32105913 PRJNA702290_P_NODE_958_length_191_cov_9.151316_g950_i0 PRJNA702290 958 191 9.151316 17.47901356 Actinomyces oris 544580 Bacteria Bacteria 64.7 1.82e-10   NR WP_314179067.1 544580 g950 i0 48.3 0.942408376963351 60 27 94.2 1 185 6 64 119 WP_314179067.1 DUF4145 domain-containing protein [Actinomyces oris] diamond 180 64.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces oris
32169467 32169467 PRJNA702290_P_NODE_1018_length_191_cov_7.973684_g1010_i0 PRJNA702290 1018 191 7.973684 15.22973644 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 48.5 1.33e-4   NR WP_017869193.1 980427 g1010 i0 79.2 0.37696335078534 24 5 37.7 0 184 113 31 54 WP_017869193.1 hypothetical protein [Deinococcus wulumuqiensis] diamond 72 48.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
32370424 32370424 PRJNA702290_P_NODE_1699_length_158_cov_7.630252_g1691_i0 PRJNA702290 1699 158 7.630252 12.05579816 Bacteroidota 976 Bacteria Bacteria 52.8 3.37e-6   NR TAK36285.1 2202734 g1691 i0 92.3 3.9493670886076 26 2 49.4 0 3 80 277 302 TAK36285.1 MAG: xylose isomerase [Saprospiraceae bacterium] diamond 624 52.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
32685928 32685928 PRJNA702290_P_NODE_1160_length_191_cov_4.131579_g1152_i0 PRJNA702290 1160 191 4.131579 7.8913158900000004 Bacteria 2 Bacteria Bacteria 85.5 8.6e-20   NR WP_414057742.1 1280 g1152 i0 72.1 3.83246073298429 61 10 95.8 1 185 3 49 102 WP_414057742.1 Dps family protein, partial [Staphylococcus aureus] diamond 732 85.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
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);;