RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA309466" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA309466 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
26599098 26599098 PRJNA309466_P_NODE_11601_length_189_cov_1.092857_g11544_i0 PRJNA309466 11601 189 1.092857 2.06549973 Nocardia carnea 37328 Bacteria Bacteria 40 0.0456   NR WP_033245318.1 37328 g11544 i0 39.5 0.603174603174603 38 23 60.3 0 19 132 39 76 WP_033245318.1 hypothetical protein, partial [Nocardia carnea] diamond 114 40 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia carnea
28842588 28842588 PRJNA309466_P_NODE_17028_length_165_cov_0.887931_g16971_i0 PRJNA309466 17028 165 0.887931 1.46508615 Beutenbergiaceae bacterium 3012325 Bacteria Bacteria 41.2 0.0447   NR HLS25559.1 3012325 g16971 i0 43.6 0.709090909090909 39 22 70.9 0 146 30 62 100 HLS25559.1 hypothetical protein [Beutenbergiaceae bacterium] diamond 117 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Beutenbergiaceae   Beutenbergiaceae bacterium
29316334 29316334 PRJNA309466_P_NODE_13869_length_176_cov_3.968504_g13812_i0 PRJNA309466 13869 176 3.968504 6.98456704 Candidatus Anoxymicrobiaceae bacterium 2952901 Bacteria Bacteria 44.3 0.0043   NR HEY5494628.1 2952901 g13812 i0 46.9 0.835227272727273 49 25 81.8 1 144 1 101 149 HEY5494628.1 glycosyltransferase [Candidatus Anoxymicrobiaceae bacterium] diamond 147 44.3 1 Bacteria   Bacillati Actinomycetota Candidatus Geothermincolia Candidatus Geothermincolales Candidatus Anoxymicrobiaceae   Candidatus Anoxymicrobiaceae bacterium
29442389 29442389 PRJNA309466_P_NODE_8970_length_207_cov_1.943038_g8913_i0 PRJNA309466 8970 207 1.943038 4.02208866 Streptomyces genisteinicus 2768068 Bacteria Bacteria 43.9 0.00226   NR QNP67920.1 2768068 g8913 i0 38.7 1.79710144927536 62 38 89.9 0 19 204 28 89 QNP67920.1 hypothetical protein IAG43_33820 [Streptomyces genisteinicus] diamond 372 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces genisteinicus
29744113 29744113 PRJNA309466_P_NODE_16250_length_167_cov_0.881356_g16193_i0 PRJNA309466 16250 167 0.881356 1.47186452 Corynebacterium 1716 Bacteria Bacteria 115 5.750000000000001e-29   NR MDU7286123.1 161879 g16193 i0 100 6.91616766467066 55 0 98.8 0 3 167 88 142 MDU7286123.1 ATP-binding cassette domain-containing protein [Corynebacterium kroppenstedtii] diamond 1155 115 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium kroppenstedtii
29979450 29979450 PRJNA309466_P_NODE_17731_length_163_cov_0.912281_g17674_i0 PRJNA309466 17731 163 0.912281 1.48701803 Lawsonella clevelandensis 1528099 Bacteria Bacteria 102 1.3899999999999998e-23   NR WP_306559082.1 1528099 g17674 i0 100 0.975460122699387 53 0 97.5 0 5 163 273 325 WP_306559082.1 sensor histidine kinase [Lawsonella clevelandensis] diamond 159 102 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
31274914 31274914 PRJNA309466_P_NODE_5115_length_255_cov_11.990291_g5058_i0 PRJNA309466 5115 255 11.990291 30.57524205 Corynebacterium glucuronolyticum 39791 Bacteria Bacteria 40.4 0.048   NR WP_221389519.1 39791 g5058 i0 31.7 0.741176470588235 63 39 69.4 2 61 237 5 67 WP_221389519.1 hypothetical protein, partial [Corynebacterium glucuronolyticum] diamond 189 40.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium glucuronolyticum
31306521 31306521 PRJNA309466_P_NODE_17355_length_164_cov_0.904348_g17298_i0 PRJNA309466 17355 164 0.904348 1.48313072 Lawsonella clevelandensis 1528099 Bacteria Bacteria 87.8 1.68e-18   NR WP_394268176.1 1528099 g17298 i0 97.8 1.64634146341463 45 1 82.3 0 164 30 711 755 WP_394268176.1 ATP-dependent Clp protease ATP-binding subunit, partial [Lawsonella clevelandensis] diamond 270 87.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
31939065 31939065 PRJNA309466_P_NODE_8577_length_210_cov_5.608696_g8520_i0 PRJNA309466 8577 210 5.608696 11.7782616 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 53.5 4.12e-7   NR HKY47145.1 2080302 g8520 i0 36.5 0.9 63 33 85.7 2 180 1 29 87 HKY47145.1 hypothetical protein [Acidimicrobiia bacterium] diamond 189 53.5 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
32792171 32792171 PRJNA309466_P_NODE_18760_length_158_cov_7.908257_g18703_i0 PRJNA309466 18760 158 7.908257 12.49504606 Gaiellaceae bacterium 2838783 Bacteria Bacteria 42.4 0.0161   NR MDF2749474.1 2838783 g18703 i0 59.3 2.0506329113924 27 11 51.3 0 3 83 304 330 MDF2749474.1 major facilitator superfamily 1 [Gaiellaceae bacterium] diamond 324 42.4 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae 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);;