RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA561212 · 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
6923628 6923628 PRJNA561212_P_NODE_9766_length_353_cov_1.125000_g9555_i0 PRJNA561212 9766 353 1.125 3.97125 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 344 4.92e-90   NTclustered gi|2874253779|emb|OY969763.1| 412056 g9555 i0 85.671 75.371104815864 328 45 93 2 18 344 3832605 3832279 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 26606 344 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
8198302 8198302 PRJNA561212_P_NODE_21207_length_251_cov_0.876404_g20996_i0 PRJNA561212 21207 251 0.876404 2.19977404 Fontisphaera persica 2974023 Bacteria Bacteria 359 1.2e-94   NTclustered gi|2439237958|gb|CP116615.1| 2974023 g20996 i0 94.421 140.247011952191 233 13 93 0 12 244 3863253 3863485 Fontisphaera persica strain B-154 chromosome, complete genome blastn 35202 359 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Limisphaerales Fontisphaeraceae Fontisphaera Fontisphaera persica
15848122 15848122 PRJNA561212_P_NODE_12753_length_312_cov_1.230126_g12542_i0 PRJNA561212 12753 312 1.230126 3.83799312 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 359 1.5299999999999998e-94   NTclustered gi|2874253690|emb|OY969416.1| 412056 g12542 i0 88.667 26.1185897435897 300 27 95 6 10 304 1316380 1316677 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 8149 359 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
20947746 20947746 PRJNA561212_P_NODE_9997_length_349_cov_1.094203_g9786_i0 PRJNA561212 9997 349 1.094203 3.81876847 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 536 7.459999999999997e-148   NTclustered gi|2874253690|emb|OY969416.1| 412056 g9786 i0 95.015 257.819484240688 341 17 98 0 9 349 1315691 1316031 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 89979 536 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
22222538 22222538 PRJNA561212_P_NODE_3778_length_568_cov_2.135354_g3571_i0 PRJNA561212 3778 568 2.135354 12.12881072 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 678 0   NTclustered gi|2874253690|emb|OY969416.1| 412056 g3571 i0 88.969 217.588028169014 553 56 97 3 9 560 1314951 1315499 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 123590 678 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium

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