RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB14803" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14803 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
2261099 2261099 PRJEB14803_P_NODE_35802_length_177_cov_1.690141_g35336_i0 PRJEB14803 35802 177 1.690141 2.99154957 Treponema 157 Bacteria Bacteria 233 4.9799999999999995e-57   NTclustered gi|1928027651|gb|CP061839.1| 409322 g35336 i0 90.503 96.3107344632768 179 14 100 3 1 177 388028 387851 Treponema pedis strain KS1 chromosome, complete genome blastn 17047 233 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis
6399597 6399597 PRJEB14803_P_NODE_27706_length_208_cov_1.710983_g27240_i0 PRJEB14803 27706 208 1.710983 3.55884464 Brachyspira hampsonii 1287055 Bacteria Bacteria 54.7 0.005   NTclustered gi|1214564172|gb|CP019914.1| 1287055 g27240 i0 92.308 0.1875 39 2 19 1 2 40 2585415 2585452 Brachyspira hampsonii strain NSH-16 chromosome, complete genome blastn 39 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira hampsonii
12464982 12464982 PRJEB14803_P_NODE_47650_length_150_cov_1.043478_g47184_i0 PRJEB14803 47650 150 1.043478 1.565217 root 1 Root_unresolved Root_unresolved 60.2 7.3e-5   NTclustered gi|1919550644|gb|CP031517.1| 744512 g47184 i0 100 0.933333333333333 32 0 21 0 95 126 391496 391527 Treponema rectale strain CHPA chromosome, complete genome blastn 140 60.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema rectale
15323544 15323544 PRJEB14803_P_NODE_17773_length_280_cov_1.608163_g17307_i0 PRJEB14803 17773 280 1.608163 4.5028564 Treponema medium 58231 Bacteria Bacteria 490 4.61e-134   NTclustered gi|1996291085|gb|CP027017.1| 58231 g17307 i0 98.221 184.082142857143 281 4 100 1 1 280 1015093 1015373 Treponema medium strain T19 chromosome, complete genome blastn 51543 490 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
16288474 16288474 PRJEB14803_P_NODE_10013_length_408_cov_1.973190_g9548_i0 PRJEB14803 10013 408 1.97319 8.0506152 Treponema 157 Bacteria Bacteria 704 0   NTclustered gi|2586379|gb|AF023056.1|AF023056 67509 g9548 i0 97.794 100.941176470588 408 9 100 0 1 408 754 347 Treponema sp. I:L:Y1 16S ribosomal RNA gene, complete sequence blastn 41184 710 0.991549295774648 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. I:L:Y1
20112376 20112376 PRJEB14803_P_NODE_45056_length_154_cov_2.100840_g44590_i0 PRJEB14803 45056 154 2.10084 3.2352936 Treponema 157 Bacteria Bacteria 285 1.14e-72   NTclustered gi|2265136109|gb|CP051197.1| 69710 g44590 i0 100 193 154 0 100 0 1 154 326963 327116 Treponema vincentii strain OMZ 802 chromosome, complete genome blastn 29722 285 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii

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