RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "blastn", bioproject = "PRJNA1036688" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 24 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1036688 · 24 ✖

analysis 1

  • blastn · 24 ✖
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
169644 169644 PRJNA1036688_P_NODE_3681_length_336_cov_3.113712_g3390_i0 PRJNA1036688 3681 336 3.113712 10.46207232 Thalassoglobus polymorphus 2527994 Bacteria Bacteria 414 3.51e-111   NTclustered gi|1712486265|gb|CP036267.1| 2527994 g3390 i0 89.318 63.7142857142857 337 26 98 8 7 336 5087173 5086840 Thalassoglobus polymorphus strain Mal48 chromosome blastn 21408 414 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Thalassoglobus Thalassoglobus polymorphus
169656 169656 PRJNA1036688_P_NODE_5921_length_242_cov_1.707317_g5629_i0 PRJNA1036688 5921 242 1.707317 4.13170714 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 298 2.54e-76   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g5629 i0 89.787 139.438016528926 235 21 97 3 1 234 2001647 2001879 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 33744 298 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
169680 169680 PRJNA1036688_P_NODE_8601_length_186_cov_6.704698_g8309_i0 PRJNA1036688 8601 186 6.704698 12.47073828 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 285 1.44e-72   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g8309 i0 94.149 107.118279569892 188 9 100 2 1 186 2002956 2002769 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 19924 285 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
1444302 1444302 PRJNA1036688_P_NODE_11582_length_155_cov_2.915254_g11290_i0 PRJNA1036688 11582 155 2.915254 4.5186437 uncultured Planctomycetota bacterium 120965 Bacteria Bacteria 287 3.21e-73   NTclustered gi|257218918|gb|GQ356111.1| 120965 g11290 i0 100 100.245161290323 155 0 100 0 1 155 1175 1021 Uncultured planctomycete clone Pla_seed-1 16S ribosomal RNA gene, partial sequence blastn 15538 287 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
1444337 1444337 PRJNA1036688_P_NODE_582_length_949_cov_5.143640_g402_i0 PRJNA1036688 582 949 5.14364 48.8131436 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 1147 0   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g402 i0 88.442 225.902002107482 969 89 100 18 1 949 7050370 7051335 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 214381 1147 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
1444371 1444371 PRJNA1036688_P_NODE_9442_length_176_cov_1.553957_g9150_i0 PRJNA1036688 9442 176 1.553957 2.73496432 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 252 1.36e-62   NTclustered gi|2874253799|emb|OY969783.1| 2876886 g9150 i0 92.614 42.8636363636364 176 11 99 2 1 175 2503146 2502972 MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1 blastn 7544 252 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
2720070 2720070 PRJNA1036688_P_NODE_12243_length_150_cov_2.061947_g11951_i0 PRJNA1036688 12243 150 2.061947 3.0929205 Bremerella volcania 2527984 Bacteria Bacteria 111 1.99e-20   NTclustered gi|1712647354|gb|CP036289.1| 2527984 g11951 i0 80.132 331.026666666667 151 28 100 2 1 150 2674628 2674479 Bremerella volcania strain Pan97 chromosome, complete genome blastn 49654 111 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Bremerella Bremerella volcania
2720103 2720103 PRJNA1036688_P_NODE_6243_length_233_cov_2.168367_g5951_i0 PRJNA1036688 6243 233 2.168367 5.05229511 uncultured Planctomycetota bacterium 120965 Bacteria Bacteria 431 2.2899999999999996e-116   NTclustered gi|257218918|gb|GQ356111.1| 120965 g5951 i0 100 101.858369098712 233 0 100 0 1 233 572 804 Uncultured planctomycete clone Pla_seed-1 16S ribosomal RNA gene, partial sequence blastn 23733 431 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
3558751 3558751 PRJNA1036688_P_NODE_6783_length_219_cov_1.115385_g6491_i0 PRJNA1036688 6783 219 1.115385 2.44269315 root 1 Root_unresolved Root_unresolved 272 1.37e-68   NTclustered gi|2874253847|emb|OY969903.1| 904075 g6491 i0 89.14 13.2054794520548 221 20 100 4 1 219 1830106 1830324 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 2892 272 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
7822295 7822295 PRJNA1036688_P_NODE_687_length_870_cov_5.877551_g402_i1 PRJNA1036688 687 870 5.877551 51.1346937 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 1044 0   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g402 i1 88.288 287.042528735632 888 82 100 16 1 870 7050452 7051335 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 249727 1044 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
8661254 8661254 PRJNA1036688_P_NODE_3647_length_338_cov_3.627907_g3356_i0 PRJNA1036688 3647 338 3.627907 12.26232566 Frigoriglobus 2774146 Bacteria Bacteria 455 2.0800000000000003e-123   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g3356 i0 91.793 171.396449704142 329 24 97 3 1 327 2003433 2003106 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 57932 455 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
10372898 10372898 PRJNA1036688_P_NODE_4909_length_276_cov_4.924686_g4617_i0 PRJNA1036688 4909 276 4.924686 13.59213336 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 335 2.25e-87   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g4617 i0 88.612 189.557971014493 281 24 99 7 1 275 7053148 7053426 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 52318 335 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
11648200 11648200 PRJNA1036688_P_NODE_6950_length_215_cov_2.342697_g6658_i0 PRJNA1036688 6950 215 2.342697 5.03679855 Maioricimonas rarisocia 2528026 Bacteria Bacteria 174 3.88e-39   NTclustered gi|1712603021|gb|CP036275.1| 2528026 g6658 i0 85.38 32.3720930232558 171 22 79 3 1 170 1845548 1845380 Maioricimonas rarisocia strain Mal4 chromosome, complete genome blastn 6960 174 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Maioricimonas Maioricimonas rarisocia
14198265 14198265 PRJNA1036688_P_NODE_6312_length_231_cov_2.664948_g6020_i0 PRJNA1036688 6312 231 2.664948 6.15602988 Maioricimonas rarisocia 2528026 Bacteria Bacteria 243 1.14e-59   NTclustered gi|1712603021|gb|CP036275.1| 2528026 g6020 i0 85.776 56.1948051948052 232 30 100 3 1 231 1844774 1844545 Maioricimonas rarisocia strain Mal4 chromosome, complete genome blastn 12981 243 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Maioricimonas Maioricimonas rarisocia
18021570 18021570 PRJNA1036688_P_NODE_9215_length_178_cov_4.255319_g8923_i0 PRJNA1036688 9215 178 4.255319 7.57446782 Thalassoglobus polymorphus 2527994 Bacteria Bacteria 235 1.39e-57   NTclustered gi|1712486265|gb|CP036267.1| 2527994 g8923 i0 90.449 85.6797752808989 178 17 100 0 1 178 5085688 5085511 Thalassoglobus polymorphus strain Mal48 chromosome blastn 15251 235 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Thalassoglobus Thalassoglobus polymorphus
18021574 18021574 PRJNA1036688_P_NODE_9855_length_171_cov_2.492537_g9563_i0 PRJNA1036688 9855 171 2.492537 4.26223827 Aeoliella mucimassa 2527972 Bacteria Bacteria 171 3.79e-38   NTclustered gi|1712622222|gb|CP036278.1| 2527972 g9563 i0 84.884 32.1286549707602 172 22 100 3 1 171 2045267 2045435 Aeoliella mucimassa strain Pan181 chromosome, complete genome blastn 5494 171 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Aeoliella Aeoliella mucimassa
19295439 19295439 PRJNA1036688_P_NODE_10496_length_165_cov_1.203125_g10204_i0 PRJNA1036688 10496 165 1.203125 1.98515625 uncultured Planctomycetota bacterium 120965 Bacteria Bacteria 305 9.59e-79   NTclustered gi|257218918|gb|GQ356111.1| 120965 g10204 i0 100 95.3939393939394 165 0 100 0 1 165 416 580 Uncultured planctomycete clone Pla_seed-1 16S ribosomal RNA gene, partial sequence blastn 15740 305 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
19295482 19295482 PRJNA1036688_P_NODE_4476_length_295_cov_1.585271_g4184_i0 PRJNA1036688 4476 295 1.585271 4.67654945 Thalassoglobus polymorphus 2527994 Bacteria Bacteria 466 8.25e-127   NTclustered gi|1712486265|gb|CP036267.1| 2527994 g4184 i0 95.238 250.623728813559 294 14 99 0 2 295 5088225 5087932 Thalassoglobus polymorphus strain Mal48 chromosome blastn 73934 466 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Thalassoglobus Thalassoglobus polymorphus
20570872 20570872 PRJNA1036688_P_NODE_9757_length_172_cov_3.237037_g9465_i0 PRJNA1036688 9757 172 3.237037 5.56770364 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 265 1.7e-66   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g9465 i0 94.706 163.273255813953 170 9 99 0 1 170 2002691 2002522 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 28083 265 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
23121893 23121893 PRJNA1036688_P_NODE_10079_length_169_cov_1.696970_g9787_i0 PRJNA1036688 10079 169 1.69697 2.8678793 uncultured Planctomycetales bacterium 100371 Bacteria Bacteria 291 2.75e-74   NTclustered gi|365928171|gb|JN825621.1| 100371 g9787 i0 97.633 98.4023668639053 169 4 100 0 1 169 181 13 Uncultured Planctomycetales bacterium clone Alchichica_AL52_1_1B_41 small subunit ribosomal RNA gene, partial sequence blastn 16630 291 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     uncultured Planctomycetales bacterium
23121944 23121944 PRJNA1036688_P_NODE_5519_length_255_cov_1.261468_g5227_i0 PRJNA1036688 5519 255 1.261468 3.2167434 Kolteria novifilia 2527975 Bacteria Bacteria 263 9.83e-66   NTclustered gi|1712629967|gb|CP036279.1| 2527975 g5227 i0 85.827 66.643137254902 254 28 98 7 7 255 1829610 1829360 Planctomycetes bacterium Pan216 chromosome, complete genome blastn 16994 263 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Kolteriales Kolteriaceae Kolteria Kolteria novifilia
23121961 23121961 PRJNA1036688_P_NODE_779_length_812_cov_5.500645_g402_i2 PRJNA1036688 779 812 5.500645 44.6652374 Limnoglobus roseus 2598579 Bacteria Bacteria 989 0   NTclustered gi|1733446852|gb|CP042425.1| 2598579 g402 i2 89.21 231.607142857143 797 79 98 7 19 812 2956411 2957203 Limnoglobus roseus strain PX52 chromosome, complete genome blastn 188065 989 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Limnoglobus Limnoglobus roseus
24395711 24395711 PRJNA1036688_P_NODE_3400_length_352_cov_3.063492_g3109_i0 PRJNA1036688 3400 352 3.063492 10.78349184 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 370 8.09e-98   NTclustered gi|2874253757|emb|OY969698.1| 100233 g3109 i0 89.691 83.0369318181818 291 28 82 2 16 305 4421373 4421662 MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1 blastn 29229 370 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
24395756 24395756 PRJNA1036688_P_NODE_8840_length_183_cov_2.602740_g8548_i0 PRJNA1036688 8840 183 2.60274 4.7630142 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 255 1.11e-63   NTclustered gi|2874253847|emb|OY969903.1| 904075 g8548 i0 91.892 21.7213114754098 185 11 100 4 1 183 1830502 1830320 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 3975 255 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured 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);;