RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1005695" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1005695 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
17579053 17579053 PRJNA1005695_P_NODE_8054_length_551_cov_2.669456_g7216_i0 PRJNA1005695 8054 551 2.669456 14.70870256 Planctomycetota bacterium 2026780 Bacteria Bacteria 271 2.6699999999999996e-88   NR MFH0911687.1 2026780 g7216 i0 81.6 1.78039927404719 163 30 88.7 0 63 551 2 164 MFH0911687.1 class II fructose-bisphosphate aldolase [Planctomycetota bacterium] diamond 981 271 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26622855 26622855 PRJNA1005695_P_NODE_39661_length_243_cov_0.917647_g38809_i0 PRJNA1005695 39661 243 0.917647 2.22988221 Planctomyces sp. 37635 Bacteria Bacteria 166 1.08e-50   NR MBL8816608.1 37635 g38809 i0 98.7 0.938271604938272 76 1 93.8 0 15 242 1 76 MBL8816608.1 2-C-methyl-D-erythritol 2,4-cyclodiphosphate synthase [Planctomyces sp.] diamond 228 166 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp.
27248293 27248293 PRJNA1005695_P_NODE_35343_length_251_cov_2.449438_g34491_i0 PRJNA1005695 35343 251 2.449438 6.14808938 Planctomycetota 203682 Bacteria Bacteria 85.1 5.1e-17   NR WP_207397605.1 980252 g34491 i0 55.4 5.95219123505976 83 33 99.2 2 2 250 138 216 WP_207397605.1 hypothetical protein [Bremerella alba] diamond 1494 85.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Bremerella Bremerella alba
27603403 27603403 PRJNA1005695_P_NODE_39544_length_243_cov_0.917647_g38692_i0 PRJNA1005695 39544 243 0.917647 2.22988221 Planctomycetota bacterium 2026780 Bacteria Bacteria 65.9 2.65e-10   NR NOT32013.1 2026780 g38692 i0 47 1.02469135802469 83 36 98.8 3 2 241 519 596 NOT32013.1 hypothetical protein [Planctomycetota bacterium] diamond 249 65.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27792772 27792772 PRJNA1005695_P_NODE_40004_length_242_cov_0.923077_g39152_i0 PRJNA1005695 40004 242 0.923077 2.23384634 Phycisphaerae bacterium 2026778 Bacteria Bacteria 143 3.14e-39   NR MBL9001027.1 2026778 g39152 i0 88.8 0.991735537190083 80 9 99.2 0 2 241 88 167 MBL9001027.1 DNA polymerase III subunit beta [Phycisphaerae bacterium] diamond 240 143 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
27918848 27918848 PRJNA1005695_P_NODE_29745_length_274_cov_1.243781_g28893_i0 PRJNA1005695 29745 274 1.243781 3.40795994 Phycisphaerae bacterium 2026778 Bacteria Bacteria 43.1 0.0385   NR MBN1342527.1 2026778 g28893 i0 36.5 0.81021897810219 74 44 77.7 1 45 257 202 275 MBN1342527.1 hypothetical protein [Phycisphaerae bacterium] diamond 222 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28202862 28202862 PRJNA1005695_P_NODE_34046_length_255_cov_1.434066_g33194_i0 PRJNA1005695 34046 255 1.434066 3.6568683 Gemmataceae bacterium 2052164 Bacteria Bacteria 43.5 0.00882   NR HZY84477.1 2052164 g33194 i0 43.5 0.811764705882353 69 26 75.3 5 249 58 1 61 HZY84477.1 DUF202 domain-containing protein [Gemmataceae bacterium] diamond 207 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28582133 28582133 PRJNA1005695_P_NODE_19007_length_346_cov_3.175824_g18155_i0 PRJNA1005695 19007 346 3.175824 10.98835104 Phycisphaerales bacterium 2052180 Bacteria Bacteria 82 2.01e-15   NR MCI0366357.1 2052180 g18155 i0 58.5 0.563583815028902 65 27 56.4 0 197 3 634 698 MCI0366357.1 polyribonucleotide nucleotidyltransferase [Phycisphaerales bacterium] diamond 195 82 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28739876 28739876 PRJNA1005695_P_NODE_38427_length_245_cov_1.360465_g37575_i0 PRJNA1005695 38427 245 1.360465 3.33313925 Phycisphaerae bacterium 2026778 Bacteria Bacteria 85.1 4.6e-17   NR HUO07305.1 2026778 g37575 i0 52.2 3.30612244897959 67 32 82 0 224 24 57 123 HUO07305.1 glucosamine-6-phosphate deaminase [Phycisphaerae bacterium] diamond 810 85.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28771379 28771379 PRJNA1005695_P_NODE_38127_length_246_cov_0.901734_g37275_i0 PRJNA1005695 38127 246 0.901734 2.21826564 Planctomycetota bacterium 2026780 Bacteria Bacteria 158 2.77e-44   NR MBL8899322.1 2026780 g37275 i0 95.1 0.98780487804878 81 4 98.8 0 245 3 71 151 MBL8899322.1 hypothetical protein [Planctomycetota bacterium] diamond 243 158 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29529297 29529297 PRJNA1005695_P_NODE_30710_length_269_cov_2.173469_g29858_i0 PRJNA1005695 30710 269 2.173469 5.84663161 Phycisphaerales bacterium 2052180 Bacteria Bacteria 43.9 0.02   NR UCG58142.1 2052180 g29858 i0 42.2 0.713754646840149 64 30 64.7 3 34 207 150 212 UCG58142.1 MAG: sodium-dependent transporter [Phycisphaerales bacterium] diamond 192 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30160628 30160628 PRJNA1005695_P_NODE_37032_length_248_cov_0.891429_g36180_i0 PRJNA1005695 37032 248 0.891429 2.21074392 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.1 0.0273   NR MEO1715621.1 2026780 g36180 i0 41.5 0.991935483870968 41 21 46 1 34 147 215 255 MEO1715621.1 hypothetical protein [Planctomycetota bacterium] diamond 246 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31583259 31583259 PRJNA1005695_P_NODE_8856_length_524_cov_4.547672_g8009_i0 PRJNA1005695 8856 524 4.547672 23.82980128 Mariniblastus fucicola 980251 Bacteria Bacteria 163 5.3899999999999997e-48   NR WP_075084412.1 980251 g8009 i0 57.1 0.801526717557252 140 57 80.2 2 421 2 4 140 WP_075084412.1 thiol peroxidase [Mariniblastus fucicola] diamond 420 163 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Mariniblastus Mariniblastus fucicola

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