RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA857143" 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

  • PRJNA857143 · 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
18694769 18694769 PRJNA857143_S_NODE_15995_length_573_cov_3.306000_g14935_i0 PRJNA857143 15995 573 3.306 18.94338 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 760 0   NTclustered gi|2874254096|emb|OY970179.1| 412056 g14935 i0 90.592 115.401396160558 574 52 100 2 1 573 1727355 1727927 MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1 blastn 66125 760 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
19086865 19086865 PRJNA857143_S_NODE_67955_length_358_cov_2.189474_g66862_i0 PRJNA857143 67955 358 2.189474 7.83831692 Opitutus 178440 Bacteria Bacteria 590 5.8099999999999986e-164   NTclustered gi|470483113|ref|NR_076574.1| 107709 g66862 i0 96.389 98.108938547486 360 9 100 4 1 358 1028 671 Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence blastn 35123 595 0.991596638655462 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus terrae
21245977 21245977 PRJNA857143_S_NODE_2097_length_1157_cov_4.687269_g249_i1 PRJNA857143 2097 1157 4.687269 54.23170233 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 1482 0   NTclustered gi|2874253690|emb|OY969416.1| 412056 g249 i1 90.297 253.509075194468 1144 93 98 17 25 1157 1314920 1316056 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 293310 1482 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
21246090 21246090 PRJNA857143_S_NODE_337_length_1898_cov_3.467945_g249_i0 PRJNA857143 337 1898 3.467945 65.8215961 Pedosphaera parvula 1032527 Bacteria Bacteria 2248 0   NTclustered gi|183579829|emb|AM905426.1| 320771 g249 i0 88.49 259.27133825079 1894 173 99 43 29 1898 1 1873 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 492097 2248 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera parvula
23795084 23795084 PRJNA857143_S_NODE_110299_length_302_cov_1.362445_g109206_i0 PRJNA857143 110299 302 1.362445 4.1145839 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 411 4.0299999999999996e-110   NTclustered gi|2874253690|emb|OY969416.1| 412056 g109206 i0 93.214 106.08940397351 280 18 93 1 23 302 1314920 1315198 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 32039 411 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
25070194 25070194 PRJNA857143_S_NODE_45540_length_408_cov_1.417910_g44447_i0 PRJNA857143 45540 408 1.41791 5.7850728 Fontisphaera persica 2974023 Bacteria Bacteria 412 1.5599999999999998e-110   NTclustered gi|2439237958|gb|CP116615.1| 2974023 g44447 i0 85.024 60.5882352941176 414 52 100 7 1 408 3862473 3862882 Fontisphaera persica strain B-154 chromosome, complete genome blastn 24720 412 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Limisphaerales Fontisphaeraceae Fontisphaera Fontisphaera persica

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