RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB10140 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
1286885 1286885 PRJEB10140_P_NODE_263582_length_166_cov_0.888889_g246273_i0 PRJEB10140 263582 166 0.888889 1.47555574 Treponema denticola 158 Bacteria Bacteria 291 2.7099999999999998e-74   NTclustered gi|2265178430|gb|CP051633.1| 158 g246273 i0 98.193 23.8915662650602 166 3 100 0 1 166 2537612 2537777 Treponema denticola strain OMZ 898 chromosome, complete genome blastn 3966 291 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
5115405 5115405 PRJEB10140_P_NODE_33505_length_1035_cov_7.553753_g20839_i0 PRJEB10140 33505 1035 7.553753 78.18134355 Borreliella tanukii 56146 Bacteria Bacteria 56.5 0.008   NTclustered gi|2537415626|gb|CP124025.1| 56146 g20839 i0 96.97 0.0956521739130435 33 1 3 0 699 731 38568 38536 Borreliella tanukii strain TanegashimaAS9 plasmid lp54, complete sequence blastn 99 56.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella tanukii
7663708 7663708 PRJEB10140_P_NODE_103407_length_354_cov_0.940984_g86108_i0 PRJEB10140 103407 354 0.940984 3.33108336 Spirochaetia bacterium 2053615 Bacteria Bacteria 54.7 0.009   NTclustered gi|2621703989|emb|OY762944.1| 2053615 g86108 i0 96.97 0.0932203389830508 33 0 9 1 316 347 3854768 3854800 MAG: Spirochaetia bacterium isolate 83205b95-8689-400e-a90b-095f28d6771d genome assembly, chromosome: 1 blastn 33 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
8938971 8938971 PRJEB10140_P_NODE_199748_length_195_cov_2.095890_g182439_i0 PRJEB10140 199748 195 2.09589 4.0869855 Spirochaetota bacterium 2202144 Bacteria Bacteria 52.8 0.017   NTclustered gi|2107719547|gb|CP070841.1| 2202144 g182439 i0 100 0.143589743589744 28 0 14 0 16 43 1960090 1960117 MAG: Spirochaetes bacterium isolate bin100 chromosome blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
10215725 10215725 PRJEB10140_P_NODE_28829_length_1170_cov_6.226583_g17474_i0 PRJEB10140 28829 1170 6.226583 72.8510211 Brachyspira pilosicoli 52584 Bacteria Bacteria 58.4 0.003   NTclustered gi|404429427|emb|HE793032.1| 1161918 g17474 i0 94.595 0.0316239316239316 37 2 3 0 499 535 272074 272038 Brachyspira pilosicoli WesB complete genome blastn 37 58.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira pilosicoli
17863313 17863313 PRJEB10140_P_NODE_120215_length_304_cov_2.450980_g102908_i0 PRJEB10140 120215 304 2.45098 7.4509792 Borrelia sp. A-FGy1 2608247 Bacteria Bacteria 52.8 0.028   NTclustered gi|1886106780|gb|CP043682.1| 2608247 g102908 i0 96.774 0.101973684210526 31 1 10 0 210 240 755866 755836 Borrelia sp. A-FGy1 chromosome blastn 31 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia sp. A-FGy1
21688672 21688672 PRJEB10140_P_NODE_207558_length_190_cov_1.432624_g190249_i0 PRJEB10140 207558 190 1.432624 2.7219856 Treponema socranskii 53419 Bacteria Bacteria 52.8 0.016   NTclustered gi|2265187740|gb|CP054258.1| 69713 g190249 i0 100 0.147368421052632 28 0 15 0 147 174 1924431 1924404 Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema socranskii
21689272 21689272 PRJEB10140_P_NODE_264278_length_166_cov_0.888889_g246969_i0 PRJEB10140 264278 166 0.888889 1.47555574 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 84.2 4.93e-12   NTclustered gi|2621786375|emb|OY782833.1| 2791017 g246969 i0 100 12.3373493975904 45 0 27 0 111 155 1664440 1664396 MAG: Sphaerochaetaceae bacterium isolate 4316afa4-75a5-40cd-90fd-6a37d92e054f genome assembly, chromosome: 1 blastn 2048 84.2 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);;