RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA688352" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 13 ✖

bioproject 1

  • PRJNA688352 · 13 ✖

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
17244858 17244858 PRJNA688352_P_NODE_7574_length_250_cov_0.870056_g7471_i0 PRJNA688352 7574 250 0.870056 2.17514 uncultured delta proteobacterium Rifle_16ft_4_minimus_184 1665175 Bacteria Bacteria 363 9.209999999999997e-96   NTclustered gi|874574271|gb|KT006965.1| 1665175 g7471 i0 92.8 35.2 250 18 100 0 1 250 37666 37915 Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence blastn 8800 363 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium Rifle_16ft_4_minimus_184
19793834 19793834 PRJNA688352_P_NODE_8676_length_248_cov_0.880000_g8573_i0 PRJNA688352 8676 248 0.88 2.1824 Pseudomonadati 3379134 Bacteria Bacteria 89 3.82e-20   NR PIU53853.1 1973972 g8573 i0 100 2.47983870967742 41 0 49.6 0 124 246 1 41 PIU53853.1 MAG: glycine--tRNA ligase subunit alpha, partial [Deltaproteobacteria bacterium CG07_land_8_20_14_0_80_60_11] diamond 615 89 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG07_land_8_20_14_0_80_60_11
23619752 23619752 PRJNA688352_P_NODE_7699_length_250_cov_0.870056_g7596_i0 PRJNA688352 7699 250 0.870056 2.17514 Deltaproteobacteria bacterium GWC2_65_14 1797820 Bacteria Bacteria 64.7 5.49e-10   NR OGP33862.1 1797820 g7596 i0 83.3 0.432 36 6 43.2 0 249 142 270 305 OGP33862.1 MAG: tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [Deltaproteobacteria bacterium GWC2_65_14] diamond 108 64.7 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium GWC2_65_14
27714461 27714461 PRJNA688352_P_NODE_8544_length_248_cov_0.880000_g8441_i0 PRJNA688352 8544 248 0.88 2.1824 Deltaproteobacteria bacterium CG 2026735 Bacteria Bacteria 169 7.819999999999998e-48   NR PIV19681.1 1973969 g8441 i0 95.1 1.98387096774194 82 4 99.2 0 2 247 191 272 PIV19681.1 MAG: menaquinol oxidoreductase [Deltaproteobacteria bacterium CG03_land_8_20_14_0_80_45_14] diamond 492 169 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG03_land_8_20_14_0_80_45_14
28282143 28282143 PRJNA688352_P_NODE_7106_length_251_cov_0.865169_g7003_i0 PRJNA688352 7106 251 0.865169 2.17157419 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12 2013739 Bacteria Bacteria 57 1.88e-8   NR PKN70258.1 2013739 g7003 i0 76.5 2.0796812749004 34 8 40.6 0 140 241 9 42 PKN70258.1 MAG: hypothetical protein CVU54_06545 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12] diamond 522 57 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12
29114964 29114964 PRJNA688352_P_NODE_8788_length_248_cov_0.880000_g8685_i0 PRJNA688352 8788 248 0.88 2.1824 Pseudomonadati 3379134 Bacteria Bacteria 73.6 1.21e-14   NR KPJ74165.1 1703398 g8685 i0 71.4 2.37096774193548 49 14 59.3 0 1 147 62 110 KPJ74165.1 MAG: hypothetical protein AMJ54_17290, partial [Deltaproteobacteria bacterium SG8_13] diamond 588 74.3 0.990578734858681 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium SG8_13
30019222 30019222 PRJNA688352_P_NODE_10311_length_245_cov_0.895349_g10208_i0 PRJNA688352 10311 245 0.895349 2.19360505 Deltaproteobacteria bacterium RBG_19FT_COMBO_43_11 1797849 Bacteria Bacteria 105 3.81e-25   NR OGP91045.1 1797849 g10208 i0 63 0.991836734693878 81 30 99.2 0 243 1 6 86 OGP91045.1 MAG: signal peptidase [Deltaproteobacteria bacterium RBG_19FT_COMBO_43_11] diamond 243 105 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_19FT_COMBO_43_11
30240257 30240257 PRJNA688352_P_NODE_11572_length_242_cov_0.911243_g11469_i0 PRJNA688352 11572 242 0.911243 2.20520806 Deltaproteobacteria bacterium SG8_13 1703398 Bacteria Bacteria 58.2 2.51e-8   NR KPJ75401.1 1703398 g11469 i0 77.4 0.384297520661157 31 7 38.4 0 149 241 1 31 KPJ75401.1 MAG: hypothetical protein AMJ54_15065 [Deltaproteobacteria bacterium SG8_13] diamond 93 58.2 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium SG8_13
30650705 30650705 PRJNA688352_P_NODE_12233_length_241_cov_0.916667_g12130_i0 PRJNA688352 12233 241 0.916667 2.20916747 Deltaproteobacteria bacterium IMCC39524 3039107 Bacteria Bacteria 153 8.279999999999999e-43   NR MDG5468896.1 3039107 g12130 i0 98.8 0.995850622406639 80 1 99.6 0 240 1 158 237 MDG5468896.1 hypothetical protein [Deltaproteobacteria bacterium IMCC39524] diamond 240 153 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium IMCC39524
31093290 31093290 PRJNA688352_P_NODE_10135_length_245_cov_0.895349_g10032_i0 PRJNA688352 10135 245 0.895349 2.19360505 Deltaproteobacteria bacterium CG 2026735 Bacteria Bacteria 49.7 1.16e-5   NR PIV21295.1 1973969 g10032 i0 88.5 0.318367346938775 26 3 31.8 0 1 78 54 79 PIV21295.1 MAG: hypothetical protein COS40_08100 [Deltaproteobacteria bacterium CG03_land_8_20_14_0_80_45_14] diamond 78 49.7 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG03_land_8_20_14_0_80_45_14
31156159 31156159 PRJNA688352_P_NODE_9735_length_246_cov_0.890173_g9632_i0 PRJNA688352 9735 246 0.890173 2.18982558 Deltaproteobacteria bacterium RBG_19FT_COMBO_46_12 1797850 Bacteria Bacteria 163 6.98e-48   NR OGQ12886.1 1797850 g9632 i0 97.6 2 82 2 100 0 1 246 161 242 OGQ12886.1 MAG: homoserine dehydrogenase, partial [Deltaproteobacteria bacterium RBG_19FT_COMBO_46_12] diamond 492 163 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_19FT_COMBO_46_12
32180403 32180403 PRJNA688352_P_NODE_9838_length_246_cov_0.890173_g9735_i0 PRJNA688352 9838 246 0.890173 2.18982558 Thermodesulfobacteriota 200940 Bacteria Bacteria 153 2.31e-44   NR PIU54525.1 1973972 g9735 i0 93.8 2.96341463414634 81 5 98.8 0 3 245 142 222 PIU54525.1 MAG: acyl-ACP--UDP-N-acetylglucosamine O-acyltransferase [Deltaproteobacteria bacterium CG07_land_8_20_14_0_80_60_11] diamond 729 153 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG07_land_8_20_14_0_80_60_11
32863308 32863308 PRJNA688352_P_NODE_9720_length_246_cov_0.890173_g9617_i0 PRJNA688352 9720 246 0.890173 2.18982558 Deltaproteobacteria bacterium CG2_3 2026735 Bacteria Bacteria 144 7.979999999999998e-41   NR OIP33214.1 1805127 g9617 i0 86.3 1.78048780487805 73 10 89 0 244 26 185 257 OIP33214.1 MAG: hypothetical protein AUK27_10985 [Deltaproteobacteria bacterium CG2_30_66_27] diamond 438 144 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG2_30_66_27

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