RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1240805 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
2900243 2900243 PRJNA1240805_P_NODE_1803_length_361_cov_5.278846_g1754_i0 PRJNA1240805 1803 361 5.278846 19.05663406 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 228 6.53e-67   NR MDB5336065.1 2026779 g1754 i0 84.2 5.92520775623269 120 19 99.7 0 1 360 254 373 MDB5336065.1 hypothetical protein [Planctomycetaceae bacterium] diamond 2139 228 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
6727247 6727247 PRJNA1240805_P_NODE_2306_length_313_cov_31.196970_g2257_i0 PRJNA1240805 2306 313 31.19697 97.6465161 Bacteria 2 Bacteria Bacteria 141 2.87e-37   NR MBX3386604.1 2026777 g2257 i0 76.4 4.28434504792332 89 21 85.3 0 24 290 273 361 MBX3386604.1 exopolysaccharide biosynthesis polyprenyl glycosylphosphotransferase [Phycisphaeraceae bacterium] diamond 1341 141 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
20751024 20751024 PRJNA1240805_P_NODE_997_length_499_cov_14.802222_g950_i0 PRJNA1240805 997 499 14.802222 73.86308778 Planctomycetota 203682 Bacteria Bacteria 220 7.819999999999998e-69   NR MFN5956971.1 37635 g950 i0 74.3 3.41482965931864 144 37 86.6 0 443 12 1 144 MFN5956971.1 IS3 family transposase [Planctomyces sp.] diamond 1704 222 0.990990990990991 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp.
26724957 26724957 PRJNA1240805_P_NODE_7061_length_173_cov_3.000000_g7012_i0 PRJNA1240805 7061 173 3 5.19 Phycisphaerales bacterium 2052180 Bacteria Bacteria 102 4.14e-25   NR MBY0114168.1 2052180 g7012 i0 85.2 0.936416184971098 54 8 93.6 0 12 173 53 106 MBY0114168.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Phycisphaerales bacterium] diamond 162 102 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
26788860 26788860 PRJNA1240805_P_NODE_8201_length_162_cov_3.088496_g8152_i0 PRJNA1240805 8201 162 3.088496 5.00336352 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 41.2 0.0309   NR MDY5598073.1 2212473 g8152 i0 45.5 0.814814814814815 44 24 81.5 0 4 135 99 142 MDY5598073.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Kiritimatiellia bacterium] diamond 132 41.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27073529 27073529 PRJNA1240805_P_NODE_6322_length_182_cov_2.526316_g6273_i0 PRJNA1240805 6322 182 2.526316 4.59789512 Candidatus Brocadiales bacterium 2760054 Bacteria Bacteria 47 5.31e-4   NR MBC8553660.1 2760054 g6273 i0 45.1 0.840659340659341 51 28 84.1 0 177 25 56 106 MBC8553660.1 PKD domain-containing protein [Candidatus Brocadiales bacterium] diamond 153 47 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales     Candidatus Brocadiales bacterium
27186322 27186322 PRJNA1240805_P_NODE_3762_length_238_cov_7.698413_g3713_i0 PRJNA1240805 3762 238 7.698413 18.32222294 Rubinisphaera 1649490 Bacteria Bacteria 85.9 2.77e-18   NR MCA8988186.1 2026779 g3713 i0 47.4 1.89075630252101 78 40 97.1 1 6 236 133 210 MCA8988186.1 hypothetical protein [Planctomycetaceae bacterium] diamond 450 85.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
27452994 27452994 PRJNA1240805_P_NODE_2743_length_285_cov_3.093220_g2694_i0 PRJNA1240805 2743 285 3.09322 8.815677 Phycisphaerales bacterium 2052180 Bacteria Bacteria 111 4.14e-26   NR HPO94128.1 2052180 g2694 i0 90.3 0.757894736842105 72 7 75.8 0 2 217 483 554 HPO94128.1 methyl-accepting chemotaxis protein [Phycisphaerales bacterium] diamond 216 111 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27926392 27926392 PRJNA1240805_P_NODE_7965_length_164_cov_2.191304_g7916_i0 PRJNA1240805 7965 164 2.191304 3.59373856 Chlamydiales bacterium 2047757 Bacteria Bacteria 68.9 7.25e-12   NR MFI5333753.1 2047757 g7916 i0 66 0.914634146341463 50 16 91.5 1 9 158 184 232 MFI5333753.1 glycogen synthase [Chlamydiales bacterium] diamond 150 68.9 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
28084176 28084176 PRJNA1240805_P_NODE_6405_length_181_cov_2.121212_g6356_i0 PRJNA1240805 6405 181 2.121212 3.83939372 Phycisphaerae bacterium RAS1 2528034 Bacteria Bacteria 52 8.57e-6   NR TWT44113.1 2528034 g6356 i0 55.3 0.779005524861878 47 21 77.9 0 6 146 50 96 TWT44113.1 putative multidrug export ATP-binding/permease protein [Phycisphaerae bacterium RAS1] diamond 141 52 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium RAS1
28273573 28273573 PRJNA1240805_P_NODE_5046_length_203_cov_9.668831_g4997_i0 PRJNA1240805 5046 203 9.668831 19.62772693 Planctomycetota bacterium 2026780 Bacteria Bacteria 85.9 1.31e-17   NR MBS0198188.1 2026780 g4997 i0 75 0.886699507389163 60 15 88.7 0 184 5 4 63 MBS0198188.1 hypothetical protein [Planctomycetota bacterium] diamond 180 85.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28305243 28305243 PRJNA1240805_P_NODE_3226_length_259_cov_7.276190_g3177_i0 PRJNA1240805 3226 259 7.27619 18.8453321 Phycisphaerales bacterium 2052180 Bacteria Bacteria 131 2.4e-34   NR HEX8877688.1 2052180 g3177 i0 77.5 1.85328185328185 80 18 92.7 0 259 20 49 128 HEX8877688.1 glycosyltransferase [Phycisphaerales bacterium] diamond 480 131 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28621178 28621178 PRJNA1240805_P_NODE_787_length_564_cov_4.656311_g740_i0 PRJNA1240805 787 564 4.656311 26.26159404 Phycisphaerales bacterium 2052180 Bacteria Bacteria 188 4.3199999999999985e-56   NR MBY0112774.1 2052180 g740 i0 68.3 0.75531914893617 142 36 70.7 1 421 23 1 142 MBY0112774.1 NRDE family protein [Phycisphaerales bacterium] diamond 426 188 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28747326 28747326 PRJNA1240805_P_NODE_1847_length_357_cov_7.146104_g1798_i0 PRJNA1240805 1847 357 7.146104 25.51159128 Phycisphaerae bacterium 2026778 Bacteria Bacteria 109 9.24e-27   NR MFN9977419.1 2026778 g1798 i0 98.1 0.436974789915966 52 1 43.7 0 3 158 201 252 MFN9977419.1 phosphoenolpyruvate carboxykinase (ATP) [Phycisphaerae bacterium] diamond 156 109 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28778785 28778785 PRJNA1240805_P_NODE_1867_length_354_cov_27.659016_g1818_i0 PRJNA1240805 1867 354 27.659016 97.91291664 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 47.8 0.00236   NR MBI5385683.1 2026799 g1818 i0 59.5 0.313559322033898 37 15 31.4 0 221 331 895 931 MBI5385683.1 autotransporter-associated beta strand repeat-containing protein [Verrucomicrobiota bacterium] diamond 111 47.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28778786 28778786 PRJNA1240805_P_NODE_3247_length_258_cov_29.612440_g3198_i0 PRJNA1240805 3247 258 29.61244 76.4000952 Rhabdochlamydiaceae bacterium 2047756 Bacteria Bacteria 144 6.72e-38   NR MBY0530222.1 2047756 g3198 i0 71.8 0.988372093023256 85 24 98.8 0 255 1 1023 1107 MBY0530222.1 bifunctional proline dehydrogenase/L-glutamate gamma-semialdehyde dehydrogenase [Rhabdochlamydiaceae bacterium] diamond 255 144 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Rhabdochlamydiaceae   Rhabdochlamydiaceae bacterium
29252271 29252271 PRJNA1240805_P_NODE_4529_length_215_cov_3.253012_g4480_i0 PRJNA1240805 4529 215 3.253012 6.9939758 Tepidisphaerales bacterium 2795155 Bacteria Bacteria 141 7.49e-41   NR MFN4244490.1 2795155 g4480 i0 98.6 0.990697674418605 71 1 99.1 0 215 3 34 104 MFN4244490.1 hypothetical protein [Tepidisphaerales bacterium] diamond 213 141 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales     Tepidisphaerales bacterium
29504998 29504998 PRJNA1240805_P_NODE_2190_length_324_cov_2.370909_g2141_i0 PRJNA1240805 2190 324 2.370909 7.68174516 Planctomycetota bacterium 2026780 Bacteria Bacteria 95.9 1.82e-20   NR MEO0482710.1 2026780 g2141 i0 84 1.85185185185185 50 8 46.3 0 173 24 374 423 MEO0482710.1 carboxypeptidase M32 [Planctomycetota bacterium] diamond 600 95.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29725824 29725824 PRJNA1240805_P_NODE_6570_length_178_cov_7.899225_g6521_i0 PRJNA1240805 6570 178 7.899225 14.0606205 Phycisphaerales bacterium 2052180 Bacteria Bacteria 87.4 1.07e-18   NR NUQ52989.1 2052180 g6521 i0 86.8 0.893258426966292 53 7 89.3 0 178 20 150 202 NUQ52989.1 universal stress protein [Phycisphaerales bacterium] diamond 159 87.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30168196 30168196 PRJNA1240805_P_NODE_5152_length_201_cov_6.256579_g5103_i0 PRJNA1240805 5152 201 6.256579 12.57572379 Phycisphaerales bacterium 2052180 Bacteria Bacteria 89.4 7.89e-19   NR HEX8877277.1 2052180 g5103 i0 74.6 0.880597014925373 59 13 88.1 1 25 201 1 57 HEX8877277.1 phage portal protein [Phycisphaerales bacterium] diamond 177 89.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30547493 30547493 PRJNA1240805_P_NODE_1433_length_412_cov_15.198347_g1384_i0 PRJNA1240805 1433 412 15.198347 62.61718964 Pirellulales bacterium 2715253 Bacteria Bacteria 134 5.18e-36   NR MFO0883901.1 2715253 g1384 i0 97.2 0.524271844660194 72 2 52.4 0 279 64 169 240 MFO0883901.1 hypothetical protein [Pirellulales bacterium] diamond 216 134 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
30565263 30565263 PRJNA1240805_P_NODE_1793_length_361_cov_19.173077_g1744_i0 PRJNA1240805 1793 361 19.173077 69.21480797 Phycisphaera 666508 Bacteria Bacteria 59.3 2.04e-7   NR MCK6473828.1 2026780 g1744 i0 41 2.23545706371191 78 43 63.2 3 118 345 311 387 MCK6473828.1 three-Cys-motif partner protein TcmP [Planctomycetota bacterium] diamond 807 59.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30705375 30705375 PRJNA1240805_P_NODE_1414_length_416_cov_7.528610_g1365_i0 PRJNA1240805 1414 416 7.52861 31.3190176 Tepidisphaera sp. 2017440 Bacteria Bacteria 238 1.41e-77   NR MBI1191239.1 2017440 g1365 i0 83.8 0.980769230769231 136 22 98.1 0 410 3 6 141 MBI1191239.1 TetR family transcriptional regulator [Tepidisphaera sp.] diamond 408 238 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Tepidisphaera Tepidisphaera sp.
31084649 31084649 PRJNA1240805_P_NODE_6795_length_176_cov_1.606299_g6746_i0 PRJNA1240805 6795 176 1.606299 2.82708624 Bremerella cremea 1031537 Bacteria Bacteria 55.1 6.7e-7   NR WP_114367744.1 1031537 g6746 i0 48.3 1.73863636363636 58 30 98.9 0 174 1 13 70 WP_114367744.1 SLC13 family permease [Bremerella cremea] diamond 306 55.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Bremerella Bremerella cremea
31179104 31179104 PRJNA1240805_P_NODE_7055_length_173_cov_3.225806_g7006_i0 PRJNA1240805 7055 173 3.225806 5.58064438 Planctomycetia bacterium 2052181 Bacteria Bacteria 49.7 5.19e-5   NR MDZ4778975.1 2052181 g7006 i0 54.7 0.919075144508671 53 18 91.9 2 13 171 123 169 MDZ4778975.1 serine/threonine-protein kinase [Planctomycetia bacterium] diamond 159 49.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
31590738 31590738 PRJNA1240805_P_NODE_2736_length_285_cov_7.097458_g2687_i0 PRJNA1240805 2736 285 7.097458 20.2277553 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 44.7 0.012   NR MBX3385003.1 2026777 g2687 i0 31.5 0.968421052631579 92 55 89.5 2 256 2 175 265 MBX3385003.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 276 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
32191728 32191728 PRJNA1240805_P_NODE_1318_length_431_cov_8.314136_g1269_i0 PRJNA1240805 1318 431 8.314136 35.83392616 Phycisphaerales bacterium 2052180 Bacteria Bacteria 110 1.92e-26   NR MBY0313438.1 2052180 g1269 i0 52.1 0.842227378190255 121 48 84.2 2 37 399 18 128 MBY0313438.1 sugar phosphate isomerase/epimerase [Phycisphaerales bacterium] diamond 363 110 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);;