RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA605033" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA605033 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
2420847 2420847 PRJNA605033_P_NODE_3542_length_784_cov_52.773031_g2343_i0 PRJNA605033 3542 784 52.773031 413.74056304 Pseudomonadati 3379134 Bacteria Bacteria 1155 0   NTclustered gi|2874254019|emb|OY970344.1| 412056 g2343 i0 93.182 156.608418367347 792 44 100 10 1 784 736478 735689 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 122781 1160 0.995689655172414 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
3697529 3697529 PRJNA605033_P_NODE_93063_length_222_cov_2.112299_g91494_i0 PRJNA605033 93063 222 2.112299 4.68930378 PVC group 1783257 Bacteria Bacteria 56.5 0.002   NTclustered gi|2874253690|emb|OY969416.1| 412056 g91494 i0 88 41.0765765765766 50 3 22 3 7 54 1111730 1111682 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 9119 56.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
4409280 4409280 PRJNA605033_P_NODE_155124_length_190_cov_1.748387_g153555_i0 PRJNA605033 155124 190 1.748387 3.3219353 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 206 1.1799999999999999e-48   NTclustered gi|2874253952|emb|OY970277.1| 412056 g153555 i0 87.5 143.263157894737 184 16 95 6 1 180 2749751 2749571 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 blastn 27220 206 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
4409438 4409438 PRJNA605033_P_NODE_170864_length_180_cov_1.027586_g169295_i0 PRJNA605033 170864 180 1.027586 1.8496548 Opitutus sp. GAS368 1882749 Bacteria Bacteria 289 1.07e-73   NTclustered gi|1085764882|emb|LT629735.1| 1882749 g169295 i0 95.556 2 180 8 100 0 1 180 2834608 2834787 Opitutus sp. GAS368 genome assembly, chromosome: I blastn 360 289 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus sp. GAS368
8234372 8234372 PRJNA605033_P_NODE_103687_length_222_cov_1.893048_g102118_i0 PRJNA605033 103687 222 1.893048 4.20256656 Luteolibacter sp. SL250 2995170 Bacteria Bacteria 117 6.88e-22   NTclustered gi|2381117106|gb|CP113054.1| 2995170 g102118 i0 94.667 0.337837837837838 75 4 34 0 1 75 4299050 4299124 Luteolibacter sp. SL250 chromosome blastn 75 117 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250
10786193 10786193 PRJNA605033_P_NODE_181729_length_174_cov_1.870504_g180160_i0 PRJNA605033 181729 174 1.870504 3.25467696 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 278 2.22e-70   NTclustered gi|2874254019|emb|OY970344.1| 412056 g180160 i0 95.402 17.0689655172414 174 8 100 0 1 174 736090 735917 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 2970 278 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
14612041 14612041 PRJNA605033_P_NODE_7132_length_520_cov_26.012371_g5682_i0 PRJNA605033 7132 520 26.012371 135.2643292 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 800 0   NTclustered gi|2874253974|emb|OY970299.1| 412056 g5682 i0 94.423 106.334615384615 520 29 100 0 1 520 1259626 1259107 MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1 blastn 55294 800 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
15173490 15173490 PRJNA605033_P_NODE_203692_length_164_cov_2.325581_g202123_i0 PRJNA605033 203692 164 2.325581 3.81395284 Verrucomicrobiota 74201 Bacteria Bacteria 169 1.3000000000000001e-37   NTclustered gi|2874253952|emb|OY970277.1| 412056 g202123 i0 85.366 156.426829268293 164 23 100 1 1 164 2749556 2749394 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 blastn 25654 169 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
16447975 16447975 PRJNA605033_P_NODE_204813_length_164_cov_1.333333_g203244_i0 PRJNA605033 204813 164 1.333333 2.18666612 Bacteria 2 Bacteria Bacteria 87.9 3.75e-13   NTclustered gi|2076416356|gb|CP076040.1| 2684114 g203244 i0 88 53.8780487804878 75 7 45 2 92 164 4362730 4362804 Opitutia bacterium ISCC 52 isolate E3 chromosome, complete genome blastn 8836 87.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia       Opitutia bacterium ISCC 52
18433444 18433444 PRJNA605033_P_NODE_130435_length_216_cov_2.127072_g128866_i0 PRJNA605033 130435 216 2.127072 4.59447552 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 292 1.0299999999999999e-74   NTclustered gi|2874253952|emb|OY970277.1| 412056 g128866 i0 91.163 174.550925925926 215 19 99 0 1 215 2748450 2748236 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 blastn 37703 292 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
23533734 23533734 PRJNA605033_P_NODE_10819_length_422_cov_21.527132_g9290_i0 PRJNA605033 10819 422 21.527132 90.84449704 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 665 0   NTclustered gi|2874253974|emb|OY970299.1| 412056 g9290 i0 94.907 122.862559241706 432 11 99 5 2 422 1258164 1257733 MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1 blastn 51848 665 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
23533809 23533809 PRJNA605033_P_NODE_120299_length_222_cov_1.497326_g118730_i0 PRJNA605033 120299 222 1.497326 3.32406372 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 78.7 3.25e-10   NTclustered gi|2022020957|gb|CP059069.1| 2562705 g118730 i0 87.879 22.9504504504505 66 8 30 0 10 75 1264354 1264289 Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome blastn 5095 78.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
23535529 23535529 PRJNA605033_P_NODE_6739_length_537_cov_90.561753_g5307_i0 PRJNA605033 6739 537 90.561753 486.31661361 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 870 0   NTclustered gi|2874254019|emb|OY970344.1| 412056 g5307 i0 95.918 163.977653631285 539 18 100 4 1 537 737578 737042 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 88056 870 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
23535639 23535639 PRJNA605033_P_NODE_87619_length_222_cov_2.245989_g86050_i0 PRJNA605033 87619 222 2.245989 4.98609558 Opitutus sp. GAS368 1882749 Bacteria Bacteria 134 6.84e-27   NTclustered gi|1085764882|emb|LT629735.1| 1882749 g86050 i0 98.667 3.25675675675676 75 1 34 0 1 75 977059 976985 Opitutus sp. GAS368 genome assembly, chromosome: I blastn 723 134 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus sp. GAS368
24809356 24809356 PRJNA605033_P_NODE_6740_length_537_cov_85.968127_g5308_i0 PRJNA605033 6740 537 85.968127 461.64884199 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 854 0   NTclustered gi|2874254019|emb|OY970344.1| 412056 g5308 i0 95.345 203.545623836127 537 25 100 0 1 537 737578 737042 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 109304 854 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);;