RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA415856" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 24 ✖

bioproject 1

  • PRJNA415856 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
1694276 1694276 PRJNA415856_P_NODE_50342_length_162_cov_0.902655_g50081_i0 PRJNA415856 50342 162 0.902655 1.4623011 Planctomycetota bacterium 2026780 Bacteria Bacteria 105 1.48e-25   NR MDQ3439808.1 2026780 g50081 i0 88.5 1.92592592592593 52 6 96.3 0 5 160 38 89 MDQ3439808.1 sugar phosphate isomerase/epimerase [Planctomycetota bacterium] diamond 312 105 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
4246377 4246377 PRJNA415856_P_NODE_32864_length_170_cov_1.264463_g32603_i0 PRJNA415856 32864 170 1.264463 2.1495871 root 1 Root_unresolved Root_unresolved 98.2 2.92e-22   NR MBN2712999.1 2026780 g32603 i0 87.5 2.96470588235294 56 7 98.8 0 168 1 263 318 MBN2712999.1 adenosylhomocysteinase [Planctomycetota bacterium] diamond 504 99 0.991919191919192 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27186837 27186837 PRJNA415856_P_NODE_23522_length_186_cov_1.489051_g23261_i0 PRJNA415856 23522 186 1.489051 2.76963486 Luteolibacter 518753 Bacteria Bacteria 125 8.019999999999999e-32   NR WP_264503544.1 1859460 g23261 i0 96.8 9 62 2 100 0 186 1 141 202 WP_264503544.1 ATP-binding cassette domain-containing protein [Luteolibacter flavescens] diamond 1674 126 0.992063492063492 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter flavescens
27328573 27328573 PRJNA415856_P_NODE_48903_length_162_cov_0.902655_g48642_i0 PRJNA415856 48903 162 0.902655 1.4623011 Gemmataceae bacterium 2052164 Bacteria Bacteria 91.3 2.2e-20   NR MDB5313536.1 2052164 g48642 i0 83 1.96296296296296 53 9 98.1 0 161 3 95 147 MDB5313536.1 dihydroorotate dehydrogenase [Gemmataceae bacterium] diamond 318 91.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27391809 27391809 PRJNA415856_P_NODE_38963_length_166_cov_0.871795_g38702_i0 PRJNA415856 38963 166 0.871795 1.4471797 Pirellulaceae bacterium 2699754 Bacteria Bacteria 45.8 0.00108   NR HTN74522.1 2699754 g38702 i0 43.8 0.867469879518072 48 27 86.7 0 145 2 305 352 HTN74522.1 BBP7 family outer membrane beta-barrel protein [Pirellulaceae bacterium] diamond 144 45.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
27534593 27534593 PRJNA415856_P_NODE_42223_length_165_cov_0.879310_g41962_i0 PRJNA415856 42223 165 0.87931 1.4508615 Terrimicrobium 1649503 Bacteria Bacteria 107 1.63e-25   NR HEY5770341.1 1965319 g41962 i0 98.2 3 55 1 100 0 165 1 24 78 HEY5770341.1 outer membrane protein assembly factor BamA [Terrimicrobium sp.] diamond 495 107 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Terrimicrobiia Terrimicrobiales Terrimicrobiaceae Terrimicrobium Terrimicrobium sp.
27724399 27724399 PRJNA415856_P_NODE_47804_length_163_cov_0.877193_g47543_i0 PRJNA415856 47804 163 0.877193 1.42982459 Pseudomonadati 3379134 Bacteria Bacteria 100 1.4000000000000002e-23   NR MDZ4683813.1 2026779 g47543 i0 83 7.80368098159509 53 9 97.5 0 1 159 223 275 MDZ4683813.1 isochorismatase family protein [Planctomycetaceae bacterium] diamond 1272 100 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
27770759 27770759 PRJNA415856_P_NODE_53244_length_161_cov_0.910714_g52983_i0 PRJNA415856 53244 161 0.910714 1.46624954 Luteolibacter sp. 1962973 Bacteria Bacteria 87.4 1.85e-18   NR MEO7098658.1 1962973 g52983 i0 84 1.91925465838509 50 8 93.2 0 151 2 213 262 MEO7098658.1 MBL fold metallo-hydrolase [Luteolibacter sp.] diamond 309 87.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp.
28307310 28307310 PRJNA415856_P_NODE_34266_length_168_cov_1.226891_g34005_i0 PRJNA415856 34266 168 1.226891 2.06117688 Pirellulaceae bacterium 2699754 Bacteria Bacteria 60.8 2.7e-9   NR HZN36815.1 2699754 g34005 i0 75.8 1.17857142857143 33 8 58.9 0 168 70 189 221 HZN36815.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex dimerization subunit type 1 TsaB [Pirellulaceae bacterium] diamond 198 60.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
28465296 28465296 PRJNA415856_P_NODE_47406_length_163_cov_0.894737_g47145_i0 PRJNA415856 47406 163 0.894737 1.45842131 Gemmataceae bacterium 2052164 Bacteria Bacteria 67.8 1.86e-11   NR HYV37295.1 2052164 g47145 i0 66 0.865030674846626 47 16 86.5 0 2 142 339 385 HYV37295.1 6-pyruvoyl-tetrahydropterin synthase-related protein [Gemmataceae bacterium] diamond 141 67.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28654653 28654653 PRJNA415856_P_NODE_52867_length_161_cov_0.910714_g52606_i0 PRJNA415856 52867 161 0.910714 1.46624954 Parachlamydia acanthamoebae 83552 Bacteria Bacteria 82.4 3.14e-17   NR WP_006340766.1 83552 g52606 i0 67.9 0.987577639751553 53 17 98.8 0 160 2 26 78 WP_006340766.1 outer membrane protein [Parachlamydia acanthamoebae] diamond 159 82.4 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Parachlamydia Parachlamydia acanthamoebae
28717861 28717861 PRJNA415856_P_NODE_47687_length_163_cov_0.894737_g47426_i0 PRJNA415856 47687 163 0.894737 1.45842131 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 40.4 0.0402   NR MBU1694158.1 2026799 g47426 i0 41 0.717791411042945 39 23 71.8 0 133 17 88 126 MBU1694158.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 117 40.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29160012 29160012 PRJNA415856_P_NODE_23009_length_187_cov_1.463768_g22748_i0 PRJNA415856 23009 187 1.463768 2.73724616 Candidatus Spyradenecus faecavium 2840947 Bacteria Bacteria 80.5 1.33e-16   NR HIV09478.1 2840947 g22748 i0 100 0.641711229946524 40 0 64.2 0 122 3 143 182 HIV09478.1 rRNA pseudouridine synthase [Candidatus Spyradenecus faecavium] diamond 120 80.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Lentisphaerales Lentisphaeraceae Candidatus Spyradenecus Candidatus Spyradenecus faecavium
29380808 29380808 PRJNA415856_P_NODE_48789_length_162_cov_0.902655_g48528_i0 PRJNA415856 48789 162 0.902655 1.4623011 Haloferula sp. 2497595 Bacteria Bacteria 99 9.99e-25   NR HEY1122096.1 2497595 g48528 i0 96.2 1.96296296296296 53 2 98.1 0 2 160 48 100 HEY1122096.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Haloferula sp.] diamond 318 99 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Haloferula Haloferula sp.
29633004 29633004 PRJNA415856_P_NODE_39190_length_166_cov_0.871795_g38929_i0 PRJNA415856 39190 166 0.871795 1.4471797 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 77 1.04e-14   NR MEO6434528.1 2876886 g38929 i0 68.4 2.02409638554217 57 15 97.6 2 3 164 591 647 MEO6434528.1 S8 family serine peptidase [Tepidisphaeraceae bacterium] diamond 336 77 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
29712783 29712783 PRJNA415856_P_NODE_37050_length_166_cov_2.145299_g36789_i0 PRJNA415856 37050 166 2.145299 3.56119634 Bacteria 2 Bacteria Bacteria 75.1 3.9e-15   NR WP_145201570.1 2527994 g36789 i0 61.4 16.3373493975904 57 20 99.4 1 166 2 82 138 WP_145201570.1 peptide-methionine (S)-S-oxide reductase MsrA [Thalassoglobus polymorphus] diamond 2712 75.5 0.994701986754967 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Thalassoglobus Thalassoglobus polymorphus
29791079 29791079 PRJNA415856_P_NODE_21451_length_190_cov_1.446809_g21190_i0 PRJNA415856 21451 190 1.446809 2.7489371 Planctomycetales bacterium 2053591 Bacteria Bacteria 65.1 1.55e-10   NR MCA9203155.1 2053591 g21190 i0 69.5 1.89473684210526 59 17 93.2 1 9 185 174 231 MCA9203155.1 hypothetical protein [Planctomycetales bacterium] diamond 360 65.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
30075453 30075453 PRJNA415856_P_NODE_51932_length_161_cov_0.910714_g51671_i0 PRJNA415856 51932 161 0.910714 1.46624954 Opitutaceae bacterium 2006848 Bacteria Bacteria 89.7 7.86e-20   NR HWA08628.1 2006848 g51671 i0 78.8 0.968944099378882 52 11 96.9 0 6 161 33 84 HWA08628.1 outer membrane lipoprotein-sorting protein [Opitutaceae bacterium] diamond 156 89.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
30549445 30549445 PRJNA415856_P_NODE_633_length_1162_cov_4.915544_g527_i0 PRJNA415856 633 1162 4.915544 57.11862128 Planctomycetota bacterium 2026780 Bacteria Bacteria 78.6 1.89e-12   NR MDZ4821649.1 2026780 g527 i0 41.2 0.307228915662651 119 63 30.7 3 89 445 63 174 MDZ4821649.1 SAM-dependent DNA methyltransferase [Planctomycetota bacterium] diamond 357 78.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31466240 31466240 PRJNA415856_P_NODE_49816_length_162_cov_0.902655_g49555_i0 PRJNA415856 49816 162 0.902655 1.4623011 Planctomycetota bacterium 2026780 Bacteria Bacteria 65.9 8.87e-11   NR MCY2961048.1 2026780 g49555 i0 57.4 3 54 23 100 0 162 1 637 690 MCY2961048.1 HEAT repeat domain-containing protein [Planctomycetota bacterium] diamond 486 65.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31908893 31908893 PRJNA415856_P_NODE_40897_length_165_cov_0.879310_g40636_i0 PRJNA415856 40897 165 0.87931 1.4508615 Luteolibacter sp. 1962973 Bacteria Bacteria 77.4 2.74e-16   NR MEP2774824.1 1962973 g40636 i0 54.5 2 55 25 100 0 1 165 33 87 MEP2774824.1 hypothetical protein [Luteolibacter sp.] diamond 330 77.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp.
32225408 32225408 PRJNA415856_P_NODE_49638_length_162_cov_0.902655_g49377_i0 PRJNA415856 49638 162 0.902655 1.4623011 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 94.7 3.46e-21   NR HXA08440.1 2201154 g49377 i0 79.2 0.981481481481482 53 11 98.1 0 162 4 127 179 HXA08440.1 diaminopimelate decarboxylase [Chthoniobacterales bacterium] diamond 159 94.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
32288956 32288956 PRJNA415856_P_NODE_43259_length_164_cov_0.886957_g42998_i0 PRJNA415856 43259 164 0.886957 1.45460948 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 49.3 2.16e-5   NR HTL30426.1 2876886 g42998 i0 56.3 0.878048780487805 48 20 87.8 1 2 145 65 111 HTL30426.1 VCBS repeat-containing protein [Tepidisphaeraceae bacterium] diamond 144 49.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
32667667 32667667 PRJNA415856_P_NODE_30180_length_174_cov_1.560000_g29919_i0 PRJNA415856 30180 174 1.56 2.7144 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 104 2.1499999999999998e-24   NR MCA9076099.1 2026779 g29919 i0 86 2.94827586206897 57 8 98.3 0 173 3 694 750 MCA9076099.1 excinuclease ABC subunit A [Planctomycetaceae bacterium] diamond 513 104 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae 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);;