RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1227535" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1227535 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
26775203 26775203 PRJNA1227535_P_NODE_31561_length_238_cov_2.587879_g31437_i0 PRJNA1227535 31561 238 2.587879 6.15915202 Pseudomonadati 3379134 Bacteria Bacteria 71.6 1.47e-12   NR WP_093395495.1 39841 g31437 i0 61.5 1.42436974789916 52 20 65.5 0 81 236 4 55 WP_093395495.1 metallophosphoesterase [Thermodesulforhabdus norvegica] diamond 339 71.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Thermodesulforhabdaceae Thermodesulforhabdus Thermodesulforhabdus norvegica
26788061 26788061 PRJNA1227535_P_NODE_9581_length_294_cov_2.357466_g9458_i0 PRJNA1227535 9581 294 2.357466 6.93095004 Thermodesulfobacteriales bacterium 2528040 Bacteria Bacteria 131 1.15e-34   NR TFG74495.1 2528040 g9458 i0 71.9 0.979591836734694 96 26 98 1 292 5 237 331 TFG74495.1 MAG: hypothetical protein E4H21_10755 [Thermodesulfobacteriales bacterium] diamond 288 131 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales     Thermodesulfobacteriales bacterium
28449691 28449691 PRJNA1227535_P_NODE_15466_length_273_cov_2.505000_g15343_i0 PRJNA1227535 15466 273 2.505 6.83865 Pseudomonadati 3379134 Bacteria Bacteria 99.4 6.75e-22   NR MDR3361910.1 885 g15343 i0 59.7 2.74725274725275 72 29 79.1 0 218 3 639 710 MDR3361910.1 BREX-1 system adenine-specific DNA-methyltransferase PglX [Desulfovibrio sp.] diamond 750 100 0.994 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
29093986 29093986 PRJNA1227535_P_NODE_29368_length_244_cov_0.871345_g29244_i0 PRJNA1227535 29368 244 0.871345 2.1260818 Desulfobacterales bacterium 2044940 Bacteria Bacteria 96.3 5.0499999999999987e-23   NR MBS3732482.1 2044940 g29244 i0 88.9 0.663934426229508 54 6 66.4 0 242 81 114 167 MBS3732482.1 hypothetical protein [Desulfobacterales bacterium] diamond 162 96.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31747803 31747803 PRJNA1227535_P_NODE_13637_length_280_cov_1.265700_g13514_i0 PRJNA1227535 13637 280 1.2657 3.5439600000000002 Desulfuromonadales bacterium 2099678 Bacteria Bacteria 105 5.3699999999999995e-25   NR MCK4620707.1 2099678 g13514 i0 60 0.964285714285714 90 34 96.4 1 278 9 156 243 MCK4620707.1 ParB/RepB/Spo0J family partition protein [Desulfuromonadales bacterium] diamond 270 105 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales     Desulfuromonadales bacterium
32853789 32853789 PRJNA1227535_P_NODE_13180_length_281_cov_2.052885_g13057_i0 PRJNA1227535 13180 281 2.052885 5.76860685 Desulfurivibrionaceae bacterium 3024425 Bacteria Bacteria 94.7 3.21e-20   NR MFO7607497.1 3024425 g13057 i0 46.7 0.98220640569395 92 49 98.2 0 2 277 1405 1496 MFO7607497.1 dockerin type I domain-containing protein [Desulfurivibrionaceae bacterium] diamond 276 94.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfurivibrionaceae   Desulfurivibrionaceae 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);;