RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA358009" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA358009 · 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
26663045 26663045 PRJNA358009_P_NODE_6441_length_327_cov_1.356115_g6378_i0 PRJNA358009 6441 327 1.356115 4.43449605 Deinococcus sp. 14RED 47478 Bacteria Bacteria 70.9 6.01e-13   NR WP_230288650.1 2745874 g6378 i0 100 0.275229357798165 30 0 27.5 0 11 100 37 66 WP_230288650.1 single-stranded DNA-binding protein, partial [Deinococcus sp. 14RED07] diamond 90 70.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. 14RED07
28653910 28653910 PRJNA358009_P_NODE_12407_length_169_cov_4.800000_g12338_i0 PRJNA358009 12407 169 4.8 8.112 Deinococcus caeni 569127 Bacteria Bacteria 106 2.85e-26   NR WP_345447753.1 569127 g12338 i0 100 0.940828402366864 53 0 94.1 0 3 161 126 178 WP_345447753.1 DUF4158 domain-containing protein [Deinococcus caeni] diamond 159 106 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus caeni
28938160 28938160 PRJNA358009_P_NODE_13028_length_167_cov_0.864407_g12959_i0 PRJNA358009 13028 167 0.864407 1.44355969 Deinococcus taklimakanensis 536443 Bacteria Bacteria 106 2.58e-25   NR WP_386842681.1 536443 g12959 i0 98.2 0.988023952095808 55 1 98.8 0 1 165 110 164 WP_386842681.1 protoporphyrinogen oxidase [Deinococcus taklimakanensis] diamond 165 106 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taklimakanensis
31545886 31545886 PRJNA358009_P_NODE_18116_length_153_cov_3.375000_g18047_i0 PRJNA358009 18116 153 3.375 5.16375 Deinococcus 1298 Bacteria Bacteria 99.8 3.04e-25   NR WP_380064595.1 569127 g18047 i0 100 8.29411764705882 47 0 92.2 0 144 4 70 116 WP_380064595.1 hypothetical protein [Deinococcus caeni] diamond 1269 99.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus caeni
31560419 31560419 PRJNA358009_P_NODE_11496_length_174_cov_1.280000_g11427_i0 PRJNA358009 11496 174 1.28 2.2272 Deinococcus sp. 47478 Bacteria Bacteria 113 1.2e-27   NR WP_291428500.1 47478 g11427 i0 93 0.982758620689655 57 4 98.3 0 172 2 114 170 WP_291428500.1 hypothetical protein [Deinococcus sp.] diamond 171 113 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
31703843 31703843 PRJNA358009_P_NODE_9257_length_187_cov_2.666667_g9188_i0 PRJNA358009 9257 187 2.666667 4.98666729 Deinococcus 1298 Bacteria Bacteria 95.5 2.92e-22   NR WP_189067546.1 1309407 g9188 i0 75 3.81818181818182 60 15 96.3 0 7 186 136 195 WP_189067546.1 tyrosine-type recombinase/integrase [Deinococcus radiotolerans] diamond 714 95.9 0.995828988529718 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiotolerans

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