RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 20 ✖

bioproject 1

  • PRJEB11748 · 20 ✖

analysis 1

  • diamond · 20 ✖

tax_phylum 0

tax_kingdom 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
17870980 17870980 PRJEB11748_P_NODE_42075_length_669_cov_16.847039_g40024_i0 PRJEB11748 42075 669 16.847039 112.70669091 Bacteria 2 Bacteria Bacteria 145 2.8e-36   NR OQB08498.1 1852869 g40024 i0 44.9 1.49775784753363 167 89 74.9 3 637 137 176 339 OQB08498.1 MAG: Serine/threonine-protein kinase pkn1 [Deltaproteobacteria bacterium ADurb.Bin207] diamond 1002 145 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium ADurb.Bin207
27627126 27627126 PRJEB11748_P_NODE_307544_length_216_cov_1.761290_g305361_i0 PRJEB11748 307544 216 1.76129 3.8043864 Bacteria 2 Bacteria Bacteria 70.1 5.92e-12   NR OGP20082.1 1797812 g305361 i0 50.8 2.76388888888889 65 32 90.3 0 211 17 117 181 OGP20082.1 MAG: hypothetical protein A2X90_03970 [Deltaproteobacteria bacterium GWA2_65_63] diamond 597 70.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium GWA2_65_63
27722099 27722099 PRJEB11748_P_NODE_260604_length_240_cov_7.642458_g258421_i0 PRJEB11748 260604 240 7.642458 18.3418992 Bacillota 1239 Bacteria Bacteria 86.3 1.63e-17   NR OGP14608.1 1797809 g258421 i0 53.6 2.5125 69 32 86.3 0 22 228 394 462 OGP14608.1 MAG: phosphoglycerate mutase (2,3-diphosphoglycerate-independent) [Deltaproteobacteria bacterium GWA2_55_10] diamond 603 86.3 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium GWA2_55_10
27948979 27948979 PRJEB11748_P_NODE_37505_length_715_cov_6.259939_g35527_i0 PRJEB11748 37505 715 6.259939 44.75856385 Deltaproteobacteria bacterium RIFCSPHIGHO2_ 2026735 Bacteria Bacteria 136 2.1799999999999996e-37   NR OGQ07090.1 1797859 g35527 i0 68.8 0.805594405594406 96 30 40.3 0 124 411 1 96 OGQ07090.1 MAG: hypothetical protein A3C45_05745 [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_28] diamond 576 136 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_28
28321517 28321517 PRJEB11748_P_NODE_280106_length_229_cov_7.898810_g277923_i0 PRJEB11748 280106 229 7.89881 18.0882749 Pseudomonadota 1224 Bacteria Bacteria 116 2.99e-29   NR CAD7845223.1 260707 g277923 i0 76.8 3.49781659388646 69 16 90.4 0 215 9 256 324 CAD7845223.1 MAG: hypothetical protein [Olavius algarvensis Delta 4 endosymbiont] diamond 801 116 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Olavius algarvensis Delta 4 endosymbiont
28700553 28700553 PRJEB11748_P_NODE_234307_length_257_cov_3.224490_g232124_i0 PRJEB11748 234307 257 3.22449 8.2869393 Myxococcota 2818505 Bacteria Bacteria 42.4 0.0387   NR PKN35946.1 2013746 g232124 i0 59.4 0.723735408560311 32 13 37.4 0 254 159 143 174 PKN35946.1 MAG: hypothetical protein CVU61_00125 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-19] diamond 186 42.4 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-19
28801137 28801137 PRJEB11748_P_NODE_150928_length_334_cov_2.827839_g148747_i0 PRJEB11748 150928 334 2.827839 9.44498226 Olavius algarvensis Delta 1 endosymbiont 334747 Bacteria Bacteria 57.8 6.15e-7   NR CAB1083110.1 334747 g148747 i0 36.2 0.844311377245509 94 57 83.5 2 35 313 3721 3812 CAB1083110.1 hypothetical protein D1AOALGA4SA_10694 [Olavius algarvensis Delta 1 endosymbiont] diamond 282 57.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Olavius algarvensis Delta 1 endosymbiont
29111054 29111054 PRJEB11748_P_NODE_360648_length_192_cov_5.190840_g358465_i0 PRJEB11748 360648 192 5.19084 9.9664128 Bacillati 1783272 Bacteria Bacteria 45.4 0.00217   NR OGQ84716.1 1797894 g358465 i0 56.3 2.21875 48 21 75 0 156 13 139 186 OGQ84716.1 MAG: hypothetical protein A3F90_12375 [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19] diamond 426 45.8 0.991266375545852 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19
29212055 29212055 PRJEB11748_P_NODE_313569_length_213_cov_3.026316_g311386_i0 PRJEB11748 313569 213 3.026316 6.44605308 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 2013741 Bacteria Bacteria 43.5 0.0135   NR PKN57776.1 2013741 g311386 i0 42.6 0.661971830985915 47 25 63.4 1 79 213 260 306 PKN57776.1 MAG: hypothetical protein CVU56_09260 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] diamond 141 43.5 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
29495977 29495977 PRJEB11748_P_NODE_236350_length_256_cov_1.205128_g234167_i0 PRJEB11748 236350 256 1.205128 3.08512768 SAR324 cluster bacterium 2024889 Bacteria Bacteria 59.3 6.38e-8   NR NQU64489.1 2024889 g234167 i0 46.8 1.8046875 79 35 87.9 4 2 226 283 358 NQU64489.1 DNA primase [SAR324 cluster bacterium] diamond 462 59.3 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       SAR324 cluster bacterium
30032964 30032964 PRJEB11748_P_NODE_256491_length_243_cov_1.785714_g254308_i0 PRJEB11748 256491 243 1.785714 4.33928502 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4 2013754 Bacteria Bacteria 57.4 2.61e-7   NR PKN12702.1 2013754 g254308 i0 44.8 0.827160493827161 67 35 81.5 2 198 1 309 374 PKN12702.1 MAG: NAD-dependent DNA ligase LigA [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4] diamond 201 57.4 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4
30184577 30184577 PRJEB11748_P_NODE_211732_length_274_cov_2.441315_g209549_i0 PRJEB11748 211732 274 2.441315 6.6892031 Bacteria 2 Bacteria Bacteria 52.4 1.98e-5   NR OGQ87365.1 1797905 g209549 i0 62.5 2.93430656934307 40 15 43.8 0 272 153 289 328 OGQ87365.1 MAG: hypothetical protein A2512_08430 [Deltaproteobacteria bacterium RIFOXYD12_FULL_56_24] diamond 804 52.4 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYD12_FULL_56_24
30374671 30374671 PRJEB11748_P_NODE_343312_length_201_cov_3.000000_g341129_i0 PRJEB11748 343312 201 3 6.03 Bacteria 2 Bacteria Bacteria 123 2.49e-31   NR NMC61765.1 2024889 g341129 i0 92.1 1.88059701492537 63 5 94 0 11 199 344 406 NMC61765.1 BREX system Lon protease-like protein BrxL [SAR324 cluster bacterium] diamond 378 124 0.991935483870968 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       SAR324 cluster bacterium
30475230 30475230 PRJEB11748_P_NODE_115593_length_386_cov_8.101538_g113419_i0 PRJEB11748 115593 386 8.101538 31.27193668 Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 1797895 Bacteria Bacteria 77.4 7.78e-15   NR OGQ90181.1 1797895 g113419 i0 48.3 0.691709844559586 89 46 69.2 0 91 357 7 95 OGQ90181.1 MAG: hypothetical protein A2289_19790 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] diamond 267 77.4 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
30949401 30949401 PRJEB11748_P_NODE_48274_length_619_cov_2.026882_g46178_i0 PRJEB11748 48274 619 2.026882 12.54639958 Lujinxingia vulgaris 2600176 Bacteria Bacteria 182 2.73e-53   NR WP_146983494.1 2600176 g46178 i0 77.8 0.567043618739903 117 26 56.7 0 268 618 1 117 WP_146983494.1 replication initiation protein, partial [Lujinxingia vulgaris] diamond 351 182 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Lujinxingiaceae Lujinxingia Lujinxingia vulgaris
31233308 31233308 PRJEB11748_P_NODE_239735_length_253_cov_8.406250_g237552_i0 PRJEB11748 239735 253 8.40625 21.2678125 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12 2013739 Bacteria Bacteria 43.1 0.0303   NR PKN70103.1 2013739 g237552 i0 31.5 0.865612648221344 73 50 86.6 0 236 18 176 248 PKN70103.1 MAG: hypothetical protein CVU54_06840 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12] diamond 219 43.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12
31796446 31796446 PRJEB11748_P_NODE_240617_length_253_cov_1.812500_g238434_i0 PRJEB11748 240617 253 1.8125 4.585625 Bacteria 2 Bacteria Bacteria 101 8.339999999999999e-23   NR CAB1055663.1 698986 g238434 i0 59.3 1.92094861660079 81 33 96 0 247 5 2712 2792 CAB1055663.1 hypothetical protein D1BOALGB6SA_396 [Olavius sp. associated proteobacterium Delta 1] diamond 486 101 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Olavius sp. associated proteobacterium Delta 1
31802627 31802627 PRJEB11748_P_NODE_186757_length_295_cov_9.670940_g184574_i0 PRJEB11748 186757 295 9.67094 28.529273 Deltaproteobacteria bacterium RIFCSPHIGHO2_ 2026735 Bacteria Bacteria 114 4.16e-29   NR OGQ06260.1 1797856 g184574 i0 91.4 0.589830508474576 58 5 59 0 26 199 52 109 OGQ06260.1 MAG: ribulose-phosphate 3-epimerase [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49] diamond 174 114 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
32113151 32113151 PRJEB11748_P_NODE_360518_length_192_cov_6.106870_g358335_i0 PRJEB11748 360518 192 6.10687 11.7251904 Bacteria 2 Bacteria Bacteria 82 2.44e-16   NR OGQ81332.1 1797894 g358335 i0 83.7 3.375 43 7 67.2 0 149 21 217 259 OGQ81332.1 MAG: hypothetical protein A3F90_03455 [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19] diamond 648 82.4 0.995145631067961 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19
32214344 32214344 PRJEB11748_P_NODE_80538_length_468_cov_4.948403_g78373_i0 PRJEB11748 80538 468 4.948403 23.15852604 Lujinxingia vulgaris 2600176 Bacteria Bacteria 202 1.03e-58   NR WP_146982960.1 2600176 g78373 i0 72.3 8.16025641025641 141 38 89.7 1 447 28 227 367 WP_146982960.1 DUF262 domain-containing protein [Lujinxingia vulgaris] diamond 3819 202 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Lujinxingiaceae Lujinxingia Lujinxingia vulgaris

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