RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA520845" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA520845 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_clade 0

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
4315128 4315128 PRJNA520845_P_NODE_139704_length_316_cov_1.308642_g138205_i0 PRJNA520845 139704 316 1.308642 4.13530872 Brachyspira intermedia 84377 Bacteria Bacteria 52.8 0.03   NTclustered gi|343385146|gb|CP002874.1| 1045858 g138205 i0 100 0.0886075949367089 28 0 9 0 170 197 3056810 3056837 Brachyspira intermedia PWS/A, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira intermedia
10693980 10693980 PRJNA520845_P_NODE_210929_length_253_cov_1.233333_g209430_i0 PRJNA520845 210929 253 1.233333 3.12033249 Borreliella lanei 373540 Bacteria Bacteria 58.4 4.93e-4   NTclustered gi|2537428790|gb|CP124054.1| 373540 g209430 i0 100 5.23320158102767 31 0 12 0 41 71 49314 49344 Borreliella lanei strain CA-28-91 chromosome, complete genome blastn 1324 58.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella lanei
17068239 17068239 PRJNA520845_P_NODE_243994_length_245_cov_1.343023_g242495_i0 PRJNA520845 243994 245 1.343023 3.29040635 Borreliella carolinensis 478174 Bacteria Bacteria 60.2 1.32e-4   NTclustered gi|2591852090|gb|CP132455.1| 478174 g242495 i0 94.872 0.159183673469388 39 0 16 2 198 236 8340 8376 Borreliella carolinensis strain MI-3 plasmid lp17, complete sequence blastn 39 60.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella carolinensis
20892131 20892131 PRJNA520845_P_NODE_208397_length_255_cov_1.263736_g206898_i0 PRJNA520845 208397 255 1.263736 3.2225268 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 204 6.04e-48   NTclustered gi|2621786047|emb|OY782505.1| 2791017 g206898 i0 81.496 83.9411764705882 254 41 97 4 1 248 2484355 2484608 MAG: Sphaerochaetaceae bacterium isolate dbdf49c1-f841-4570-9102-cd3a9ce64f89 genome assembly, chromosome: 1 blastn 21405 204 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae 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);;