RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA572587" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA572587 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
5662364 5662364 PRJNA572587_P_NODE_10205_length_371_cov_30.354037_g9878_i0 PRJNA572587 10205 371 30.354037 112.61347727 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 414 3.91e-111   NTclustered gi|2874253690|emb|OY969416.1| 412056 g9878 i0 90.252 99.7870619946092 318 29 85 2 3 319 1316737 1316421 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 37021 414 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
8211617 8211617 PRJNA572587_P_NODE_10007_length_376_cov_2.113150_g9680_i0 PRJNA572587 10007 376 2.11315 7.945444 Fontisphaera persica 2974023 Bacteria Bacteria 278 5.4300000000000006e-70   NTclustered gi|2439237958|gb|CP116615.1| 2974023 g9680 i0 86.853 64.9601063829787 251 29 66 4 127 376 3863933 3863686 Fontisphaera persica strain B-154 chromosome, complete genome blastn 24425 278 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Limisphaerales Fontisphaeraceae Fontisphaera Fontisphaera persica
8212173 8212173 PRJNA572587_P_NODE_5347_length_544_cov_286.056566_g5027_i0 PRJNA572587 5347 544 286.056566 1556.14771904 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 667 0   NTclustered gi|2874253779|emb|OY969763.1| 412056 g5027 i0 90.173 94.8841911764706 519 41 94 10 1 514 3833087 3833600 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 51617 667 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
14588016 14588016 PRJNA572587_P_NODE_8892_length_403_cov_78.319209_g8565_i0 PRJNA572587 8892 403 78.319209 315.62641227 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 340 7.36e-89   NTclustered gi|2874253779|emb|OY969763.1| 412056 g8565 i0 87.097 56.6774193548387 310 29 74 5 82 380 3832143 3832452 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 22841 340 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
15861359 15861359 PRJNA572587_P_NODE_16613_length_280_cov_267.956710_g16285_i0 PRJNA572587 16613 280 267.95671 750.278788 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 294 3.88e-75   NTclustered gi|2874253779|emb|OY969763.1| 412056 g16285 i0 89.7 108.939285714286 233 20 82 4 21 250 3833369 3833600 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 30503 294 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
17136300 17136300 PRJNA572587_P_NODE_12654_length_327_cov_23.694245_g12326_i0 PRJNA572587 12654 327 23.694245 77.48018115 Pedosphaera parvula 1032527 Bacteria Bacteria 411 4.4e-110   NTclustered gi|183579829|emb|AM905426.1| 320771 g12326 i0 91.118 233.590214067278 304 25 93 2 22 325 768 1069 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 76384 411 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera parvula

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);;