RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA558770", tax_kingdom = "Thermotogati" and tax_phylum = "Synergistota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Synergistota · 6 ✖

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJNA558770 · 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
1815949 1815949 PRJNA558770_P_NODE_266922_length_234_cov_1.964824_g264917_i0 PRJNA558770 266922 234 1.964824 4.59768816 Fretibacterium fastidiosum 651822 Bacteria Bacteria 134 7.28e-27   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g264917 i0 98.667 53.1495726495726 75 1 63 0 160 234 69461 69387 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 12437 134 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
13292311 13292311 PRJNA558770_P_NODE_155191_length_234_cov_6.065327_g153186_i0 PRJNA558770 155191 234 6.065327 14.19286518 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 92 1.2e-19   NR WP_303296111.1 638849 g153186 i0 62.8 8 78 2 100 1 1 234 248 298 WP_303296111.1 N-6 DNA methylase [Pyramidobacter piscolens] diamond 1872 92.8 0.991379310344828 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Pyramidobacter Pyramidobacter piscolens
26871830 26871830 PRJNA558770_P_NODE_249661_length_234_cov_2.316583_g247656_i0 PRJNA558770 249661 234 2.316583 5.42080422 Bacteria 2 Bacteria Bacteria 42.4 0.0335   NR MDR1481780.1 2053624 g247656 i0 82.6 0.858974358974359 23 4 29.5 0 74 6 125 147 MDR1481780.1 O-acetyl-ADP-ribose deacetylase [Synergistaceae bacterium] diamond 201 42.4 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
27173559 27173559 PRJNA558770_P_NODE_355082_length_232_cov_12.111675_g353077_i0 PRJNA558770 355082 232 12.111675 28.099086 uncultured Fretibacterium sp. 1678694 Bacteria Bacteria 56.2 5.82e-7   NR WP_299300242.1 1678694 g353077 i0 32.7 1.93965517241379 150 28 99.6 1 1 231 502 651 WP_299300242.1 AsmA-like C-terminal region-containing protein [uncultured Fretibacterium sp.] diamond 450 56.2 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium uncultured Fretibacterium sp.
27552610 27552610 PRJNA558770_P_NODE_196964_length_234_cov_3.904523_g194959_i0 PRJNA558770 196964 234 3.904523 9.13658382 uncultured Fretibacterium sp. 1678694 Bacteria Bacteria 80.9 2.26e-17   NR WP_366797457.1 1678694 g194959 i0 59.7 0.987179487179487 77 12 98.7 1 232 2 15 72 WP_366797457.1 Fur family transcriptional regulator, partial [uncultured Fretibacterium sp.] diamond 231 80.9 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium uncultured Fretibacterium sp.
28261333 28261333 PRJNA558770_P_NODE_284266_length_234_cov_1.668342_g282261_i0 PRJNA558770 284266 234 1.668342 3.90392028 Bacteria 2 Bacteria Bacteria 46.6 5.38e-4   NR WP_286952881.1 81466 g282261 i0 72 1.64102564102564 25 7 32.1 0 75 1 109 133 WP_286952881.1 MULTISPECIES: hypothetical protein [Aminobacterium] diamond 384 47 0.991489361702128 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminobacterium  

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