RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA946307" 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

  • PRJNA946307 · 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
27783832 27783832 PRJNA946307_P_NODE_93024_length_187_cov_2.340580_g92150_i0 PRJNA946307 93024 187 2.34058 4.3768846 Synergistaceae bacterium 2053624 Bacteria Bacteria 60.1 1.35e-8   NR MDR1049327.1 2053624 g92150 i0 80.6 0.497326203208556 31 6 49.7 0 175 83 467 497 MDR1049327.1 4-alpha-glucanotransferase [Synergistaceae bacterium] diamond 93 60.1 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
28825324 28825324 PRJNA946307_P_NODE_92868_length_187_cov_2.688406_g91994_i0 PRJNA946307 92868 187 2.688406 5.02731922 Synergistaceae bacterium 2053624 Bacteria Bacteria 105 3.2600000000000004e-27   NR MFA5458134.1 2053624 g91994 i0 98.2 0.914438502673797 57 1 91.4 0 184 14 12 68 MFA5458134.1 hypothetical protein [Synergistaceae bacterium] diamond 171 105 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
29362430 29362430 PRJNA946307_P_NODE_87789_length_189_cov_4.642857_g86915_i0 PRJNA946307 87789 189 4.642857 8.77499973 Pyramidobacter piscolens 638849 Bacteria Bacteria 124 2.55e-31   NR WP_315507602.1 638849 g86915 i0 90.3 0.984126984126984 62 3 93.7 1 177 1 663 724 WP_315507602.1 phage/plasmid primase, P4 family [Pyramidobacter piscolens] diamond 186 124 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Pyramidobacter Pyramidobacter piscolens
30183376 30183376 PRJNA946307_P_NODE_163792_length_161_cov_3.357143_g162918_i0 PRJNA946307 163792 161 3.357143 5.40500023 Synergistaceae bacterium 2053624 Bacteria Bacteria 42.7 0.00646   NR MDI3533296.1 2053624 g162918 i0 63.6 0.614906832298137 33 12 61.5 0 2 100 49 81 MDI3533296.1 hypothetical protein [Synergistaceae bacterium] diamond 99 42.7 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
30310309 30310309 PRJNA946307_P_NODE_163152_length_162_cov_0.902655_g162278_i0 PRJNA946307 163152 162 0.902655 1.4623011 Fretibacterium fastidiosum 651822 Bacteria Bacteria 65.5 9.01e-11   NR WP_015556731.1 651822 g162278 i0 93.5 0.574074074074074 31 2 57.4 0 158 66 282 312 WP_015556731.1 phage major capsid protein [Fretibacterium fastidiosum] diamond 93 65.5 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
31890209 31890209 PRJNA946307_P_NODE_124357_length_173_cov_2.233871_g123483_i0 PRJNA946307 124357 173 2.233871 3.86459683 Synergistaceae bacterium 2053624 Bacteria Bacteria 57.8 6.66e-8   NR MDR1579240.1 2053624 g123483 i0 78.1 0.554913294797688 32 7 55.5 0 66 161 1 32 MDR1579240.1 ABC transporter ATP-binding protein [Synergistaceae bacterium] diamond 96 57.8 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
32270242 32270242 PRJNA946307_P_NODE_64398_length_200_cov_5.304636_g63524_i0 PRJNA946307 64398 200 5.304636 10.609272 Synergistaceae bacterium 2053624 Bacteria Bacteria 43.9 0.00835   NR MDR1515767.1 2053624 g63524 i0 52.8 0.54 36 17 54 0 108 1 510 545 MDR1515767.1 NHLP family bacteriocin export ABC transporter peptidase/permease/ATPase subunit [Synergistaceae bacterium] diamond 108 43.9 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
32396640 32396640 PRJNA946307_P_NODE_112459_length_178_cov_3.170543_g111585_i0 PRJNA946307 112459 178 3.170543 5.64356654 Synergistaceae bacterium 2053624 Bacteria Bacteria 55.1 6.97e-7   NR NLX75651.1 2053624 g111585 i0 44.6 0.943820224719101 56 31 94.4 0 5 172 415 470 NLX75651.1 zinc carboxypeptidase [Synergistaceae bacterium] diamond 168 55.1 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);;