RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA816047" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA816047 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
25905051 25905051 PRJNA816047a_S_NODE_40387_length_328_cov_1.062745_g37727_i0 PRJNA816047 40387 328 1.062745 3.4858036 Roseimicrobium sp. 3069589 Bacteria Bacteria 85.5 1.06e-16   NR MEZ0274788.1 3069589 g37727 i0 56.3 1.54573170731707 87 33 79.6 2 46 306 167 248 MEZ0274788.1 beta strand repeat-containing protein [Roseimicrobium sp.] diamond 507 85.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Roseimicrobium Roseimicrobium sp.
26149831 26149831 PRJNA816047d_S_NODE_63165_length_286_cov_0.961373_g61330_i0 PRJNA816047 63165 286 0.961373 2.74952678 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 150 3.41e-42   NR RYD36426.1 2026800 g61330 i0 82.4 0.954545454545455 91 16 95.5 0 285 13 100 190 RYD36426.1 MAG: alpha/beta hydrolase [Verrucomicrobiaceae bacterium] diamond 273 150 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
26449136 26449136 PRJNA816047a_S_NODE_24279_length_413_cov_3149.241176_g21623_i0 PRJNA816047 24279 413 3149.241176 13006.36605688 Haloferula chungangensis 1048331 Bacteria Bacteria 152 1.47e-39   NR WP_379707759.1 1048331 g21623 i0 64.1 1.49636803874092 103 37 74.8 0 348 40 816 918 WP_379707759.1 PAS domain S-box protein [Haloferula chungangensis] diamond 618 152 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Haloferula Haloferula chungangensis
32938589 32938589 PRJNA816047b_S_NODE_12673_length_433_cov_3.422222_g10371_i0 PRJNA816047 12673 433 3.422222 14.81822126 Prosthecobacter debontii 48467 Bacteria Bacteria 53.5 4.89e-5   NR WP_078813368.1 48467 g10371 i0 37.8 0.623556581986143 90 50 60.3 2 399 139 656 742 WP_078813368.1 serine/threonine-protein kinase [Prosthecobacter debontii] diamond 270 53.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter debontii
32942235 32942235 PRJNA816047d_S_NODE_40305_length_340_cov_5.557491_g38470_i0 PRJNA816047 40305 340 5.557491 18.8954694 Bacteria 2 Bacteria Bacteria 129 6.71e-34   NR HTJ73457.1 2499141 g38470 i0 59.4 3.55588235294118 101 41 89.1 0 308 6 91 191 HTJ73457.1 hypothetical protein [Verrucomicrobiia bacterium] diamond 1209 129 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
32990686 32990686 PRJNA816047d_S_NODE_57347_length_296_cov_1.967078_g55512_i0 PRJNA816047 57347 296 1.967078 5.82255088 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 107 7.25e-25   NR PYJ87490.1 2026799 g55512 i0 57.3 3.90202702702703 96 40 96.3 1 289 5 95 190 PYJ87490.1 MAG: chloroperoxidase [Verrucomicrobiota bacterium] diamond 1155 107 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32993417 32993417 PRJNA816047d_S_NODE_117539_length_242_cov_1.518519_g115704_i0 PRJNA816047 117539 242 1.518519 3.67481598 Prosthecobacter 48463 Bacteria Bacteria 115 6.919999999999999e-28   NR WP_217699031.1 48467 g115704 i0 78.5 1.95867768595041 79 17 97.9 0 1 237 446 524 WP_217699031.1 beta strand repeat-containing protein [Prosthecobacter debontii] diamond 474 115 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter debontii
33006963 33006963 PRJNA816047b_S_NODE_33451_length_291_cov_1.087156_g31139_i0 PRJNA816047 33451 291 1.087156 3.16362396 Prosthecobacter sp. 1965333 Bacteria Bacteria 73.2 1.35e-12   NR WP_409217981.1 1965333 g31139 i0 54.9 0.938144329896907 91 37 89.7 2 24 284 1197 1287 WP_409217981.1 beta strand repeat-containing protein [Prosthecobacter sp.] diamond 273 73.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
33007278 33007278 PRJNA816047d_S_NODE_21475_length_470_cov_4.390887_g19660_i0 PRJNA816047 21475 470 4.390887 20.6371689 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 126 2.24e-30   NR MBS0645922.1 2026799 g19660 i0 43.2 1.83191489361702 148 82 93.2 1 11 448 185 332 MBS0645922.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 861 126 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
33041166 33041166 PRJNA816047b_S_NODE_48972_length_248_cov_2.314286_g46660_i0 PRJNA816047 48972 248 2.314286 5.73942928 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 122 6.25e-31   NR HYG84138.1 2499141 g46660 i0 84.8 0.798387096774194 66 10 79.8 0 51 248 81 146 HYG84138.1 glycine--tRNA ligase [Verrucomicrobiia bacterium] diamond 198 122 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
33041263 33041263 PRJNA816047d_S_NODE_109236_length_246_cov_1.005181_g107401_i0 PRJNA816047 109236 246 1.005181 2.47274526 Verrucomicrobia bacterium ADurb.Bin474 1852931 Bacteria Bacteria 59.7 2.92e-8   NR OPZ70888.1 1852931 g107401 i0 45.3 2.84146341463415 75 39 90.2 2 22 243 70 143 OPZ70888.1 MAG: Chromosome partitioning protein ParA [Verrucomicrobia bacterium ADurb.Bin474] diamond 699 59.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobia bacterium ADurb.Bin474
33075065 33075065 PRJNA816047a_S_NODE_82637_length_233_cov_3.331250_g79977_i0 PRJNA816047 82637 233 3.33125 7.7618125 Verrucomicrobiaceae bacterium NT6N 2979115 Bacteria Bacteria 42.4 0.042   NR BDS07974.1 2979115 g79977 i0 44.2 0.553648068669528 43 23 55.4 1 130 2 234 275 BDS07974.1 xylanase [Verrucomicrobiaceae bacterium NT6N] diamond 129 42.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Oceaniferula Oceaniferula spumae
33078633 33078633 PRJNA816047b_S_NODE_20013_length_359_cov_4.090909_g17701_i0 PRJNA816047 20013 359 4.090909 14.68636331 Pseudomonadati 3379134 Bacteria Bacteria 209 1.75e-65   NR MDD4347736.1 2026772 g17701 i0 87.3 1.97214484679666 118 15 98.6 0 2 355 139 256 MDD4347736.1 hypothetical protein [Opitutales bacterium] diamond 708 210 0.995238095238095 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales bacterium
33092488 33092488 PRJNA816047d_S_NODE_103342_length_249_cov_0.943878_g101507_i0 PRJNA816047 103342 249 0.943878 2.35025622 Opitutaceae bacterium 2006848 Bacteria Bacteria 55.1 1.75e-6   NR HTX66835.1 2006848 g101507 i0 88.9 0.975903614457831 27 3 32.5 0 167 247 483 509 HTX66835.1 IS66 family transposase [Opitutaceae bacterium] diamond 243 55.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
33092761 33092761 PRJNA816047d_S_NODE_32510_length_374_cov_4.757009_g30676_i0 PRJNA816047 32510 374 4.757009 17.79121366 Opitutaceae bacterium 2006848 Bacteria Bacteria 63.5 1.26e-9   NR MEI6053640.1 2006848 g30676 i0 35.4 0.521390374331551 65 42 52.1 0 262 68 1 65 MEI6053640.1 hypothetical protein [Opitutaceae bacterium] diamond 195 63.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
33109137 33109137 PRJNA816047a_S_NODE_64966_length_263_cov_2.021053_g62306_i0 PRJNA816047 64966 263 2.021053 5.31536939 Candidatus Udaeobacter sp. 2665650 Bacteria Bacteria 43.1 0.0328   NR HWN82920.1 2665650 g62306 i0 56.1 0.467680608365019 41 18 46.8 0 213 91 3 43 HWN82920.1 hypothetical protein [Candidatus Udaeobacter sp.] diamond 123 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae Candidatus Udaeobacter Candidatus Udaeobacter sp.
33109420 33109420 PRJNA816047b_S_NODE_52486_length_243_cov_0.900000_g50174_i0 PRJNA816047 52486 243 0.9 2.187 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 90.5 2.58e-20   NR HXJ59401.1 2499141 g50174 i0 68.3 3.09876543209877 63 20 77.8 0 6 194 149 211 HXJ59401.1 YqaJ viral recombinase family protein [Verrucomicrobiia bacterium] diamond 753 90.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
33109466 33109466 PRJNA816047d_S_NODE_108302_length_246_cov_1.839378_g106467_i0 PRJNA816047 108302 246 1.839378 4.52486988 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 42.7 0.0377   NR HXI83499.1 2499141 g106467 i0 30.3 1.57317073170732 66 46 80.5 0 5 202 454 519 HXI83499.1 hypothetical protein [Verrucomicrobiia bacterium] diamond 387 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
33160641 33160641 PRJNA816047d_S_NODE_14104_length_617_cov_2.526596_g12475_i0 PRJNA816047 14104 617 2.526596 15.58909732 Prosthecobacter dejongeii 48465 Bacteria Bacteria 95.1 1.59e-21   NR WP_184205223.1 48465 g12475 i0 57 0.520259319286872 107 39 52 2 139 459 1 100 WP_184205223.1 hypothetical protein [Prosthecobacter dejongeii] diamond 321 95.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter dejongeii
33161021 33161021 PRJNA816047d_S_NODE_67816_length_278_cov_1.008889_g65981_i0 PRJNA816047 67816 278 1.008889 2.80471142 Opitutales bacterium 2026772 Bacteria Bacteria 51.2 7.34e-6   NR HLS28889.1 2026772 g65981 i0 40 0.539568345323741 50 30 54 0 2 151 44 93 HLS28889.1 MTH1187 family thiamine-binding protein [Opitutales bacterium] diamond 150 51.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales 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);;