RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA345071" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA345071 · 7 ✖

analysis 1

  • diamond · 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
14422198 14422198 PRJNA345071_P_NODE_8692_length_249_cov_0.886364_g8652_i0 PRJNA345071 8692 249 0.886364 2.20704636 Myxococcales bacterium 2026763 Bacteria Bacteria 154 4.1199999999999984e-43   NR MBL9016715.1 2026763 g8652 i0 85.4 1.97590361445783 82 12 98.8 0 248 3 74 155 MBL9016715.1 hypothetical protein [Myxococcales bacterium] diamond 492 154 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
26631622 26631622 PRJNA345071_P_NODE_9561_length_246_cov_0.901734_g9521_i0 PRJNA345071 9561 246 0.901734 2.21826564 Myxococcota bacterium 2818507 Bacteria Bacteria 173 5.62e-50   NR MFM7204430.1 2818507 g9521 i0 98.8 1 82 1 100 0 246 1 159 240 MFM7204430.1 UDP-N-acetylmuramate:L-alanyl-gamma-D-glutamyl-meso-diaminopimelate ligase [Myxococcota bacterium] diamond 246 173 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
28418613 28418613 PRJNA345071_P_NODE_7366_length_255_cov_2.093407_g7326_i0 PRJNA345071 7366 255 2.093407 5.33818785 Sandaracinus 1055688 Bacteria Bacteria 47 0.00133   NR MCB9601600.1 2024858 g7326 i0 66.7 1.05882352941176 30 10 35.3 0 3 92 430 459 MCB9601600.1 hypothetical protein [Sandaracinus sp.] diamond 270 47 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Sandaracinaceae Sandaracinus Sandaracinus sp.
28811330 28811330 PRJNA345071_P_NODE_7308_length_256_cov_1.633880_g7268_i0 PRJNA345071 7308 256 1.63388 4.1827328 Kofleriaceae bacterium 2212474 Bacteria Bacteria 61.2 1.31e-8   NR HTJ41131.1 2212474 g7268 i0 53.8 0.609375 52 24 60.9 0 230 75 860 911 HTJ41131.1 hypothetical protein [Kofleriaceae bacterium] diamond 156 61.2 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
28906157 28906157 PRJNA345071_P_NODE_5208_length_287_cov_1.387850_g5168_i0 PRJNA345071 5208 287 1.38785 3.9831295 Kofleriaceae bacterium 2212474 Bacteria Bacteria 92.8 1.02e-19   NR MEO6772234.1 2212474 g5168 i0 48.5 2.05923344947735 101 34 99.3 3 285 1 146 234 MEO6772234.1 tyrosine-type recombinase/integrase [Kofleriaceae bacterium] diamond 591 92.8 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
31022688 31022688 PRJNA345071_P_NODE_7535_length_253_cov_1.733333_g7495_i0 PRJNA345071 7535 253 1.733333 4.38533249 Myxococcota bacterium 2818507 Bacteria Bacteria 56.2 7.43e-7   NR HUU01533.1 2818507 g7495 i0 43.1 0.770750988142292 65 36 75.9 1 14 205 277 341 HUU01533.1 hypothetical protein [Myxococcota bacterium] diamond 195 56.2 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
31971304 31971304 PRJNA345071_P_NODE_2698_length_358_cov_1.870175_g2658_i0 PRJNA345071 2698 358 1.870175 6.6952265 Kofleriaceae bacterium 2212474 Bacteria Bacteria 85.5 1.5e-16   NR HZJ64936.1 2212474 g2658 i0 49.6 0.946927374301676 113 50 93.9 4 339 4 727 833 HZJ64936.1 thrombospondin type 3 repeat-containing protein [Kofleriaceae bacterium] diamond 339 85.5 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae 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);;