RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1249535" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1249535 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1631499 1631499 PRJNA1249535_S_NODE_224982_length_293_cov_2.690909_g221599_i0 PRJNA1249535 224982 293 2.690909 7.88436337 Brachyspira intermedia 84377 Bacteria Bacteria 52.8 0.027   NTclustered gi|343385146|gb|CP002874.1| 1045858 g221599 i0 100 0.0955631399317406 28 0 10 0 37 64 117030 117003 Brachyspira intermedia PWS/A, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira intermedia
2327822 2327822 PRJNA1249535_S_NODE_308162_length_248_cov_4.262857_g304779_i0 PRJNA1249535 308162 248 4.262857 10.57188536 Brachyspira 29521 Bacteria Bacteria 52.8 0.022   NTclustered gi|2514086334|gb|CP098754.1| 52584 g304779 i0 100 0.67741935483871 28 0 11 0 203 230 2248312 2248339 Brachyspira pilosicoli strain MEI4028 chromosome, complete genome blastn 168 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira pilosicoli
2908438 2908438 PRJNA1249535_S_NODE_307723_length_249_cov_0.886364_g304340_i0 PRJNA1249535 307723 249 0.886364 2.20704636 Leptospira sp. 'Mane' 3387407 Bacteria Bacteria 52.8 0.023   NTclustered gi|2889308543|gb|CP177134.1| 3387407 g304340 i0 100 0.112449799196787 28 0 11 0 10 37 873373 873400 Leptospira sp. 'Mane' chromosome 1, complete sequence blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. 'Mane'
8012204 8012204 PRJNA1249535_S_NODE_66727_length_427_cov_7.101695_g63349_i0 PRJNA1249535 66727 427 7.101695 30.32423765 Borrelia puertoricensis 2756107 Bacteria Bacteria 52.8 0.041   NTclustered gi|2225483190|gb|CP075381.1| 2756107 g63349 i0 100 0.0655737704918033 28 0 7 0 232 259 937 964 Borrelia puertoricensis strain SUM plasmid cp28-1, complete sequence blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia puertoricensis
16935266 16935266 PRJNA1249535_S_NODE_338814_length_224_cov_4.807947_g335431_i0 PRJNA1249535 338814 224 4.807947 10.76980128 Treponema denticola 158 Bacteria Bacteria 56.5 0.002   NTclustered gi|41821838|gb|AE017226.1| 243275 g335431 i0 96.97 0.147321428571429 33 1 15 0 64 96 2227797 2227829 Treponema denticola ATCC 35405, complete genome blastn 33 56.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
16935974 16935974 PRJNA1249535_S_NODE_65154_length_431_cov_5.751397_g61776_i0 PRJNA1249535 65154 431 5.751397 24.78852107 Treponema denticola 158 Bacteria Bacteria 58.4 8.94e-4   NTclustered gi|41821838|gb|AE017226.1| 243275 g61776 i0 94.595 0.08584686774942 37 2 9 0 156 192 933184 933220 Treponema denticola ATCC 35405, complete genome blastn 37 58.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
22033902 22033902 PRJNA1249535_S_NODE_266718_length_271_cov_1.994949_g263335_i0 PRJNA1249535 266718 271 1.994949 5.40631179 Treponema socranskii 53419 Bacteria Bacteria 52.8 0.025   NTclustered gi|2265187740|gb|CP054258.1| 69713 g263335 i0 100 0.206642066420664 28 0 10 0 13 40 2777969 2777942 Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome blastn 56 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema socranskii

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