RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA494251" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA494251 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
9403302 9403302 PRJNA494251_P_NODE_29708_length_273_cov_1.305000_g29394_i0 PRJNA494251 29708 273 1.305 3.56265 uncultured Verrucomicrobiota bacterium 156588 Bacteria Bacteria 460 3.5099999999999996e-125   NTclustered gi|226525288|gb|FJ872373.1| 156588 g29394 i0 97.07 232.673992673993 273 8 100 0 1 273 17221 16949 Uncultured Verrucomicrobia bacterium clone 118 genomic sequence blastn 63520 460 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured Verrucomicrobiota bacterium
17052490 17052490 PRJNA494251_P_NODE_17154_length_338_cov_1.562264_g16841_i0 PRJNA494251 17154 338 1.562264 5.28045232 Termitidicoccus mucosus 1184151 Bacteria Bacteria 76.8 1.89e-9   NTclustered gi|2724066732|gb|CP109796.1| 1184151 g16841 i0 85.915 0.902366863905325 71 10 21 0 238 308 2050409 2050339 Termitidicoccus mucosus strain TSB47 chromosome, complete genome blastn 305 76.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Termitidicoccus Termitidicoccus mucosus
20877032 20877032 PRJNA494251_P_NODE_25697_length_288_cov_1.325581_g25383_i0 PRJNA494251 25697 288 1.325581 3.81767328 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 76.8 1.58e-9   NTclustered gi|2874253779|emb|OY969763.1| 412056 g25383 i0 83.75 0.277777777777778 80 13 28 0 1 80 3513331 3513252 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 80 76.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
23427598 23427598 PRJNA494251_P_NODE_18259_length_329_cov_3.031250_g17945_i0 PRJNA494251 18259 329 3.03125 9.9728125 Pedosphaera parvula 1032527 Bacteria Bacteria 326 1.65e-84   NTclustered gi|183579829|emb|AM905426.1| 320771 g17945 i0 86.23 104.212765957447 305 36 91 6 1 301 5 307 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 34286 326 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);;