RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJNA404067", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 32 ✖

tax_kingdom 1

  • Bacillati · 32 ✖

bioproject 1

  • PRJNA404067 · 32 ✖

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
16991911 16991911 PRJNA404067_P_NODE_12234_length_301_cov_3.695833_g11848_i0 PRJNA404067 12234 301 3.695833 11.12445733 Mycoplasmopsis arginini 2094 Bacteria Bacteria 549 8.149999999999997e-152   NTclustered gi|2668342370|gb|CP143577.1| 2094 g11848 i0 100 30.5647840531561 297 0 99 0 1 297 147193 146897 Mycoplasmopsis arginini strain NCTC 10129 chromosome, complete genome blastn 9200 549 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
26758789 26758789 PRJNA404067_P_NODE_10021_length_347_cov_1.164336_g9636_i0 PRJNA404067 10021 347 1.164336 4.04024592 Mycoplasmopsis arginini 2094 Bacteria Bacteria 67.4 1.41e-11   NR WP_282457347.1 2094 g9636 i0 45 0.69164265129683 80 44 69.2 0 2 241 50 129 WP_282457347.1 hypothetical protein [Mycoplasmopsis arginini] diamond 240 67.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
26758794 26758794 PRJNA404067_P_NODE_14641_length_271_cov_1.828571_g14254_i0 PRJNA404067 14641 271 1.828571 4.95542741 Mycoplasmopsis arginini 2094 Bacteria Bacteria 140 2.18e-40   NR WP_282460195.1 2094 g14254 i0 97.4 0.841328413284133 76 2 84.1 0 270 43 83 158 WP_282460195.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 228 140 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
26885803 26885803 PRJNA404067_P_NODE_5741_length_549_cov_3.204918_g5373_i0 PRJNA404067 5741 549 3.204918 17.59499982 Mycoplasmopsis arginini 2094 Bacteria Bacteria 147 1.62e-42   NR WP_282460041.1 2094 g5373 i0 100 0.415300546448087 76 0 41.5 0 468 241 1 76 WP_282460041.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 228 147 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27075413 27075413 PRJNA404067_P_NODE_21082_length_233_cov_2.744186_g20695_i0 PRJNA404067 21082 233 2.744186 6.39395338 Mycoplasmopsis arginini 2094 Bacteria Bacteria 80.5 3.44e-17   NR WP_282460071.1 2094 g20695 i0 100 0.502145922746781 39 0 50.2 0 118 2 1 39 WP_282460071.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 117 80.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27360047 27360047 PRJNA404067_P_NODE_3483_length_964_cov_3.521595_g3188_i0 PRJNA404067 3483 964 3.521595 33.9481758 Mycoplasmopsis arginini 2094 Bacteria Bacteria 212 1.35e-65   NR WP_282460154.1 2094 g3188 i0 98.1 0.336099585062241 108 2 33.6 0 400 723 1 108 WP_282460154.1 hypothetical protein [Mycoplasmopsis arginini] diamond 324 212 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27675918 27675918 PRJNA404067_P_NODE_10284_length_340_cov_1.896057_g9899_i0 PRJNA404067 10284 340 1.896057 6.4465938 Mycoplasmopsis arginini 2094 Bacteria Bacteria 113 2.19e-30   NR WP_282460244.1 2094 g9899 i0 95.2 0.555882352941176 63 3 55.6 0 189 1 1 63 WP_282460244.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 189 113 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27959788 27959788 PRJNA404067_P_NODE_21785_length_231_cov_3.617647_g21398_i0 PRJNA404067 21785 231 3.617647 8.35676457 Mycoplasmopsis arginini 2094 Bacteria Bacteria 84.7 1e-19   NR WP_282460221.1 2094 g21398 i0 100 0.545454545454545 42 0 54.5 0 127 2 3 44 WP_282460221.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 126 84.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28212186 28212186 PRJNA404067_P_NODE_40446_length_195_cov_2.313433_g40059_i0 PRJNA404067 40446 195 2.313433 4.51119435 Mycoplasmopsis arginini 2094 Bacteria Bacteria 132 1.18e-37   NR WP_282460155.1 2094 g40059 i0 93.8 0.984615384615385 64 4 98.5 0 3 194 85 148 WP_282460155.1 glycoside hydrolase family 19 protein, partial [Mycoplasmopsis arginini] diamond 192 132 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28212190 28212190 PRJNA404067_P_NODE_7546_length_424_cov_2.201102_g7168_i0 PRJNA404067 7546 424 2.201102 9.33267248 Mycoplasmopsis arginini 2094 Bacteria Bacteria 176 2.7e-54   NR WP_282460187.1 2094 g7168 i0 82.2 0.714622641509434 101 18 71.5 0 407 105 1 101 WP_282460187.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 303 176 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28338771 28338771 PRJNA404067_P_NODE_40606_length_194_cov_3.571429_g40219_i0 PRJNA404067 40606 194 3.571429 6.92857226 Mycoplasmopsis arginini 2094 Bacteria Bacteria 91.3 8.79e-22   NR MDI3348896.1 2094 g40219 i0 97.6 0.649484536082474 42 1 64.9 0 194 69 87 128 MDI3348896.1 hypothetical protein [Mycoplasmopsis arginini] diamond 126 91.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28401858 28401858 PRJNA404067_P_NODE_15866_length_260_cov_3.150754_g15479_i0 PRJNA404067 15866 260 3.150754 8.1919604 Mycoplasmopsis arginini 2094 Bacteria Bacteria 171 5.47e-53   NR WP_282460087.1 2094 g15479 i0 98.8 0.992307692307692 86 1 99.2 0 260 3 21 106 WP_282460087.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 258 171 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29096619 29096619 PRJNA404067_P_NODE_35348_length_204_cov_1.216783_g34961_i0 PRJNA404067 35348 204 1.216783 2.48223732 Mycoplasmopsis arginini 2094 Bacteria Bacteria 134 3.52e-38   NR WP_282460016.1 2094 g34961 i0 98.5 0.985294117647059 67 1 98.5 0 2 202 99 165 WP_282460016.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 201 134 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29128311 29128311 PRJNA404067_P_NODE_13929_length_279_cov_2.770642_g13542_i0 PRJNA404067 13929 279 2.770642 7.73009118 Mycoplasmopsis arginini 2094 Bacteria Bacteria 150 9.14e-44   NR WP_282460185.1 2094 g13542 i0 98.5 0.731182795698925 68 1 73.1 0 34 237 143 210 WP_282460185.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 204 150 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29159835 29159835 PRJNA404067_P_NODE_18489_length_242_cov_5.005525_g18102_i0 PRJNA404067 18489 242 5.005525 12.1133705 Mycoplasmopsis arginini 2094 Bacteria Bacteria 124 4.069999999999999e-35   NR WP_282460239.1 2094 g18102 i0 96.7 0.743801652892562 60 2 74.4 0 63 242 1 60 WP_282460239.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 180 124 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29412144 29412144 PRJNA404067_P_NODE_12869_length_292_cov_2.662338_g12482_i0 PRJNA404067 12869 292 2.662338 7.77402696 Mycoplasmopsis arginini 2094 Bacteria Bacteria 153 2.84e-45   NR WP_282460019.1 2094 g12482 i0 100 0.770547945205479 75 0 77.1 0 68 292 1 75 WP_282460019.1 antA/AntB antirepressor family protein, partial [Mycoplasmopsis arginini] diamond 225 153 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29917615 29917615 PRJNA404067_P_NODE_44871_length_168_cov_7.046729_g44484_i0 PRJNA404067 44871 168 7.046729 11.83850472 Mycoplasmopsis arginini 2094 Bacteria Bacteria 43.1 0.00175   NR WP_282460083.1 2094 g44484 i0 87 0.410714285714286 23 3 41.1 0 5 73 8 30 WP_282460083.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 69 43.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29949128 29949128 PRJNA404067_P_NODE_38251_length_201_cov_1.621429_g37864_i0 PRJNA404067 38251 201 1.621429 3.25907229 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 132 3.92e-36   NR MFO7969629.1 3018265 g37864 i0 93.9 0.985074626865672 66 4 98.5 0 199 2 148 213 MFO7969629.1 site-specific DNA-methyltransferase [Candidatus Izemoplasmatales bacterium] diamond 198 132 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
29980687 29980687 PRJNA404067_P_NODE_15051_length_267_cov_2.883495_g14664_i0 PRJNA404067 15051 267 2.883495 7.69893165 Mycoplasmopsis arginini 2094 Bacteria Bacteria 58.5 7.61e-9   NR WP_369124529.1 2094 g14664 i0 96.8 0.348314606741573 31 1 34.8 0 265 173 67 97 WP_369124529.1 helix-turn-helix domain-containing protein [Mycoplasmopsis arginini] diamond 93 58.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30138239 30138239 PRJNA404067_P_NODE_15312_length_265_cov_0.916667_g14925_i0 PRJNA404067 15312 265 0.916667 2.42916755 Mycoplasmopsis arginini 2094 Bacteria Bacteria 114 6.61e-30   NR WP_282460164.1 2094 g14925 i0 96.5 0.645283018867924 57 2 64.5 0 94 264 49 105 WP_282460164.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 171 114 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30170071 30170071 PRJNA404067_P_NODE_23972_length_225_cov_4.341463_g23585_i0 PRJNA404067 23972 225 4.341463 9.76829175 Mycoplasmopsis arginini 2094 Bacteria Bacteria 56.2 7.34e-8   NR WP_282457347.1 2094 g23585 i0 93.3 0.4 30 2 40 0 134 223 4 33 WP_282457347.1 hypothetical protein [Mycoplasmopsis arginini] diamond 90 56.2 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30612413 30612413 PRJNA404067_P_NODE_32573_length_207_cov_1.712329_g32186_i0 PRJNA404067 32573 207 1.712329 3.54452103 Mycoplasmopsis arginini 2094 Bacteria Bacteria 135 6.65e-39   NR WP_282460071.1 2094 g32186 i0 98.5 0.985507246376812 68 1 98.6 0 2 205 22 89 WP_282460071.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 204 135 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30707274 30707274 PRJNA404067_P_NODE_45074_length_167_cov_5.632075_g44687_i0 PRJNA404067 45074 167 5.632075 9.40556525 Mycoplasmopsis arginini 2094 Bacteria Bacteria 112 2.08e-30   NR WP_282460087.1 2094 g44687 i0 100 0.988023952095808 55 0 98.8 0 165 1 60 114 WP_282460087.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 165 112 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30738872 30738872 PRJNA404067_P_NODE_6614_length_476_cov_3.648193_g6237_i0 PRJNA404067 6614 476 3.648193 17.36539868 Mycoplasmopsis arginini 2094 Bacteria Bacteria 204 5.15e-65   NR WP_282460054.1 2094 g6237 i0 99 0.630252100840336 100 1 63 0 20 319 20 119 WP_282460054.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 300 204 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31149251 31149251 PRJNA404067_P_NODE_31315_length_209_cov_0.864865_g30928_i0 PRJNA404067 31315 209 0.864865 1.80756785 Mycoplasmopsis arginini 2094 Bacteria Bacteria 129 3.3e-36   NR WP_282460019.1 2094 g30928 i0 97.1 0.990430622009569 69 2 99 0 207 1 74 142 WP_282460019.1 antA/AntB antirepressor family protein, partial [Mycoplasmopsis arginini] diamond 207 129 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31180940 31180940 PRJNA404067_P_NODE_27935_length_216_cov_1.129032_g27548_i0 PRJNA404067 27935 216 1.129032 2.43870912 Mycoplasmopsis arginini 2094 Bacteria Bacteria 45.4 0.00199   NR MDI3351016.1 2094 g27548 i0 66.7 0.416666666666667 30 10 41.7 0 178 89 6 35 MDI3351016.1 hypothetical protein [Mycoplasmopsis arginini] diamond 90 45.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31466103 31466103 PRJNA404067_P_NODE_27636_length_216_cov_3.858065_g27249_i0 PRJNA404067 27636 216 3.858065 8.3334204 Mycoplasmopsis hyopharyngis 29558 Bacteria Bacteria 53.9 3.02e-6   NR WP_406616046.1 29558 g27249 i0 42.2 0.888888888888889 64 37 88.9 0 216 25 229 292 WP_406616046.1 replicative DNA helicase [Mycoplasmopsis hyopharyngis] diamond 192 53.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis hyopharyngis
32066848 32066848 PRJNA404067_P_NODE_25578_length_221_cov_2.212500_g25191_i0 PRJNA404067 25578 221 2.2125 4.889625 Mycoplasmopsis arginini 2094 Bacteria Bacteria 150 1.96e-44   NR WP_282460248.1 2094 g25191 i0 98.6 0.990950226244344 73 1 99.1 0 219 1 27 99 WP_282460248.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 219 150 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32130422 32130422 PRJNA404067_P_NODE_43938_length_174_cov_4.752212_g43551_i0 PRJNA404067 43938 174 4.752212 8.26884888 Mycoplasmopsis arginini 2094 Bacteria Bacteria 89.7 1.14e-21   NR WP_369124529.1 2094 g43551 i0 84.6 0.896551724137931 52 8 89.7 0 17 172 1 52 WP_369124529.1 helix-turn-helix domain-containing protein [Mycoplasmopsis arginini] diamond 156 89.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32351944 32351944 PRJNA404067_P_NODE_24279_length_225_cov_0.865854_g23892_i0 PRJNA404067 24279 225 0.865854 1.9481715 Mycoplasmopsis arginini 2094 Bacteria Bacteria 56.6 2.51e-8   NR WP_282460222.1 2094 g23892 i0 96.3 0.36 27 1 36 0 81 1 14 40 WP_282460222.1 hypothetical protein [Mycoplasmopsis arginini] diamond 81 56.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32446851 32446851 PRJNA404067_P_NODE_10279_length_340_cov_2.107527_g9894_i0 PRJNA404067 10279 340 2.107527 7.1655918 Mycoplasmopsis arginini 2094 Bacteria Bacteria 204 1.09e-65   NR WP_282460095.1 2094 g9894 i0 96.4 0.979411764705882 111 4 97.9 0 335 3 1 111 WP_282460095.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 333 204 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32635912 32635912 PRJNA404067_P_NODE_19520_length_238_cov_3.242938_g19133_i0 PRJNA404067 19520 238 3.242938 7.71819244 Mycoplasmopsis arginini 2094 Bacteria Bacteria 165 2.14e-50   NR WP_282460037.1 2094 g19133 i0 100 0.983193277310924 78 0 98.3 0 236 3 22 99 WP_282460037.1 glycosyltransferase family A protein, partial [Mycoplasmopsis arginini] diamond 234 165 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);;