RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA407368" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA407368 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
15717751 15717751 PRJNA407368_S_NODE_3033_length_341_cov_5.173077_g2931_i0 PRJNA407368 3033 341 5.173077 17.64019257 Mycoplasmopsis arginini 2094 Bacteria Bacteria 105 4.95e-26   NR WP_282460155.1 2094 g2931 i0 92.2 0.448680351906158 51 4 44.9 0 3 155 109 159 WP_282460155.1 glycoside hydrolase family 19 protein, partial [Mycoplasmopsis arginini] diamond 153 105 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
26758820 26758820 PRJNA407368_S_NODE_1801_length_464_cov_9.774713_g1704_i0 PRJNA407368 1801 464 9.774713 45.35466832 Mycoplasmopsis arginini 2094 Bacteria Bacteria 177 1.02e-53   NR WP_282460229.1 2094 g1704 i0 98.8 0.543103448275862 84 1 54.3 0 254 3 1 84 WP_282460229.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 252 177 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27075441 27075441 PRJNA407368_S_NODE_1602_length_497_cov_5.335470_g1508_i0 PRJNA407368 1602 497 5.33547 26.5172859 Mycoplasmopsis arginini 2094 Bacteria Bacteria 205 2.36e-65   NR WP_282460054.1 2094 g1508 i0 100 0.603621730382294 100 0 60.4 0 80 379 20 119 WP_282460054.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 300 205 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27423353 27423353 PRJNA407368_S_NODE_6783_length_203_cov_2.224138_g6681_i0 PRJNA407368 6783 203 2.224138 4.51500014 Mycoplasmopsis arginini 2094 Bacteria Bacteria 75.5 1.66e-15   NR WP_282457347.1 2094 g6681 i0 100 0.458128078817734 31 0 45.8 0 203 111 99 129 WP_282457347.1 hypothetical protein [Mycoplasmopsis arginini] diamond 93 75.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27423354 27423354 PRJNA407368_S_NODE_7003_length_198_cov_3.349112_g6901_i0 PRJNA407368 7003 198 3.349112 6.63124176 Mycoplasmopsis arginini 2094 Bacteria Bacteria 43.1 0.00879   NR WP_282459051.1 2094 g6901 i0 100 0.666666666666667 22 0 33.3 0 2 67 136 157 WP_282459051.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 132 43.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27724338 27724338 PRJNA407368_S_NODE_4844_length_254_cov_6.866667_g4742_i0 PRJNA407368 4844 254 6.866667 17.44133418 Bacteria 2 Bacteria Bacteria 127 1.69e-33   NR HHX17214.1 37628 g4742 i0 98.4 2.19685039370079 62 1 73.2 0 3 188 101 162 HHX17214.1 site-specific DNA-methyltransferase [Mollicutes bacterium] diamond 558 127 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
28370265 28370265 PRJNA407368_S_NODE_2306_length_404_cov_5.482667_g2205_i0 PRJNA407368 2306 404 5.482667 22.14997468 Mycoplasmopsis arginini 2094 Bacteria Bacteria 117 3.0899999999999993e-31   NR WP_282460154.1 2094 g2205 i0 100 0.423267326732673 57 0 42.3 0 232 402 1 57 WP_282460154.1 hypothetical protein [Mycoplasmopsis arginini] diamond 171 117 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28938762 28938762 PRJNA407368_S_NODE_7808_length_184_cov_3.251613_g7706_i0 PRJNA407368 7808 184 3.251613 5.98296792 Mycoplasmopsis arginini 2094 Bacteria Bacteria 115 4.589999999999999e-31   NR WP_282460019.1 2094 g7706 i0 100 0.978260869565217 60 0 97.8 0 182 3 51 110 WP_282460019.1 antA/AntB antirepressor family protein, partial [Mycoplasmopsis arginini] diamond 180 115 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29822500 29822500 PRJNA407368_S_NODE_4351_length_274_cov_4.400000_g4249_i0 PRJNA407368 4351 274 4.4 12.056 Mycoplasmopsis arginini 2094 Bacteria Bacteria 178 6.959999999999998e-55   NR WP_282460164.1 2094 g4249 i0 95.5 0.963503649635037 88 4 96.4 0 265 2 59 146 WP_282460164.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 264 178 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30233423 30233423 PRJNA407368_S_NODE_5272_length_239_cov_6.019048_g5170_i0 PRJNA407368 5272 239 6.019048 14.38552472 Mycoplasmopsis arginini 2094 Bacteria Bacteria 123 9.049999999999999e-35   NR WP_282460091.1 2094 g5170 i0 100 0.753138075313807 60 0 75.3 0 7 186 30 89 WP_282460091.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 180 123 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30928632 30928632 PRJNA407368_S_NODE_9014_length_168_cov_2.568345_g8912_i0 PRJNA407368 9014 168 2.568345 4.3148196 Mycoplasmopsis arginini 2094 Bacteria Bacteria 43.9 0.00169   NR WP_282460095.1 2094 g8912 i0 50 0.821428571428571 46 20 82.1 1 26 163 50 92 WP_282460095.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 138 43.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31086529 31086529 PRJNA407368_S_NODE_5995_length_220_cov_2.172775_g5893_i0 PRJNA407368 5995 220 2.172775 4.780105 Mycoplasmopsis arginini 2094 Bacteria Bacteria 135 4.68e-39   NR WP_282460087.1 2094 g5893 i0 95.8 0.981818181818182 72 3 98.2 0 216 1 1 72 WP_282460087.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 216 135 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31339338 31339338 PRJNA407368_S_NODE_1856_length_456_cov_3.763466_g1758_i0 PRJNA407368 1856 456 3.763466 17.16140496 Mycoplasmopsis arginini 2094 Bacteria Bacteria 220 1.37e-71   NR WP_282460006.1 2094 g1758 i0 99.1 0.697368421052632 106 1 69.7 0 21 338 1 106 WP_282460006.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 318 220 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32604667 32604667 PRJNA407368_S_NODE_7320_length_193_cov_2.603659_g7218_i0 PRJNA407368 7320 193 2.603659 5.02506187 Mycoplasmopsis arginini 2094 Bacteria Bacteria 77.4 4.28e-16   NR WP_282460074.1 2094 g7218 i0 100 0.559585492227979 36 0 56 0 2 109 115 150 WP_282460074.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 108 77.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32667543 32667543 PRJNA407368_S_NODE_7020_length_198_cov_1.964497_g6918_i0 PRJNA407368 7020 198 1.964497 3.88970406 Mycoplasmopsis arginini 2094 Bacteria Bacteria 138 4.76e-40   NR WP_282460155.1 2094 g6918 i0 97 1 66 2 100 0 1 198 33 98 WP_282460155.1 glycoside hydrolase family 19 protein, partial [Mycoplasmopsis arginini] diamond 198 138 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini

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