RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1016321 · 25 ✖

analysis 1

  • diamond · 25 ✖
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
26773967 26773967 PRJNA1016321_P_NODE_20161_length_425_cov_2.056818_g19930_i0 PRJNA1016321 20161 425 2.056818 8.7414765 Pseudomonadati 3379134 Bacteria Bacteria 159 2.43e-46   NR OQB95054.1 1852928 g19930 i0 57.2 7.55294117647059 138 59 97.4 0 425 12 1 138 OQB95054.1 MAG: DNA-invertase hin [Verrucomicrobia bacterium ADurb.Bin118] diamond 3210 160 0.99375 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobia bacterium ADurb.Bin118
26781789 26781789 PRJNA1016321_P_NODE_42841_length_268_cov_4.717949_g42610_i0 PRJNA1016321 42841 268 4.717949 12.64410332 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 82.8 5.93e-18   NR MBP6343092.1 2035772 g42610 i0 86.4 0.492537313432836 44 6 49.3 0 263 132 89 132 MBP6343092.1 response regulator [Candidatus Omnitrophota bacterium] diamond 132 82.8 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
27066375 27066375 PRJNA1016321_P_NODE_53082_length_245_cov_0.895349_g52851_i0 PRJNA1016321 53082 245 0.895349 2.19360505 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 149 9.55e-40   NR MDQ6861078.1 2026799 g52851 i0 91.4 15.869387755102 81 7 99.2 0 244 2 357 437 MDQ6861078.1 L-glutamate gamma-semialdehyde dehydrogenase [Verrucomicrobiota bacterium] diamond 3888 149 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27603801 27603801 PRJNA1016321_P_NODE_57184_length_232_cov_2.735849_g56953_i0 PRJNA1016321 57184 232 2.735849 6.34716968 Gemmataceae bacterium 2052164 Bacteria Bacteria 96.3 5.63e-22   NR MBY0460844.1 2052164 g56953 i0 61 0.995689655172414 77 30 99.6 0 232 2 88 164 MBY0460844.1 TIGR02996 domain-containing protein [Gemmataceae bacterium] diamond 231 96.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27635279 27635279 PRJNA1016321_P_NODE_46384_length_255_cov_1.994505_g46153_i0 PRJNA1016321 46384 255 1.994505 5.08598775 Gemmataceae bacterium 2052164 Bacteria Bacteria 73.6 3.33e-13   NR MFL5330220.1 2052164 g46153 i0 42.4 1 85 48 98.8 1 254 3 103 187 MFL5330220.1 DUF1559 domain-containing protein [Gemmataceae bacterium] diamond 255 73.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27761722 27761722 PRJNA1016321_P_NODE_25284_length_369_cov_1.574324_g25053_i0 PRJNA1016321 25284 369 1.574324 5.80925556 Chlamydiota bacterium 2081524 Bacteria Bacteria 92.4 4.84e-20   NR MBM3194173.1 2081524 g25053 i0 51.6 0.739837398373984 91 43 73.2 1 99 368 14 104 MBM3194173.1 hypothetical protein [Chlamydiota bacterium] diamond 273 92.4 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota bacterium
28108589 28108589 PRJNA1016321_P_NODE_40765_length_277_cov_1.357843_g40534_i0 PRJNA1016321 40765 277 1.357843 3.76122511 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 62.4 3.33e-9   NR MCL4181712.1 2026799 g40534 i0 43 1.77617328519856 86 49 93.1 0 261 4 58 143 MCL4181712.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 492 62.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28424630 28424630 PRJNA1016321_P_NODE_34266_length_307_cov_1.316239_g34035_i0 PRJNA1016321 34266 307 1.316239 4.04085373 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 119 5.7599999999999994e-30   NR MFL6531342.1 2201154 g34035 i0 95.3 2.50162866449511 64 3 62.5 0 307 116 278 341 MFL6531342.1 GspE/PulE family protein [Chthoniobacterales bacterium] diamond 768 119 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
28645637 28645637 PRJNA1016321_P_NODE_49767_length_249_cov_0.875000_g49536_i0 PRJNA1016321 49767 249 0.875 2.17875 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42.7 0.0401   NR MEC9129966.1 2026799 g49536 i0 41.8 0.662650602409639 55 29 62.7 1 12 167 62 116 MEC9129966.1 DUF6797 domain-containing protein [Verrucomicrobiota bacterium] diamond 165 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28708828 28708828 PRJNA1016321_P_NODE_17727_length_460_cov_0.994832_g17497_i0 PRJNA1016321 17727 460 0.994832 4.5762272 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 301 1.16e-94   NR MCP4083351.1 2026779 g17497 i0 100 0.997826086956522 153 0 99.8 0 1 459 265 417 MCP4083351.1 hypothetical protein [Planctomycetaceae bacterium] diamond 459 301 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28740273 28740273 PRJNA1016321_P_NODE_53987_length_243_cov_4.529412_g53756_i0 PRJNA1016321 53987 243 4.529412 11.00647116 Nibricoccus aquaticus 2576891 Bacteria Bacteria 45.1 0.00575   NR WP_175414735.1 2576891 g53756 i0 36.8 0.703703703703704 57 36 70.4 0 8 178 862 918 WP_175414735.1 malectin domain-containing carbohydrate-binding protein [Nibricoccus aquaticus] diamond 171 45.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Nibricoccus Nibricoccus aquaticus
28890235 28890235 PRJNA1016321_P_NODE_15188_length_503_cov_2.160465_g14959_i0 PRJNA1016321 15188 503 2.160465 10.86713895 PVC group 1783257 Bacteria Bacteria 113 8.98e-26   NR MCK9603241.1 2035772 g14959 i0 39.6 1.96819085487078 164 88 96 4 21 503 170 325 MCK9603241.1 hypothetical protein [Candidatus Omnitrophota bacterium] diamond 990 113 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
29308502 29308502 PRJNA1016321_P_NODE_57129_length_233_cov_2.262500_g56898_i0 PRJNA1016321 57129 233 2.2625 5.271625 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 139 9.05e-38   NR MFN0126375.1 2026801 g56898 i0 95.8 0.914163090128755 71 3 91.4 0 233 21 209 279 MFN0126375.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 213 139 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
29623809 29623809 PRJNA1016321_P_NODE_38870_length_285_cov_1.000000_g38639_i0 PRJNA1016321 38870 285 1 2.85 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 185 3.419999999999999e-54   NR HEV3304486.1 2026779 g38639 i0 90.4 1.97894736842105 94 9 98.9 0 2 283 324 417 HEV3304486.1 IS21 family transposase [Planctomycetaceae bacterium] diamond 564 185 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29687143 29687143 PRJNA1016321_P_NODE_37070_length_292_cov_2.602740_g36839_i0 PRJNA1016321 37070 292 2.60274 7.6000008 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 178 2.39e-51   NR MFN0197902.1 2026779 g36839 i0 93.3 1.84931506849315 90 6 92.5 0 271 2 425 514 MFN0197902.1 IS1380 family transposase [Planctomycetaceae bacterium] diamond 540 178 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29813645 29813645 PRJNA1016321_P_NODE_10751_length_612_cov_2.153989_g10529_i0 PRJNA1016321 10751 612 2.153989 13.18241268 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 201 1.23e-62   NR MFN0126377.1 2026801 g10529 i0 86.2 0.676470588235294 138 19 67.6 0 168 581 1 138 MFN0126377.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 414 201 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
30003417 30003417 PRJNA1016321_P_NODE_12791_length_554_cov_2.561331_g12568_i0 PRJNA1016321 12791 554 2.561331 14.18977374 Gemmatales bacterium 2838789 Bacteria Bacteria 181 7.46e-51   NR MCS6975467.1 2838789 g12568 i0 62.2 3.18953068592058 148 55 79.6 1 2 442 353 500 MCS6975467.1 thiamine phosphate synthase [Gemmatales bacterium] diamond 1767 181 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales     Gemmatales bacterium
30129346 30129346 PRJNA1016321_P_NODE_41212_length_275_cov_1.529703_g40981_i0 PRJNA1016321 41212 275 1.529703 4.20668325 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 167 2.48e-50   NR MFN2508465.1 2201154 g40981 i0 94.4 11.7927272727273 90 5 98.2 0 275 6 31 120 MFN2508465.1 MotA/TolQ/ExbB proton channel family protein [Chthoniobacterales bacterium] diamond 3243 167 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
30919727 30919727 PRJNA1016321_P_NODE_38094_length_288_cov_1.395349_g37863_i0 PRJNA1016321 38094 288 1.395349 4.01860512 Opitutales bacterium 2026772 Bacteria Bacteria 77 5.68e-14   NR MEX2380795.1 2026772 g37863 i0 46.9 0.84375 81 38 79.2 2 286 59 869 949 MEX2380795.1 M56 family metallopeptidase [Opitutales bacterium] diamond 243 77 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales bacterium
31172049 31172049 PRJNA1016321_P_NODE_43415_length_266_cov_1.932642_g43184_i0 PRJNA1016321 43415 266 1.932642 5.14082772 Phycisphaera sp. 2030824 Bacteria Bacteria 43.5 0.0264   NR MBI1337797.1 2030824 g43184 i0 37.3 0.575187969924812 51 32 57.5 0 176 24 126 176 MBI1337797.1 hypothetical protein [Phycisphaera sp.] diamond 153 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
31298754 31298754 PRJNA1016321_P_NODE_37775_length_289_cov_1.986111_g37544_i0 PRJNA1016321 37775 289 1.986111 5.73986079 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 114 2.11e-28   NR MFN0126376.1 2026801 g37544 i0 87.1 0.726643598615917 70 9 72.7 0 288 79 162 231 MFN0126376.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 210 114 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
31362240 31362240 PRJNA1016321_P_NODE_8856_length_680_cov_3.629325_g8646_i0 PRJNA1016321 8856 680 3.629325 24.67941 Prosthecobacter sp. 1965333 Bacteria Bacteria 220 3.89e-65   NR HEY1084366.1 1965333 g8646 i0 98.4 0.555882352941176 126 2 55.6 0 294 671 1 126 HEY1084366.1 hypothetical protein [Prosthecobacter sp.] diamond 378 220 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
32026353 32026353 PRJNA1016321_P_NODE_17558_length_462_cov_2.789203_g17328_i0 PRJNA1016321 17558 462 2.789203 12.88611786 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 190 1.88e-56   NR MFN0126375.1 2026801 g17328 i0 80.7 0.772727272727273 119 23 77.3 0 105 461 1 119 MFN0126375.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 357 190 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
32216266 32216266 PRJNA1016321_P_NODE_30058_length_332_cov_1.189189_g29827_i0 PRJNA1016321 30058 332 1.189189 3.94810748 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 220 5.19e-65   NR MCP4083351.1 2026779 g29827 i0 100 0.993975903614458 110 0 99.4 0 331 2 691 800 MCP4083351.1 hypothetical protein [Planctomycetaceae bacterium] diamond 330 220 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32248166 32248166 PRJNA1016321_P_NODE_6698_length_790_cov_2.993026_g6500_i0 PRJNA1016321 6698 790 2.993026 23.6449054 Gemmataceae bacterium 2052164 Bacteria Bacteria 51.2 0.00194   NR HEX4590038.1 2052164 g6500 i0 54.8 0.315189873417722 42 19 15.9 0 639 764 37 78 HEX4590038.1 hypothetical protein [Gemmataceae bacterium] diamond 249 51.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae 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);;