RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA358009", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 13 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 13 ✖

bioproject 1

  • PRJNA358009 · 13 ✖
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
398381 398381 PRJNA358009_P_NODE_6681_length_326_cov_2.025271_g6618_i0 PRJNA358009 6681 326 2.025271 6.60238346 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 67.6 1.09e-6   NTclustered gi|2874254019|emb|OY970344.1| 412056 g6618 i0 93.333 0.138036809815951 45 3 14 0 55 99 2184498 2184454 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 45 67.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
3623689 3623689 PRJNA358009_P_NODE_363_length_546_cov_6.150905_g322_i0 PRJNA358009 363 546 6.150905 33.5839413 Pseudomonadati 3379134 Bacteria Bacteria 294 8.08e-75   NTclustered gi|2874254019|emb|OY970344.1| 412056 g322 i0 99.383 58.1684981684982 162 1 80 0 385 546 1434748 1434909 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 31760 294 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
6775979 6775979 PRJNA358009_P_NODE_826_length_404_cov_25.152113_g768_i0 PRJNA358009 826 404 25.152113 101.61453652 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 322 2.67e-83   NTclustered gi|2874254019|emb|OY970344.1| 412056 g768 i0 94.286 52.6534653465347 210 12 75 0 1 210 737375 737166 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 21272 322 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
10602036 10602036 PRJNA358009_P_NODE_269_length_597_cov_10.906934_g230_i0 PRJNA358009 269 597 10.906934 65.11439598 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 499 1.76e-136   NTclustered gi|2874254019|emb|OY970344.1| 412056 g230 i0 96.678 76.7219430485762 301 8 78 2 195 494 736390 736091 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 45803 499 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
10602102 10602102 PRJNA358009_P_NODE_7909_length_215_cov_13.981928_g7840_i0 PRJNA358009 7909 215 13.981928 30.0611452 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 353 4.64e-93   NTclustered gi|2874254019|emb|OY970344.1| 412056 g7840 i0 97.129 60.6046511627907 209 6 97 0 1 209 737375 737167 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 13030 353 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
14427047 14427047 PRJNA358009_P_NODE_17232_length_157_cov_3.546296_g17163_i0 PRJNA358009 17232 157 3.546296 5.56768472 Haloferula helveola 490095 Bacteria Bacteria 187 3.3999999999999993e-43   NTclustered gi|2647781590|dbj|AP024702.1| 490095 g17163 i0 94.309 185.96178343949 123 5 78 2 30 151 775940 776061 Haloferula helveola CN-1 DNA, complete genome blastn 29196 187 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Haloferula Haloferula helveola
15701000 15701000 PRJNA358009_P_NODE_7153_length_273_cov_11.540179_g7086_i0 PRJNA358009 7153 273 11.540179 31.50468867 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 475 1.2499999999999999e-129   NTclustered gi|2874254019|emb|OY970344.1| 412056 g7086 i0 98.162 151.03663003663 272 5 99 0 1 272 734970 734699 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 41233 475 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
19524150 19524150 PRJNA358009_P_NODE_576_length_462_cov_14.079903_g522_i0 PRJNA358009 576 462 14.079903 65.04915186 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 833 0   NTclustered gi|2874254019|emb|OY970344.1| 412056 g522 i0 99.78 102.655844155844 454 1 98 0 8 461 736949 736496 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 47427 833 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
19524179 19524179 PRJNA358009_P_NODE_7996_length_211_cov_29.876543_g7927_i0 PRJNA358009 7996 211 29.876543 63.03950573 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 342 9.819999999999999e-90   NTclustered gi|2874254019|emb|OY970344.1| 412056 g7927 i0 96.172 117.843601895735 209 8 99 0 1 209 737376 737584 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 24865 342 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
23350175 23350175 PRJNA358009_P_NODE_13879_length_165_cov_3.000000_g13810_i0 PRJNA358009 13879 165 3 4.95 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 274 2.7e-69   NTclustered gi|2874254019|emb|OY970344.1| 412056 g13810 i0 97.5 23.1818181818182 160 4 97 0 1 160 405058 405217 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 3825 274 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
24624496 24624496 PRJNA358009_P_NODE_1860_length_333_cov_7.193662_g1797_i0 PRJNA358009 1860 333 7.193662 23.95489446 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 211 4.89e-50   NTclustered gi|2874254019|emb|OY970344.1| 412056 g1797 i0 99.145 35.5135135135135 117 1 65 0 217 333 737259 737375 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 11826 211 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
24624578 24624578 PRJNA358009_P_NODE_8500_length_195_cov_3.705479_g8431_i0 PRJNA358009 8500 195 3.705479 7.22568405 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 231 2.02e-56   NTclustered gi|2916415364|gb|CP170459.1| 2026799 g8431 i0 88.83 9.21538461538461 188 21 96 0 1 188 2576558 2576371 MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome blastn 1797 231 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31275504 31275504 PRJNA358009_P_NODE_12675_length_168_cov_3.016807_g12606_i0 PRJNA358009 12675 168 3.016807 5.06823576 Opitutaceae bacterium 2006848 Bacteria Bacteria 68.9 7.58e-12   NR HVS52988.1 2006848 g12606 i0 59.6 1.83928571428571 52 20 92.9 1 3 158 253 303 HVS52988.1 hypothetical protein [Opitutaceae bacterium] diamond 309 68.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae 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);;