RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJNA784298" 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 · 22 ✖

bioproject 1

  • PRJNA784298 · 22 ✖

analysis 1

  • blastn · 22 ✖
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
765288 765288 PRJNA784298_P_NODE_14361_length_329_cov_1.703125_g14160_i0 PRJNA784298 14361 329 1.703125 5.60328125 Prosthecobacter fusiformis 48464 Bacteria Bacteria 551 2.499999999999999e-152   NTclustered gi|12583974|gb|AF245378.1|AF245378 48464 g14160 i0 96.951 271.109422492401 328 10 99 0 2 329 737 410 Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence blastn 89195 551 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter fusiformis
2041404 2041404 PRJNA784298_P_NODE_9122_length_417_cov_2.648256_g8921_i0 PRJNA784298 9122 417 2.648256 11.04322752 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 466 1.2099999999999997e-126   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g8921 i0 87.805 198.467625899281 410 34 96 10 1 401 7051502 7051100 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 82761 466 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
3316484 3316484 PRJNA784298_P_NODE_10563_length_386_cov_1.476038_g10362_i0 PRJNA784298 10563 386 1.476038 5.69750668 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 577 4.9199999999999984e-160   NTclustered gi|1927958621|gb|CP054186.1| 2026777 g10362 i0 93.766 143.712435233161 385 23 99 1 1 384 1866662 1867046 MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome blastn 55473 577 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
5868923 5868923 PRJNA784298_P_NODE_28085_length_226_cov_2.928105_g27884_i0 PRJNA784298 28085 226 2.928105 6.6175173 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 267 6.599999999999999e-67   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g27884 i0 88.106 206.442477876106 227 23 99 4 3 226 7050493 7050268 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 46656 267 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
7143875 7143875 PRJNA784298_P_NODE_27346_length_235_cov_2.925926_g27145_i0 PRJNA784298 27346 235 2.925926 6.8759261 Bythopirellula goksoeyrii 1400387 Bacteria Bacteria 335 1.8699999999999996e-87   NTclustered gi|1727544988|gb|CP042913.1| 1400387 g27145 i0 92.34 151.731914893617 235 18 100 0 1 235 5093503 5093269 Bythopirellula goksoeyrii strain Pr1d chromosome blastn 35657 335 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Bythopirellula Bythopirellula goksoeyrii
8418457 8418457 PRJNA784298_P_NODE_21787_length_263_cov_1.621053_g21586_i0 PRJNA784298 21787 263 1.621053 4.26336939 Phycisphaerales bacterium 2052180 Bacteria Bacteria 233 7.99e-57   NTclustered gi|1958061316|gb|CP064987.1| 2052180 g21586 i0 83.333 12.6920152091255 264 32 98 11 1 258 2191128 2190871 Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome blastn 3338 233 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
10141926 10141926 PRJNA784298_P_NODE_8008_length_445_cov_1.870968_g7807_i0 PRJNA784298 8008 445 1.870968 8.3258076 Fontisphaera 3050007 Bacteria Bacteria 403 1.0299999999999996e-107   NTclustered gi|2621704341|emb|OY760937.1| 2499141 g7807 i0 87.052 82.8179775280899 363 39 80 6 1 357 3990513 3990873 MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1 blastn 36854 403 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
11417100 11417100 PRJNA784298_P_NODE_20549_length_272_cov_1.547739_g20348_i0 PRJNA784298 20549 272 1.547739 4.20985008 Singulisphaera 466152 Bacteria Bacteria 377 3.63e-100   NTclustered gi|485099129|ref|NR_102524.1| 466153 g20348 i0 91.912 97.5477941176471 272 19 99 3 3 272 587 857 Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence blastn 26533 377 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera acidiphila
13519009 13519009 PRJNA784298_P_NODE_11011_length_377_cov_3.273026_g10810_i0 PRJNA784298 11011 377 3.273026 12.33930802 Phycisphaerales bacterium 2052180 Bacteria Bacteria 481 3.86e-131   NTclustered gi|1958061316|gb|CP064987.1| 2052180 g10810 i0 89.71 134.575596816976 379 35 100 4 1 377 2190303 2190679 Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome blastn 50735 481 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
13519139 13519139 PRJNA784298_P_NODE_22871_length_256_cov_1.453552_g22670_i0 PRJNA784298 22871 256 1.453552 3.72109312 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 300 7.53e-77   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g22670 i0 87.891 180.76171875 256 30 99 1 2 256 2002870 2002615 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 46275 300 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
14793865 14793865 PRJNA784298_P_NODE_12972_length_346_cov_3.197802_g12771_i0 PRJNA784298 12972 346 3.197802 11.06439492 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 466 9.87e-127   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g12771 i0 90.73 236.618497109827 356 23 100 6 1 346 7050926 7050571 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 81870 466 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
14793889 14793889 PRJNA784298_P_NODE_15952_length_311_cov_1.714286_g15751_i0 PRJNA784298 15952 311 1.714286 5.33142946 Phycisphaera sp. 2030824 Bacteria Bacteria 268 2.65e-67   NTclustered gi|2323351239|gb|CP098402.1| 2030824 g15751 i0 89.671 216.553054662379 213 18 68 3 98 309 3047239 3047030 MAG: Phycisphaera sp. isolate MAG12 chromosome blastn 67348 268 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
16516209 16516209 PRJNA784298_P_NODE_28413_length_211_cov_4.449275_g28212_i0 PRJNA784298 28413 211 4.449275 9.38797025 Bacteria 2 Bacteria Bacteria 285 1.68e-72   NTclustered gi|2874254043|emb|OY970367.1| 120965 g28212 i0 94.595 125.601895734597 185 8 87 2 28 211 3454934 3454751 MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1 blastn 26502 287 0.993031358885017 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
17343493 17343493 PRJNA784298_P_NODE_13794_length_336_cov_1.711027_g13593_i0 PRJNA784298 13794 336 1.711027 5.74905072 Aquisphaera giovannonii 406548 Bacteria Bacteria 481 3.41e-131   NTclustered gi|1730068067|gb|CP042997.1| 406548 g13593 i0 92.56 149.130952380952 336 23 100 1 1 336 5178597 5178930 Aquisphaera giovannonii strain OJF2 chromosome, complete genome blastn 50108 481 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
17343610 17343610 PRJNA784298_P_NODE_23814_length_251_cov_0.820225_g23613_i0 PRJNA784298 23814 251 0.820225 2.05876475 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 353 5.569999999999998e-93   NTclustered gi|2874254106|emb|OY970189.1| 100233 g23613 i0 92.063 40.2270916334661 252 19 100 1 1 251 5936854 5936603 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 10097 353 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
19064955 19064955 PRJNA784298_P_NODE_25815_length_244_cov_0.900585_g25614_i0 PRJNA784298 25815 244 0.900585 2.1974274 Limnoglobus 2731450 Bacteria Bacteria 320 5.46e-83   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g25614 i0 90.244 189.266393442623 246 22 100 2 1 244 2002325 2002080 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 46181 322 0.993788819875776 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
19892215 19892215 PRJNA784298_P_NODE_25436_length_245_cov_1.581395_g25235_i0 PRJNA784298 25436 245 1.581395 3.87441775 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 346 9.059999999999999e-91   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g25235 i0 92.308 107.914285714286 247 14 100 4 1 245 2003043 2002800 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 26439 346 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
21167944 21167944 PRJNA784298_P_NODE_27657_length_231_cov_3.234177_g27456_i0 PRJNA784298 27657 231 3.234177 7.47094887 Humisphaera borealis 2807512 Bacteria Bacteria 305 1.43e-78   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g27456 i0 91.111 116.367965367965 225 20 97 0 1 225 5063911 5064135 Humisphaera borealis strain M1803 chromosome, complete genome blastn 26881 305 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
22442702 22442702 PRJNA784298_P_NODE_26098_length_243_cov_1.358824_g25897_i0 PRJNA784298 26098 243 1.358824 3.30194232 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 340 4.169999999999999e-89   NTclustered gi|2874254106|emb|OY970189.1| 100233 g25897 i0 95.735 138.390946502058 211 9 87 0 33 243 4319270 4319480 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 33629 340 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
22442703 22442703 PRJNA784298_P_NODE_26118_length_243_cov_1.111765_g25917_i0 PRJNA784298 26118 243 1.111765 2.70158895 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 322 1.51e-83   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g25917 i0 91.213 134.255144032922 239 17 97 4 8 243 7051286 7051049 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 32624 322 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
22442742 22442742 PRJNA784298_P_NODE_3698_length_663_cov_1.554237_g3502_i0 PRJNA784298 3698 663 1.554237 10.30459131 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 832 0   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g3502 i0 89.521 344.331825037707 668 55 100 12 1 663 7050800 7051457 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 228292 832 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
24991818 24991818 PRJNA784298_P_NODE_24100_length_250_cov_0.870056_g23899_i0 PRJNA784298 24100 250 0.870056 2.17514 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 324 4.35e-84   NTclustered gi|2874253768|emb|OY969715.1| 412056 g23899 i0 90 98.896 250 25 100 0 1 250 914745 914994 MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1 blastn 24724 324 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae 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);;