RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1139127" 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 · 19 ✖

bioproject 1

  • PRJNA1139127 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
9213276 9213276 PRJNA1139127_P_NODE_44408_length_249_cov_0.880682_g43915_i0 PRJNA1139127 44408 249 0.880682 2.19289818 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 119 1.3999999999999996e-29   NR HNX34238.1 2212473 g43915 i0 73.8 1.01204819277108 84 21 100 1 1 249 285 368 HNX34238.1 hypothetical protein [Kiritimatiellia bacterium] diamond 252 119 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
9960447 9960447 PRJNA1139127_P_NODE_47768_length_244_cov_0.906433_g47275_i0 PRJNA1139127 47768 244 0.906433 2.21169652 Planctomycetota bacterium 2026780 Bacteria Bacteria 62.8 8.67e-10   NR HXX92357.1 2026780 g47275 i0 50 1.14344262295082 44 22 54.1 0 18 149 151 194 HXX92357.1 hypothetical protein [Planctomycetota bacterium] diamond 279 62.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
20158653 20158653 PRJNA1139127_P_NODE_12196_length_597_cov_2.353053_g11724_i0 PRJNA1139127 12196 597 2.353053 14.04772641 Planctomycetota bacterium 2026780 Bacteria Bacteria 298 2.1099999999999996e-99   NR HUR38556.1 2026780 g11724 i0 84.7 1.75376884422111 176 27 88.4 0 597 70 12 187 HUR38556.1 PEP/pyruvate-binding domain-containing protein [Planctomycetota bacterium] diamond 1047 298 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26849066 26849066 PRJNA1139127_P_NODE_27441_length_340_cov_1.749064_g26949_i0 PRJNA1139127 27441 340 1.749064 5.9468176 Gemmataceae bacterium 2052164 Bacteria Bacteria 152 6.419999999999998e-43   NR HWG46139.1 2052164 g26949 i0 71.4 0.864705882352941 98 28 86.5 0 5 298 157 254 HWG46139.1 ABC transporter permease subunit [Gemmataceae bacterium] diamond 294 152 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27070355 27070355 PRJNA1139127_P_NODE_49622_length_236_cov_2.098160_g49129_i0 PRJNA1139127 49622 236 2.09816 4.9516576 Planctomycetota bacterium 2026780 Bacteria Bacteria 71.6 2.2e-12   NR MBI5865398.1 2026780 g49129 i0 63.8 0.597457627118644 47 17 59.7 0 228 88 73 119 MBI5865398.1 immunoglobulin domain-containing protein [Planctomycetota bacterium] diamond 141 71.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27481186 27481186 PRJNA1139127_P_NODE_31303_length_311_cov_1.197479_g30810_i0 PRJNA1139127 31303 311 1.197479 3.72415969 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 44.7 0.0175   NR MES2476925.1 2026799 g30810 i0 41.8 0.530546623794212 55 29 53.1 1 76 240 373 424 MES2476925.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 165 44.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27828531 27828531 PRJNA1139127_P_NODE_31584_length_309_cov_1.309322_g31091_i0 PRJNA1139127 31584 309 1.309322 4.04580498 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.1 0.0117   NR MBN8643811.1 2026780 g31091 i0 38.9 0.524271844660194 54 31 52.4 1 15 176 283 334 MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium] diamond 162 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27986393 27986393 PRJNA1139127_P_NODE_42305_length_252_cov_0.871508_g41812_i0 PRJNA1139127 42305 252 0.871508 2.19620016 Fimbriiglobus ruber 1908690 Bacteria Bacteria 104 9.249999999999999e-24   NR WP_238602609.1 1908690 g41812 i0 63.4 1.10714285714286 93 25 100 2 252 1 960 1052 WP_238602609.1 PVC-type heme-binding CxxCH protein [Fimbriiglobus ruber] diamond 279 104 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Fimbriiglobus Fimbriiglobus ruber
28207211 28207211 PRJNA1139127_P_NODE_10726_length_649_cov_3.083333_g10263_i0 PRJNA1139127 10726 649 3.083333 20.01083117 Planctopirus 1649480 Bacteria Bacteria 76.6 3.52e-14   NR WP_041401598.1 1649480 g10263 i0 41.1 0.869029275808937 90 53 41.6 0 172 441 18 107 WP_041401598.1 MULTISPECIES: hypothetical protein [Planctopirus] diamond 564 76.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctopirus  
28618020 28618020 PRJNA1139127_P_NODE_25927_length_354_cov_1.106762_g25435_i0 PRJNA1139127 25927 354 1.106762 3.91793748 Gemmataceae bacterium 2052164 Bacteria Bacteria 48.9 2.07e-4   NR MDB5309919.1 2052164 g25435 i0 35.6 0.76271186440678 90 54 73.7 3 285 25 7 95 MDB5309919.1 hypothetical protein [Gemmataceae bacterium] diamond 270 48.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29217979 29217979 PRJNA1139127_P_NODE_44809_length_248_cov_0.891429_g44316_i0 PRJNA1139127 44809 248 0.891429 2.21074392 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 100 1.3e-22   NR HUI05715.1 2499141 g44316 i0 71.4 0.762096774193548 63 18 76.2 0 60 248 524 586 HUI05715.1 hypothetical protein [Verrucomicrobiia bacterium] diamond 189 100 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
29344154 29344154 PRJNA1139127_P_NODE_46949_length_245_cov_0.906977_g46456_i0 PRJNA1139127 46949 245 0.906977 2.22209365 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 48.5 2.39e-4   NR HXI71141.1 2499141 g46456 i0 66.7 0.330612244897959 27 9 33.1 0 244 164 186 212 HXI71141.1 polysaccharide biosynthesis/export family protein [Verrucomicrobiia bacterium] diamond 81 48.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
30323721 30323721 PRJNA1139127_P_NODE_25632_length_357_cov_1.098592_g25140_i0 PRJNA1139127 25632 357 1.098592 3.92197344 Opitutaceae bacterium 2006848 Bacteria Bacteria 229 2.1e-71   NR MBL9213190.1 2006848 g25140 i0 100 0.941176470588235 112 0 94.1 0 356 21 205 316 MBL9213190.1 MFS transporter [Opitutaceae bacterium] diamond 336 229 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
30627935 30627935 PRJNA1139127_P_NODE_47253_length_245_cov_0.860465_g46760_i0 PRJNA1139127 47253 245 0.860465 2.10813925 Candidatus Rhabdochlamydia 292833 Bacteria Bacteria 124 9.66e-32   NR WP_215216338.1 292833 g46760 i0 82.4 2.71836734693878 74 13 90.6 0 5 226 111 184 WP_215216338.1 MULTISPECIES: Npt1/Npt2 family nucleotide transporter [Candidatus Rhabdochlamydia] diamond 666 125 0.992 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Rhabdochlamydiaceae Candidatus Rhabdochlamydia  
31207365 31207365 PRJNA1139127_P_NODE_11375_length_625_cov_2.487319_g10908_i0 PRJNA1139127 11375 625 2.487319 15.54574375 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 46.6 0.0454   NR MFM7207677.1 2026779 g10908 i0 39.5 0.3648 76 43 36.5 2 26 253 187 259 MFM7207677.1 hypothetical protein [Planctomycetaceae bacterium] diamond 228 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31228315 31228315 PRJNA1139127_P_NODE_40935_length_257_cov_1.385870_g40442_i0 PRJNA1139127 40935 257 1.38587 3.5616859 PVC group 1783257 Bacteria Bacteria 55.8 1.01e-6   NR MBI3824111.1 2026780 g40442 i0 43.1 6.75875486381323 51 29 59.5 0 103 255 1 51 MBI3824111.1 AAA family ATPase [Planctomycetota bacterium] diamond 1737 56.2 0.99288256227758 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31429174 31429174 PRJNA1139127_P_NODE_49696_length_234_cov_2.677019_g49203_i0 PRJNA1139127 49696 234 2.677019 6.26422446 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 116 2.84e-30   NR MDE2231150.1 2035772 g49203 i0 79.5 1.87179487179487 73 15 93.6 0 232 14 168 240 MDE2231150.1 trypsin-like peptidase domain-containing protein [Candidatus Omnitrophota bacterium] diamond 438 116 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
31808804 31808804 PRJNA1139127_P_NODE_22357_length_393_cov_1.440625_g21866_i0 PRJNA1139127 22357 393 1.440625 5.66165625 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 70.9 1.92e-11   NR MDD3604725.1 2212473 g21866 i0 72.1 2.61832061068702 43 12 32.8 0 157 285 1 43 MDD3604725.1 MBOAT family protein [Kiritimatiellia bacterium] diamond 1029 70.9 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
32125387 32125387 PRJNA1139127_P_NODE_42038_length_253_cov_0.866667_g41545_i0 PRJNA1139127 42038 253 0.866667 2.19266751 Phycisphaerales bacterium 2052180 Bacteria Bacteria 96.3 8.22e-22   NR MEX2218633.1 2052180 g41545 i0 59.2 1.80237154150198 76 31 90.1 0 26 253 158 233 MEX2218633.1 flagellar motor protein MotB [Phycisphaerales bacterium] diamond 456 96.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales 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);;