RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB14803 · 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
7673540 7673540 PRJEB14803_P_NODE_10167_length_404_cov_1.485095_g9702_i0 PRJEB14803 10167 404 1.485095 5.9997838 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 505 2.4699999999999995e-138   NTclustered gi|2874254040|emb|OY970364.1| 412056 g9702 i0 89.356 177.935643564356 404 39 99 4 3 404 2169037 2168636 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1 blastn 71886 505 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
7673758 7673758 PRJEB14803_P_NODE_43487_length_158_cov_0.959350_g43021_i0 PRJEB14803 43487 158 0.95935 1.515773 Akkermansia muciniphila 239935 Bacteria Bacteria 291 2.54e-74   NTclustered gi|2756360508|gb|CP156688.1| 239935 g43021 i0 100 294.126582278481 157 0 99 0 2 158 361670 361826 Akkermansia muciniphila strain AKK-TMU chromosome, complete genome blastn 46472 291 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia muciniphila
8948582 8948582 PRJEB14803_P_NODE_7108_length_503_cov_2.222222_g6655_i0 PRJEB14803 7108 503 2.222222 11.17777666 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 739 0   NTclustered gi|2874253690|emb|OY969416.1| 412056 g6655 i0 94.572 202.17097415507 479 24 95 2 1 478 1316169 1315692 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 101692 739 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
11499438 11499438 PRJEB14803_P_NODE_18730_length_270_cov_2.527660_g18264_i0 PRJEB14803 18730 270 2.52766 6.824682 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 416 7.619999999999998e-112   NTclustered gi|2874254096|emb|OY970179.1| 412056 g18264 i0 94.444 125.9 270 15 100 0 1 270 1728115 1728384 MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1 blastn 33993 416 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
15323691 15323691 PRJEB14803_P_NODE_42373_length_160_cov_1.280000_g41907_i0 PRJEB14803 42373 160 1.28 2.048 Methylacidimicrobium sp. AP8 2730359 Bacteria Bacteria 52.8 0.013   NTclustered gi|1934804479|emb|LR797830.1| 2730359 g41907 i0 100 0.175 28 0 18 0 126 153 1550124 1550097 Methylacidimicrobium sp. AP8 isolate MTHMO1 genome assembly, chromosome: I blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota       Methylacidimicrobium Methylacidimicrobium sp. AP8

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