RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1218816 · 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
2884371 2884371 PRJNA1218816_P_NODE_51063_length_260_cov_1.475936_g50630_i0 PRJNA1218816 51063 260 1.475936 3.8374335999999998 Gemmataceae bacterium 2052164 Bacteria Bacteria 141 1.1e-36   NR HKI33798.1 2052164 g50630 i0 75 1.84615384615385 80 20 92.3 0 3 242 183 262 HKI33798.1 PVC-type heme-binding CxxCH protein [Gemmataceae bacterium] diamond 480 141 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
4160575 4160575 PRJNA1218816_P_NODE_60044_length_244_cov_0.900585_g59611_i0 PRJNA1218816 60044 244 0.900585 2.1974274 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 134 1.63e-38   NR RYD67074.1 2026800 g59611 i0 88.5 0.959016393442623 78 8 95.9 1 5 238 15 91 RYD67074.1 MAG: J domain-containing protein, partial [Verrucomicrobiaceae bacterium] diamond 234 134 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
26629527 26629527 PRJNA1218816_P_NODE_46541_length_277_cov_1.509804_g46108_i0 PRJNA1218816 46541 277 1.509804 4.18215708 Planctomycetota bacterium 2026780 Bacteria Bacteria 103 9.52e-24   NR MDX2147932.1 2026780 g46108 i0 55.6 0.974729241877256 90 40 97.5 0 277 8 147 236 MDX2147932.1 hypothetical protein [Planctomycetota bacterium] diamond 270 103 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26755998 26755998 PRJNA1218816_P_NODE_55661_length_249_cov_0.875000_g55228_i0 PRJNA1218816 55661 249 0.875 2.17875 Planctomycetota bacterium 2026780 Bacteria Bacteria 133 1.14e-36   NR MEZ6008725.1 2026780 g55228 i0 72.8 0.975903614457831 81 22 97.6 0 6 248 26 106 MEZ6008725.1 hypothetical protein [Planctomycetota bacterium] diamond 243 133 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26946053 26946053 PRJNA1218816_P_NODE_52842_length_254_cov_1.276243_g52409_i0 PRJNA1218816 52842 254 1.276243 3.24165722 Simkania sp. 34094 Bacteria Bacteria 120 1.9499999999999999e-31   NR MCB1084310.1 34094 g52409 i0 65.5 0.992125984251969 84 29 99.2 0 2 253 93 176 MCB1084310.1 hypothetical protein [Simkania sp.] diamond 252 120 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
27135495 27135495 PRJNA1218816_P_NODE_55502_length_249_cov_0.875000_g55069_i0 PRJNA1218816 55502 249 0.875 2.17875 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 89 2.55e-19   NR MBX3377938.1 2026777 g55069 i0 58 2.5421686746988 69 29 83.1 0 212 6 30 98 MBX3377938.1 YceI family protein [Phycisphaeraceae bacterium] diamond 633 89 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
27420606 27420606 PRJNA1218816_P_NODE_53443_length_252_cov_0.821229_g53010_i0 PRJNA1218816 53443 252 0.821229 2.06949708 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42.4 0.0407   NR MEI6341235.1 2026799 g53010 i0 35.5 0.904761904761905 76 40 79.8 2 42 242 84 159 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 228 42.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27515089 27515089 PRJNA1218816_P_NODE_56563_length_248_cov_0.880000_g56130_i0 PRJNA1218816 56563 248 0.88 2.1824 Planctomycetota bacterium 2026780 Bacteria Bacteria 176 4.84e-49   NR MBI5763841.1 2026780 g56130 i0 98.8 0.979838709677419 81 1 98 0 244 2 967 1047 MBI5763841.1 hypothetical protein [Planctomycetota bacterium] diamond 243 176 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27673118 27673118 PRJNA1218816_P_NODE_61784_length_242_cov_0.911243_g61351_i0 PRJNA1218816 61784 242 0.911243 2.20520806 Phycisphaerales bacterium 2052180 Bacteria Bacteria 75.9 7.31e-14   NR HEX8878025.1 2052180 g61351 i0 97.4 0.483471074380165 39 1 48.3 0 1 117 149 187 HEX8878025.1 right-handed parallel beta-helix repeat-containing protein [Phycisphaerales bacterium] diamond 117 75.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28102030 28102030 PRJNA1218816_P_NODE_54725_length_250_cov_0.870056_g54292_i0 PRJNA1218816 54725 250 0.870056 2.17514 Prosthecobacter 48463 Bacteria Bacteria 154 5.79e-42   NR WP_184341396.1 48466 g54292 i0 90.4 10.956 83 8 99.6 0 2 250 394 476 WP_184341396.1 M3 family oligoendopeptidase [Prosthecobacter vanneervenii] diamond 2739 155 0.993548387096774 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter vanneervenii
28114865 28114865 PRJNA1218816_P_NODE_47825_length_272_cov_1.185930_g47392_i0 PRJNA1218816 47825 272 1.18593 3.2257296 Planctomycetota bacterium 2026780 Bacteria Bacteria 130 5.49e-33   NR MBI5765511.1 2026780 g47392 i0 100 0.727941176470588 66 0 72.8 0 75 272 1 66 MBI5765511.1 hypothetical protein [Planctomycetota bacterium] diamond 198 130 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28462530 28462530 PRJNA1218816_P_NODE_43686_length_289_cov_1.138889_g43253_i0 PRJNA1218816 43686 289 1.138889 3.29138921 Planctomycetota bacterium 2026780 Bacteria Bacteria 147 6.25e-40   NR MBN9121978.1 2026780 g43253 i0 71.9 0.996539792387543 96 27 99.7 0 289 2 245 340 MBN9121978.1 DUF11 domain-containing protein [Planctomycetota bacterium] diamond 288 147 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28462531 28462531 PRJNA1218816_P_NODE_54706_length_250_cov_0.870056_g54273_i0 PRJNA1218816 54706 250 0.870056 2.17514 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 154 2.1699999999999992e-43   NR HNX34657.1 2212473 g54273 i0 84.3 0.996 83 13 99.6 0 249 1 207 289 HNX34657.1 acetylxylan esterase [Kiritimatiellia bacterium] diamond 249 154 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28777907 28777907 PRJNA1218816_P_NODE_58167_length_246_cov_0.890173_g57734_i0 PRJNA1218816 58167 246 0.890173 2.18982558 Planctomycetota bacterium 2026780 Bacteria Bacteria 115 8.089999999999999e-28   NR MAG57717.1 2026780 g57734 i0 64.6 4.85365853658537 82 27 97.6 1 244 5 175 256 MAG57717.1 hypothetical protein [Planctomycetota bacterium] diamond 1194 115 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29377972 29377972 PRJNA1218816_P_NODE_26669_length_400_cov_1.027523_g26236_i0 PRJNA1218816 26669 400 1.027523 4.110092 Planctomycetota bacterium 2026780 Bacteria Bacteria 62.8 2.05e-8   NR MBL8803653.1 2026780 g26236 i0 34 1.65 103 67 77.3 1 36 344 68 169 MBL8803653.1 proprotein convertase P-domain-containing protein [Planctomycetota bacterium] diamond 660 62.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30389087 30389087 PRJNA1218816_P_NODE_55693_length_249_cov_0.875000_g55260_i0 PRJNA1218816 55693 249 0.875 2.17875 Planctomycetia bacterium 2052181 Bacteria Bacteria 72 1.31e-12   NR MCI0700707.1 2052181 g55260 i0 47.1 1.85542168674699 85 41 97.6 2 243 1 35 119 MCI0700707.1 WD40 repeat domain-containing protein [Planctomycetia bacterium] diamond 462 72 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
30515035 30515035 PRJNA1218816_P_NODE_53773_length_251_cov_0.865169_g53340_i0 PRJNA1218816 53773 251 0.865169 2.17157419 Planctomycetota bacterium 2026780 Bacteria Bacteria 50.4 7.77e-5   NR MEO1277781.1 2026780 g53340 i0 52.1 0.573705179282869 48 22 56.2 1 1 141 435 482 MEO1277781.1 acetate--CoA ligase [Planctomycetota bacterium] diamond 144 50.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30660209 30660209 PRJNA1218816_P_NODE_56913_length_248_cov_0.880000_g56480_i0 PRJNA1218816 56913 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 89.4 1.56e-18   NR RYD84082.1 2026800 g56480 i0 55.6 1.94758064516129 81 34 98 1 6 248 328 406 RYD84082.1 MAG: hypothetical protein EOP84_06490, partial [Verrucomicrobiaceae bacterium] diamond 483 90.1 0.992230854605993 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
31747766 31747766 PRJNA1218816_P_NODE_59217_length_245_cov_0.895349_g58784_i0 PRJNA1218816 59217 245 0.895349 2.19360505 Gemmataceae bacterium 2052164 Bacteria Bacteria 59.3 5.13e-8   NR MFO0847885.1 2052164 g58784 i0 46.8 0.942857142857143 77 39 94.3 1 11 241 192 266 MFO0847885.1 group 1 truncated hemoglobin [Gemmataceae bacterium] diamond 231 59.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32190889 32190889 PRJNA1218816_P_NODE_36818_length_322_cov_1.224900_g36385_i0 PRJNA1218816 36818 322 1.2249 3.944178 Chlamydiales bacterium 2047757 Bacteria Bacteria 120 2.2299999999999998e-32   NR MCP5470420.1 2047757 g36385 i0 73.6 0.847826086956522 91 24 84.8 0 3 275 57 147 MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] diamond 273 120 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales 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);;