RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA851399" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA851399 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
4667596 4667596 PRJNA851399_P_NODE_14464_length_198_cov_1.369128_g14011_i0 PRJNA851399 14464 198 1.369128 2.71087344 uncultured Verrucomicrobiota bacterium 156588 Bacteria Bacteria 259 9.42e-65   NTclustered gi|226525288|gb|FJ872373.1| 156588 g14011 i0 94.611 282.323232323232 167 9 84 0 1 167 17720 17554 Uncultured Verrucomicrobia bacterium clone 118 genomic sequence blastn 55900 259 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured Verrucomicrobiota bacterium
9767226 9767226 PRJNA851399_P_NODE_16148_length_188_cov_2.287770_g15695_i0 PRJNA851399 16148 188 2.28777 4.3010076 uncultured Verrucomicrobiota bacterium 156588 Bacteria Bacteria 281 1.89e-71   NTclustered gi|226525339|gb|FJ872375.1| 156588 g15695 i0 93.617 130.218085106383 188 12 100 0 1 188 28335 28148 Uncultured Verrucomicrobia bacterium clone 286 genomic sequence blastn 24481 281 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured Verrucomicrobiota bacterium
14867349 14867349 PRJNA851399_P_NODE_28692_length_166_cov_0.871795_g28239_i0 PRJNA851399 28692 166 0.871795 1.4471797 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 171 3.68e-38   NTclustered gi|2874253690|emb|OY969416.1| 412056 g28239 i0 85.89 2.6144578313253 163 20 98 3 5 166 1317177 1317017 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 434 171 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
16536421 16536421 PRJNA851399_P_NODE_12593_length_215_cov_0.921687_g12140_i0 PRJNA851399 12593 215 0.921687 1.98162705 Chthoniobacter 295577 Bacteria Bacteria 303 4.74e-78   NTclustered gi|226525288|gb|FJ872373.1| 156588 g12140 i0 92.857 237.251162790698 210 14 98 1 1 210 16357 16565 Uncultured Verrucomicrobia bacterium clone 118 genomic sequence blastn 51009 303 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured Verrucomicrobiota bacterium
24185661 24185661 PRJNA851399_P_NODE_879_length_1198_cov_2.429939_g719_i0 PRJNA851399 879 1198 2.429939 29.11066922 Verrucomicrobiota 74201 Bacteria Bacteria 1057 0   NTclustered gi|183579829|emb|AM905426.1| 320771 g719 i0 88.623 131.860601001669 879 87 88 11 44 915 1452 580 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 157969 1057 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);;