RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA591127" and tax_phylum = "Synergistota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Synergistota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA591127 · 6 ✖

analysis 1

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
5668718 5668718 PRJNA591127_P_NODE_12485_length_208_cov_2.508772_g12316_i0 PRJNA591127 12485 208 2.508772 5.21824576 Fretibacterium fastidiosum 651822 Bacteria Bacteria 292 9.86e-75   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g12316 i0 92.611 29.3365384615385 203 15 99 0 4 206 69238 69036 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 6102 292 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
6943336 6943336 PRJNA591127_P_NODE_5986_length_300_cov_1.809886_g5818_i0 PRJNA591127 5986 300 1.809886 5.429658 Fretibacterium fastidiosum 651822 Bacteria Bacteria 233 9.29e-57   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g5818 i0 85.526 83.2933333333333 228 28 84 5 17 241 68590 68365 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 24988 233 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
6943352 6943352 PRJNA591127_P_NODE_8546_length_252_cov_3.176744_g8378_i0 PRJNA591127 8546 252 3.176744 8.00539488 Fretibacterium fastidiosum 651822 Bacteria Bacteria 311 3.41e-80   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g8378 i0 90.336 53.4920634920635 238 21 100 2 1 237 69600 69836 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 13480 311 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
13319139 13319139 PRJNA591127_P_NODE_8511_length_253_cov_1.486111_g8343_i0 PRJNA591127 8511 253 1.486111 3.75986083 Fretibacterium fastidiosum 651822 Bacteria Bacteria 302 2.06e-77   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g8343 i0 88.492 71.2371541501976 252 26 100 3 4 253 2282098 2281848 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 18023 302 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
18416819 18416819 PRJNA591127_P_NODE_11735_length_215_cov_3.207865_g11566_i0 PRJNA591127 11735 215 3.207865 6.89690975 Fretibacterium fastidiosum 651822 Bacteria Bacteria 296 7.93e-76   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g11566 i0 91.705 104.702325581395 217 13 100 5 1 215 68677 68890 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 22511 296 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
18416910 18416910 PRJNA591127_P_NODE_21695_length_190_cov_3.444444_g21526_i0 PRJNA591127 21695 190 3.444444 6.5444436 Fretibacterium fastidiosum 651822 Bacteria Bacteria 302 1.47e-77   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g21526 i0 95.288 77.1473684210526 191 8 100 1 1 190 69255 69445 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 14658 302 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);;