RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB14175", tax_kingdom = "Thermotogati" and tax_phylum = "Synergistota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Synergistota · 7 ✖

tax_kingdom 1

  • Thermotogati · 7 ✖

bioproject 1

  • PRJEB14175 · 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
25911340 25911340 PRJEB14175_P_NODE_145812_length_282_cov_1.927602_g143545_i0 PRJEB14175 145812 282 1.927602 5.43583764 Aminivibrio sp. 1872489 Bacteria Bacteria 172 3.29e-51   NR HRX25265.1 1872489 g143545 i0 98.8 1.78723404255319 84 1 89.4 0 30 281 172 255 HRX25265.1 FtsW/RodA/SpoVE family cell cycle protein [Aminivibrio sp.] diamond 504 172 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminivibrio Aminivibrio sp.
26188657 26188657 PRJEB14175_P_NODE_263654_length_197_cov_17.875000_g261386_i0 PRJEB14175 263654 197 17.875 35.21375 Fretibacterium fastidiosum 651822 Bacteria Bacteria 139 1.27e-28   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g261386 i0 82.317 3.18274111675127 164 25 82 4 1 162 2209555 2209716 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 627 139 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
26425288 26425288 PRJEB14175_P_NODE_205663_length_224_cov_1.423313_g203396_i0 PRJEB14175 205663 224 1.423313 3.18822112 Thermanaerovibrio 81461 Bacteria Bacteria 176 1.13e-39   NTclustered gi|470485441|ref|NR_076701.1| 81462 g203396 i0 85.799 16.8258928571429 169 21 75 3 51 218 350 516 Thermanaerovibrio acidaminovorans strain Su883 23S ribosomal RNA gene, complete sequence blastn 3769 176 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Thermanaerovibrio Thermanaerovibrio acidaminovorans
32927141 32927141 PRJEB14175_P_NODE_62201_length_470_cov_1.721271_g59945_i0 PRJEB14175 62201 470 1.721271 8.0899737 Synergistaceae bacterium 2053624 Bacteria Bacteria 132 6.810000000000001e-33   NR MBQ9629339.1 2053624 g59945 i0 58 5.7 112 40 71.5 1 126 461 2 106 MBQ9629339.1 DNA polymerase III subunit gamma/tau [Synergistaceae bacterium] diamond 2679 132 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
32939651 32939651 PRJEB14175_P_NODE_201809_length_227_cov_1.216867_g199542_i0 PRJEB14175 201809 227 1.216867 2.76228809 Bacteria 2 Bacteria Bacteria 45.4 0.00329   NR WP_367340937.1 1872489 g199542 i0 66.7 1.98237885462555 27 9 35.7 0 148 68 300 326 WP_367340937.1 IS3 family transposase [Aminivibrio sp.] diamond 450 45.4 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminivibrio Aminivibrio sp.
33079773 33079773 PRJEB14175_P_NODE_188166_length_238_cov_1.084746_g185899_i0 PRJEB14175 188166 238 1.084746 2.58169548 uncultured Cloacibacillus sp. 889794 Bacteria Bacteria 62.8 2.92e-9   NR WP_294193591.1 889794 g185899 i0 45.5 0.970588235294118 77 40 94.5 1 233 9 462 538 WP_294193591.1 DUF262 domain-containing protein [uncultured Cloacibacillus sp.] diamond 231 62.8 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Cloacibacillus uncultured Cloacibacillus sp.
33147896 33147896 PRJEB14175_P_NODE_176600_length_248_cov_1.983957_g174333_i0 PRJEB14175 176600 248 1.983957 4.92021336 Cloacibacillus porcorum 1197717 Bacteria Bacteria 43.9 0.0151   NR WP_277002470.1 1197717 g174333 i0 32.1 1.95967741935484 81 45 95.6 4 243 7 160 232 WP_277002470.1 cation-translocating P-type ATPase, partial [Cloacibacillus porcorum] diamond 486 43.9 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Cloacibacillus Cloacibacillus porcorum

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