RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1143173" and tax_phylum = "Synergistota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Synergistota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1143173 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
286027 286027 PRJNA1143173_P_NODE_19861_length_287_cov_6.196262_g19835_i0 PRJNA1143173 19861 287 6.196262 17.78327194 Fretibacterium fastidiosum 651822 Bacteria Bacteria 514 2.82e-141   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g19835 i0 98.955 2 287 3 100 0 1 287 457727 458013 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 574 514 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
286151 286151 PRJNA1143173_P_NODE_25641_length_270_cov_5.015228_g25615_i0 PRJNA1143173 25641 270 5.015228 13.5411156 Fretibacterium fastidiosum 651822 Bacteria Bacteria 368 2.16e-97   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g25615 i0 91.418 1.98518518518519 268 23 99 0 1 268 457253 457520 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 536 368 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
5389207 5389207 PRJNA1143173_P_NODE_15705_length_298_cov_3.306667_g15679_i0 PRJNA1143173 15705 298 3.306667 9.85386766 Fretibacterium fastidiosum 651822 Bacteria Bacteria 278 4.2e-70   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g15679 i0 97.531 1.08724832214765 162 4 54 0 137 298 1838727 1838566 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 324 278 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
6664506 6664506 PRJNA1143173_P_NODE_42686_length_210_cov_7.248175_g42660_i0 PRJNA1143173 42686 210 7.248175 15.2211675 Fretibacterium fastidiosum 651822 Bacteria Bacteria 243 1.02e-59   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g42660 i0 89.894 4.52857142857143 188 19 90 0 1 188 232861 233048 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 951 243 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
14315427 14315427 PRJNA1143173_P_NODE_37552_length_235_cov_3.981481_g37526_i0 PRJNA1143173 37552 235 3.981481 9.35648035 Fretibacterium fastidiosum 651822 Bacteria Bacteria 313 8.75e-81   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g37526 i0 91.703 38.7744680851064 229 14 98 5 9 235 892128 891903 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 9112 313 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
16863297 16863297 PRJNA1143173_P_NODE_24774_length_273_cov_2.590000_g24748_i0 PRJNA1143173 24774 273 2.59 7.0707 Fretibacterium fastidiosum 651822 Bacteria Bacteria 422 1.66e-113   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g24748 i0 94.505 88.0879120879121 273 15 100 0 1 273 2095849 2096121 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 24048 422 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
18138188 18138188 PRJNA1143173_P_NODE_33575_length_247_cov_7.574713_g33549_i0 PRJNA1143173 33575 247 7.574713 18.70954111 Fretibacterium fastidiosum 651822 Bacteria Bacteria 322 1.54e-83   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g33549 i0 90.244 1.9919028340081 246 24 99 0 1 246 362240 361995 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 492 322 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
20687400 20687400 PRJNA1143173_P_NODE_13457_length_299_cov_6.778761_g13431_i0 PRJNA1143173 13457 299 6.778761 20.268495389999998 Fretibacterium fastidiosum 651822 Bacteria Bacteria 255 1.97e-63   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g13431 i0 97.333 2.0066889632107 150 4 100 0 1 150 1995001 1994852 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 600 255 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
23238273 23238273 PRJNA1143173_P_NODE_12139_length_309_cov_7.822034_g12113_i0 PRJNA1143173 12139 309 7.822034 24.17008506 Fretibacterium fastidiosum 651822 Bacteria Bacteria 248 3.43e-61   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g12113 i0 96.644 1.41423948220065 149 5 97 0 161 309 1520892 1520744 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 437 248 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
24511807 24511807 PRJNA1143173_P_NODE_12460_length_307_cov_11.696581_g12434_i0 PRJNA1143173 12460 307 11.696581 35.90850367 Fretibacterium fastidiosum 651822 Bacteria Bacteria 233 9.53e-57   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g12434 i0 94.667 1.93485342019544 150 8 97 0 158 307 2113954 2113805 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 594 233 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum

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