RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA399711 · 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
4908961 4908961 PRJNA399711_P_NODE_7484_length_213_cov_7.085227_g7418_i0 PRJNA399711 7484 213 7.085227 15.09153351 Pseudomonadati 3379134 Bacteria Bacteria 80.5 8.6e-11   NTclustered gi|177839040|gb|CP001032.1| 452637 g7418 i0 95.918 22.2441314553991 49 2 23 0 144 192 1925587 1925635 Opitutus terrae PB90-1, complete genome blastn 4738 80.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus terrae
25563042 25563042 PRJNA399711_S_NODE_31713_length_234_cov_3.543147_g31571_i0 PRJNA399711 31713 234 3.543147 8.29096398 Akkermansia muciniphila 239935 Bacteria Bacteria 54.7 0.006   NTclustered gi|1554474302|gb|CP025823.1| 239935 g31571 i0 100 0.247863247863248 29 0 12 0 127 155 410818 410790 Akkermansia muciniphila strain EB-AMDK-7 chromosome, complete genome blastn 58 54.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia muciniphila
26109082 26109082 PRJNA399711_S_NODE_71133_length_175_cov_3.181159_g70991_i0 PRJNA399711 71133 175 3.181159 5.56702825 uncultured Verrucomicrobiota bacterium 156588 Bacteria Bacteria 195 2.31e-45   NTclustered gi|226525339|gb|FJ872375.1| 156588 g70991 i0 86.857 34.8342857142857 175 21 99 2 2 175 28443 28616 Uncultured Verrucomicrobia bacterium clone 286 genomic sequence blastn 6096 195 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured Verrucomicrobiota bacterium
26244767 26244767 PRJNA399711_S_NODE_58150_length_188_cov_6.344371_g58008_i0 PRJNA399711 58150 188 6.344371 11.92741748 uncultured Verrucomicrobiota bacterium 156588 Bacteria Bacteria 224 3.23e-54   NTclustered gi|226525288|gb|FJ872373.1| 156588 g58008 i0 99.2 153.531914893617 125 0 66 1 1 124 15369 15493 Uncultured Verrucomicrobia bacterium clone 118 genomic sequence blastn 28864 224 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured Verrucomicrobiota bacterium
26379091 26379091 PRJNA399711_S_NODE_23479_length_260_cov_8.349776_g23337_i0 PRJNA399711 23479 260 8.349776 21.7094176 Opitutia bacterium KCR 482 3034326 Bacteria Bacteria 60.2 1.42e-4   NTclustered gi|2707273910|gb|CP149973.1| 3034326 g23337 i0 91.111 0.173076923076923 45 3 17 1 103 146 2219902 2219858 Opitutia bacterium KCR 482 chromosome, complete genome blastn 45 60.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia       Opitutia bacterium KCR 482

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