RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA414036 · 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
27155000 27155000 PRJNA414036_P_NODE_55122_length_231_cov_1.295918_g53383_i0 PRJNA414036 55122 231 1.295918 2.99357058 Verrucomicrobiales 48461 Bacteria Bacteria 43.1 0.0245   NR MES2660572.1 2026799 g53383 i0 86.4 1.42857142857143 22 3 28.6 0 10 75 336 357 MES2660572.1 DUF1553 domain-containing protein [Verrucomicrobiota bacterium] diamond 330 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27549388 27549388 PRJNA414036_P_NODE_28864_length_280_cov_2.020408_g27129_i0 PRJNA414036 28864 280 2.020408 5.6571424 Gemmata obscuriglobus UQM 2246 214688 Bacteria Bacteria 52 1.77e-5   NR VTS08183.1 214688 g27129 i0 45.3 0.803571428571429 75 37 80.4 2 45 269 95 165 VTS08183.1 Putative uncharacterized protein (Fragment) OS=uncultured alpha proteobacterium HF0070_14E07 PE=4 SV=1 [Gemmata obscuriglobus UQM 2246] diamond 225 52 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
28023188 28023188 PRJNA414036_P_NODE_51365_length_231_cov_1.974490_g49626_i0 PRJNA414036 51365 231 1.97449 4.5610719 Phycisphaera sp. 2030824 Bacteria Bacteria 46.6 0.00128   NR MBI1374130.1 2030824 g49626 i0 79.2 0.584415584415584 24 5 31.2 0 3 74 155 178 MBI1374130.1 hypothetical protein [Phycisphaera sp.] diamond 135 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
28023190 28023190 PRJNA414036_P_NODE_57165_length_227_cov_13.260417_g55426_i0 PRJNA414036 57165 227 13.260417 30.10114659 Planctomycetia bacterium 2052181 Bacteria Bacteria 43.1 0.0222   NR MDZ4779250.1 2052181 g55426 i0 42.4 0.872246696035242 66 32 87.2 3 27 224 58 117 MDZ4779250.1 ATP-binding protein [Planctomycetia bacterium] diamond 198 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
28938878 28938878 PRJNA414036_P_NODE_77908_length_166_cov_5.664122_g76169_i0 PRJNA414036 77908 166 5.664122 9.40244252 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 68.6 4.84e-12   NR MFM1945481.1 2026799 g76169 i0 63 0.975903614457831 54 20 97.6 0 166 5 8 61 MFM1945481.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 162 68.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29412250 29412250 PRJNA414036_P_NODE_81009_length_161_cov_3.722222_g79270_i0 PRJNA414036 81009 161 3.722222 5.99277742 Verrucomicrobiia bacterium DG1235 382464 Bacteria Bacteria 39.3 0.0245   NR EDY81568.1 382464 g79270 i0 48.9 0.838509316770186 45 23 83.9 0 143 9 1 45 EDY81568.1 hypothetical protein VDG1235_1186 [Verrucomicrobiia bacterium DG1235] diamond 135 39.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium DG1235
29570118 29570118 PRJNA414036_P_NODE_53630_length_231_cov_1.617347_g51891_i0 PRJNA414036 53630 231 1.617347 3.73607157 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 46.2 0.00182   NR MCD8483432.1 2026799 g51891 i0 95.5 0.285714285714286 22 1 28.6 0 224 159 258 279 MCD8483432.1 KamA family radical SAM protein [Verrucomicrobiota bacterium] diamond 66 46.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29618088 29618088 PRJNA414036_P_NODE_40350_length_231_cov_10.973118_g38611_i0 PRJNA414036 40350 231 10.973118 25.34790258 Gemmataceae 1914233 Bacteria Bacteria 48.1 3.82e-4   NR MEZ6140059.1 1914240 g38611 i0 95.5 7.42857142857143 22 1 28.6 0 223 158 91 112 MEZ6140059.1 response regulator [Zavarzinella sp.] diamond 1716 48.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Zavarzinella Zavarzinella sp.
29934404 29934404 PRJNA414036_P_NODE_51591_length_231_cov_1.938776_g49852_i0 PRJNA414036 51591 231 1.938776 4.47857256 Verrucomicrobiales 48461 Bacteria Bacteria 52.8 9.71e-6   NR MES2660572.1 2026799 g49852 i0 100 2.57142857142857 22 0 28.6 0 10 75 336 357 MES2660572.1 DUF1553 domain-containing protein [Verrucomicrobiota bacterium] diamond 594 52.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30107047 30107047 PRJNA414036_P_NODE_60812_length_213_cov_3.561798_g59073_i0 PRJNA414036 60812 213 3.561798 7.58662974 uncultured Verrucomicrobiales bacterium HF 100234 Bacteria Bacteria 51.6 3.7e-6   NR ADI16721.1 710995 g59073 i0 52 1.35211267605634 50 24 70.4 0 212 63 46 95 ADI16721.1 hypothetical protein [uncultured Verrucomicrobiales bacterium HF0010_05E02] diamond 288 51.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     uncultured Verrucomicrobiales bacterium HF0010_05E02
30233524 30233524 PRJNA414036_P_NODE_41552_length_231_cov_4.897959_g39813_i0 PRJNA414036 41552 231 4.897959 11.31428529 Luteolibacter sp. SL25 1962973 Bacteria Bacteria 42.4 0.0423   NR WP_267673192.1 2995170 g39813 i0 90.5 0.272727272727273 21 2 27.3 0 12 74 356 376 WP_267673192.1 valine--pyruvate transaminase [Luteolibacter sp. SL250] diamond 63 42.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250
30439928 30439928 PRJNA414036_P_NODE_52633_length_231_cov_1.775510_g50894_i0 PRJNA414036 52633 231 1.77551 4.1014281 Pseudomonadati 3379134 Bacteria Bacteria 50.4 6.03e-5   NR MFT3990515.1 1962973 g50894 i0 90 2.07792207792208 20 2 26 0 11 70 613 632 MFT3990515.1 beta-glucosidase BglX [Luteolibacter sp.] diamond 480 50.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp.
30787327 30787327 PRJNA414036_P_NODE_42854_length_231_cov_4.071429_g41115_i0 PRJNA414036 42854 231 4.071429 9.40500099 Roseimicrobium 1348508 Bacteria Bacteria 49.3 1.6e-4   NR WP_113960408.1 748857 g41115 i0 95.5 1.14285714285714 22 1 28.6 0 222 157 100 121 WP_113960408.1 polyribonucleotide nucleotidyltransferase [Roseimicrobium gellanilyticum] diamond 264 49.7 0.991951710261569 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Roseimicrobium Roseimicrobium gellanilyticum
30833836 30833836 PRJNA414036_P_NODE_48674_length_231_cov_2.454082_g46935_i0 PRJNA414036 48674 231 2.454082 5.66892942 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 50.8 4.46e-5   NR MCP5522605.1 2026801 g46935 i0 35 1.03896103896104 80 41 89.6 1 217 11 557 636 MCP5522605.1 efflux RND transporter permease subunit [Verrucomicrobiales bacterium] diamond 240 50.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
30850424 30850424 PRJNA414036_P_NODE_41394_length_231_cov_5.035714_g39655_i0 PRJNA414036 41394 231 5.035714 11.63249934 Anatilimnocola 2807414 Bacteria Bacteria 61.6 7.03e-9   NR MBI3461457.1 2026780 g39655 i0 44.7 4.41558441558442 85 36 96.1 1 10 231 91 175 MBI3461457.1 nucleotide sugar dehydrogenase [Planctomycetota bacterium] diamond 1020 61.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31434319 31434319 PRJNA414036_P_NODE_40876_length_231_cov_5.739796_g39137_i0 PRJNA414036 40876 231 5.739796 13.25892876 Verrucomicrobium spinosum 2736 Bacteria Bacteria 52 1e-5   NR WP_009958448.1 2736 g39137 i0 44 2.92207792207792 75 39 93.5 1 221 6 117 191 WP_009958448.1 RNA polymerase sigma factor [Verrucomicrobium spinosum] diamond 675 52 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Verrucomicrobium Verrucomicrobium spinosum
31750552 31750552 PRJNA414036_P_NODE_74317_length_173_cov_3.333333_g72578_i0 PRJNA414036 74317 173 3.333333 5.76666609 uncultured verrucomicrobium HF 723599 Bacteria Bacteria 64.7 2.69e-12   NR ADI22640.1 723599 g72578 i0 70.8 0.832369942196532 48 14 83.2 0 148 5 2 49 ADI22640.1 hypothetical protein [uncultured verrucomicrobium HF0500_18J03] diamond 144 64.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured verrucomicrobium HF0500_18J03
31782141 31782141 PRJNA414036_P_NODE_25197_length_301_cov_10.511278_g23463_i0 PRJNA414036 25197 301 10.511278 31.63894678 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 63.5 1.03e-10   NR PYL89444.1 2026799 g23463 i0 60.4 0.528239202657807 53 21 52.8 0 135 293 2 54 PYL89444.1 MAG: hypothetical protein DMF14_13365 [Verrucomicrobiota bacterium] diamond 159 63.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32066963 32066963 PRJNA414036_P_NODE_43358_length_231_cov_3.846939_g41619_i0 PRJNA414036 43358 231 3.846939 8.88642909 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 53.5 4.43e-6   NR MDB6070785.1 2026801 g41619 i0 95.5 0.285714285714286 22 1 28.6 0 159 224 228 249 MDB6070785.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 66 53.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
32098663 32098663 PRJNA414036_P_NODE_50858_length_231_cov_2.066327_g49119_i0 PRJNA414036 50858 231 2.066327 4.77321537 Haloferula sp. 2497595 Bacteria Bacteria 47.8 3.84e-4   NR HEY1123956.1 2497595 g49119 i0 75 0.311688311688312 24 6 31.2 0 75 4 176 199 HEY1123956.1 hypothetical protein [Haloferula sp.] diamond 72 47.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Haloferula Haloferula sp.

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