RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1093380" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1093380 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
19324879 19324879 PRJNA1093380_P_NODE_2836_length_354_cov_2.064057_g2730_i0 PRJNA1093380 2836 354 2.064057 7.30676178 Bacteria 2 Bacteria Bacteria 192 1.8e-54   NR 1TAQ_A 271 g2730 i0 98.9 3.97457627118644 95 1 80.5 0 70 354 1 95 1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus] diamond 1407 192 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
24425095 24425095 PRJNA1093380_P_NODE_4960_length_292_cov_2.109589_g4854_i0 PRJNA1093380 4960 292 2.109589 6.15999988 Bacteria 2 Bacteria Bacteria 179 3.11e-50   NR 1TAQ_A 271 g4854 i0 97.9 2.98972602739726 97 2 99.7 0 292 2 717 813 1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus] diamond 873 179 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
26655857 26655857 PRJNA1093380_P_NODE_9301_length_266_cov_1.595855_g9195_i0 PRJNA1093380 9301 266 1.595855 4.2449743 uncultured Truepera sp. 543023 Bacteria Bacteria 169 2.13e-52   NR CAA9570812.1 543023 g9195 i0 95.5 0.992481203007519 88 4 99.2 0 2 265 17 104 CAA9570812.1 MAG: SSU ribosomal protein S9p (S16e) [uncultured Truepera sp.] diamond 264 169 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
31110062 31110062 PRJNA1093380_P_NODE_17335_length_237_cov_3.182927_g17229_i0 PRJNA1093380 17335 237 3.182927 7.54353699 Deinococcus marmoris 249408 Bacteria Bacteria 45.1 0.00505   NR WP_156039117.1 249408 g17229 i0 51.7 0.734177215189873 58 26 73.4 1 211 38 158 213 WP_156039117.1 Ig-like domain-containing protein [Deinococcus marmoris] diamond 174 45.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus marmoris
31259671 31259671 PRJNA1093380_P_NODE_1335_length_480_cov_4.034398_g1231_i0 PRJNA1093380 1335 480 4.034398 19.3651104 root 1 Root_unresolved Root_unresolved 304 1.87e-98   NR AAX47270.1 271 g1231 i0 98.7 3.95 159 2 99.4 0 478 2 142 300 AAX47270.1 DNA polymerase large fragment, partial [Thermus aquaticus] diamond 1896 305 0.99672131147541 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus

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