RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA674308 · 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
5748146 5748146 PRJNA674308_P_NODE_22545_length_209_cov_1.531250_g22310_i0 PRJNA674308 22545 209 1.53125 3.2003125 Ereboglobus luteus 1796921 Bacteria Bacteria 84.2 6.5e-12   NTclustered gi|1387286769|gb|CP023004.1| 1796921 g22310 i0 74.766 6.53588516746411 214 40 100 14 1 209 660920 661124 Ereboglobus luteus strain Ho45, complete genome blastn 1366 84.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Ereboglobus Ereboglobus luteus
9573384 9573384 PRJNA674308_P_NODE_45168_length_165_cov_0.896552_g44933_i0 PRJNA674308 45168 165 0.896552 1.4793108 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 86.1 1.36e-12   NTclustered gi|2874253952|emb|OY970277.1| 412056 g44933 i0 82.979 0.56969696969697 94 16 57 0 50 143 3388094 3388187 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 blastn 94 86.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
10848685 10848685 PRJNA674308_P_NODE_18809_length_226_cov_0.853107_g18574_i0 PRJNA674308 18809 226 0.853107 1.92802182 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 351 1.77e-92   NTclustered gi|2621704341|emb|OY760937.1| 2499141 g18574 i0 94.714 99.3451327433628 227 11 100 1 1 226 3991911 3992137 MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1 blastn 22452 351 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
20293074 20293074 PRJNA674308_P_NODE_40396_length_167_cov_0.881356_g40161_i0 PRJNA674308 40396 167 0.881356 1.47186452 Verrucomicrobiota 74201 Bacteria Bacteria 261 2.14e-65   NTclustered gi|470483113|ref|NR_076574.1| 107709 g40161 i0 95.152 34.4251497005988 165 8 99 0 3 167 312 476 Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence blastn 5749 261 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus terrae

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