RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Synergistota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Synergistota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 8 ✖

analysis 1

  • diamond · 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
26469416 26469416 PRJEB20058_P_NODE_19328_length_944_cov_2.778029_g17279_i0 PRJEB20058 19328 944 2.778029 26.22459376 Fretibacterium sp. OH122 2699746 Bacteria Bacteria 320 3.09e-104   NR WP_124889134.1 2491047 g17279 i0 94 1.06779661016949 168 10 53.4 0 513 10 1 168 WP_124889134.1 glycine C-acetyltransferase [Fretibacterium sp. OH1220_COT-178] diamond 1008 320 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium sp. OH1220_COT-178
26474845 26474845 PRJEB20058_P_NODE_86520_length_443_cov_2.643979_g83731_i0 PRJEB20058 86520 443 2.643979 11.71282697 Fretibacterium sp. OH122 2699746 Bacteria Bacteria 201 3.16e-60   NR WP_124887202.1 2491047 g83731 i0 87.5 0.758465011286682 112 14 75.8 0 9 344 285 396 WP_124887202.1 cell division protein FtsZ [Fretibacterium sp. OH1220_COT-178] diamond 336 201 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium sp. OH1220_COT-178
32945253 32945253 PRJEB20058_P_NODE_204258_length_253_cov_2.651042_g201434_i0 PRJEB20058 204258 253 2.651042 6.70713626 Acetomicrobium sp. 1872099 Bacteria Bacteria 114 5.889999999999999e-28   NR MBP8674744.1 1872099 g201434 i0 66.7 1.77865612648221 75 25 88.9 0 24 248 97 171 MBP8674744.1 restriction endonuclease subunit S [Acetomicrobium sp.] diamond 450 114 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Acetomicrobiaceae Acetomicrobium Acetomicrobium sp.
32979099 32979099 PRJEB20058_P_NODE_117747_length_369_cov_1.733766_g114932_i0 PRJEB20058 117747 369 1.733766 6.39759654 Jonquetella 428711 Bacteria Bacteria 237 2.55e-76   NR WP_008519836.1 428711 g114932 i0 99.2 0.975609756097561 120 1 97.6 0 368 9 27 146 WP_008519836.1 MULTISPECIES: L-serine ammonia-lyase, iron-sulfur-dependent, subunit alpha [Jonquetella] diamond 360 237 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Jonquetella  
32980079 32980079 PRJEB20058_P_NODE_75123_length_479_cov_16.937799_g72345_i0 PRJEB20058 75123 479 16.937799 81.13205721 uncultured Fretibacterium sp. 1678694 Bacteria Bacteria 262 1.72e-83   NR WP_299075721.1 1678694 g72345 i0 91.7 1.79123173277662 145 12 90.8 0 457 23 186 330 WP_299075721.1 LCP family protein [uncultured Fretibacterium sp.] diamond 858 262 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium uncultured Fretibacterium sp.
33064781 33064781 PRJEB20058_P_NODE_220453_length_242_cov_2.298343_g217628_i0 PRJEB20058 220453 242 2.298343 5.56199006 Synergistaceae bacterium 2053624 Bacteria Bacteria 63.5 1.69e-9   NR NLA90347.1 2053624 g217628 i0 46.8 0.954545454545455 77 24 95.5 2 3 233 111 170 NLA90347.1 preprotein translocase subunit SecY [Synergistaceae bacterium] diamond 231 63.5 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
33116508 33116508 PRJEB20058_P_NODE_97247_length_414_cov_4.535411_g94444_i0 PRJEB20058 97247 414 4.535411 18.77660154 Synergistaceae bacterium 2053624 Bacteria Bacteria 251 1.12e-80   NR MBP8633137.1 2053624 g94444 i0 92.5 0.963768115942029 133 10 96.4 0 6 404 121 253 MBP8633137.1 histidinol-phosphate transaminase [Synergistaceae bacterium] diamond 399 251 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
33132564 33132564 PRJEB20058_P_NODE_131375_length_343_cov_9.109929_g128556_i0 PRJEB20058 131375 343 9.109929 31.24705647 Synergistaceae bacterium 2053624 Bacteria Bacteria 154 1.59e-44   NR MDR1732101.1 2053624 g128556 i0 78.4 0.848396501457726 97 21 84.8 0 18 308 45 141 MDR1732101.1 cobalamin-dependent protein [Synergistaceae bacterium] diamond 291 154 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae 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);;