RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "blastn", tax_phylum = "Caldisericota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 23 ✖

tax_phylum 1

  • Caldisericota · 23 ✖

tax_kingdom 1

analysis 1

  • blastn · 23 ✖
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
291462 291462 PRJNA1148190_P_NODE_16181_length_2203_cov_231.175587_g244_i88 PRJNA1148190 16181 2203 231.175587 5092.79818161 Caldisericum exile 693075 Bacteria Bacteria 87.9 6.25e-12   NTclustered gi|381363297|dbj|AP012051.1| 511051 g244 i88 94.737 0.422151611438947 57 1 3 2 1353 1408 698007 697952 Caldisericum exile AZM16c01 DNA, complete genome blastn 930 87.9 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
1573212 1573212 PRJNA1148190_P_NODE_6622_length_4541_cov_201.128693_g244_i64 PRJNA1148190 6622 4541 201.128693 9133.25394913 Caldisericum exile 693075 Bacteria Bacteria 87.9 1.3e-11   NTclustered gi|381363297|dbj|AP012051.1| 511051 g244 i64 94.737 0.204800704690597 57 1 1 2 3691 3746 698007 697952 Caldisericum exile AZM16c01 DNA, complete genome blastn 930 87.9 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
1680857 1680857 PRJNA385073_P_NODE_38082_length_258_cov_1.664865_g37920_i0 PRJNA385073 38082 258 1.664865 4.2953517 Caldisericia bacterium 2758719 Bacteria Bacteria 76.8 1.39e-9   NTclustered gi|2621713026|emb|OY771555.1| 2758719 g37920 i0 92.453 0.662790697674419 53 4 21 0 35 87 2148651 2148703 MAG: Caldisericia bacterium isolate 048577e4-24bb-4769-bfae-6f43d69425f4 genome assembly, chromosome: 1 blastn 171 76.8 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia       Caldisericia bacterium
1737591 1737591 PRJNA493632_P_NODE_370342_length_278_cov_2.736585_g366903_i0 PRJNA493632 370342 278 2.736585 7.6077063 Caldisericum exile 693075 Bacteria Bacteria 52.8 0.026   NTclustered gi|381363297|dbj|AP012051.1| 511051 g366903 i0 100 0.100719424460432 28 0 10 0 208 235 1536376 1536349 Caldisericum exile AZM16c01 DNA, complete genome blastn 28 52.8 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
3681774 3681774 PRJNA560029_S_NODE_9803_length_368_cov_19.579661_g9579_i0 PRJNA560029 9803 368 19.579661 72.05315248 Caldisericota/Cryosericota group 2498710 Bacteria Bacteria 62.1 5.81e-5   NTclustered gi|2621713026|emb|OY771555.1| 2758719 g9579 i0 100 0.285326086956522 33 0 9 0 48 80 657069 657101 MAG: Caldisericia bacterium isolate 048577e4-24bb-4769-bfae-6f43d69425f4 genome assembly, chromosome: 1 blastn 105 62.1 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia       Caldisericia bacterium
4460784 4460784 PRJNA666695_S_NODE_61344_length_271_cov_1.800000_g60250_i0 PRJNA666695 61344 271 1.8 4.878 Caldisericum exile 693075 Bacteria Bacteria 52.8 0.025   NTclustered gi|381363297|dbj|AP012051.1| 511051 g60250 i0 100 0.103321033210332 28 0 10 0 3 30 1229896 1229869 Caldisericum exile AZM16c01 DNA, complete genome blastn 28 52.8 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
9228225 9228225 PRJNA1148190_P_NODE_7908_length_3949_cov_206.659443_g244_i71 PRJNA1148190 7908 3949 206.659443 8160.98140407 Caldisericum exile 693075 Bacteria Bacteria 87.9 1.13e-11   NTclustered gi|381363297|dbj|AP012051.1| 511051 g244 i71 94.737 0.279564446695366 57 1 1 2 3099 3154 698007 697952 Caldisericum exile AZM16c01 DNA, complete genome blastn 1104 87.9 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
9292762 9292762 PRJNA168635_P_NODE_4088_length_414_cov_2.863014_g3687_i0 PRJNA168635 4088 414 2.863014 11.85287796 Caldisericia bacterium 2758719 Bacteria Bacteria 137 1.07e-27   NTclustered gi|2621713026|emb|OY771555.1| 2758719 g3687 i0 74.005 42.8599033816425 377 80 89 15 45 413 887730 888096 MAG: Caldisericia bacterium isolate 048577e4-24bb-4769-bfae-6f43d69425f4 genome assembly, chromosome: 1 blastn 17744 137 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia       Caldisericia bacterium
11354797 11354797 PRJNA630162_P_NODE_30009_length_330_cov_2.825623_g28487_i0 PRJNA630162 30009 330 2.825623 9.3245559 Bacteria 2 Bacteria Bacteria 588 1.9099999999999998e-163   NTclustered gi|2967769|gb|AF050593.1| 74241 g28487 i0 99.383 78.7787878787879 324 2 98 0 7 330 1094 1417 Uncultured eubacterium WCHB1-02 16S ribosomal RNA gene, partial sequence blastn 25997 588 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota         uncultured eubacterium WCHB1-02
11769281 11769281 PRJNA1148190_P_NODE_11590_length_2906_cov_230.849629_g244_i83 PRJNA1148190 11590 2906 230.849629 6708.49021874 Caldisericum exile 693075 Bacteria Bacteria 87.9 8.28e-12   NTclustered gi|381363297|dbj|AP012051.1| 511051 g244 i83 94.737 0.320027529249828 57 1 2 2 2056 2111 698007 697952 Caldisericum exile AZM16c01 DNA, complete genome blastn 930 87.9 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
12607048 12607048 PRJNA556992_P_NODE_958170_length_235_cov_2.253086_g955980_i0 PRJNA556992 958170 235 2.253086 5.2947521 Caldisericum 693074 Bacteria Bacteria 206 1.53e-48   NTclustered gi|381363297|dbj|AP012051.1| 511051 g955980 i0 90 169.774468085106 160 15 68 1 26 185 544430 544588 Caldisericum exile AZM16c01 DNA, complete genome blastn 39897 206 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
12880961 12880961 PRJEB64798_P_NODE_164371_length_181_cov_5.159091_g162605_i0 PRJEB64798 164371 181 5.159091 9.33795471 Caldisericia bacterium 2758719 Bacteria Bacteria 145 2.4699999999999997e-30   NTclustered gi|2621713026|emb|OY771555.1| 2758719 g162605 i0 86.131 186.574585635359 137 15 75 4 43 178 888180 888047 MAG: Caldisericia bacterium isolate 048577e4-24bb-4769-bfae-6f43d69425f4 genome assembly, chromosome: 1 blastn 33770 145 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia       Caldisericia bacterium
13054308 13054308 PRJNA1148190_P_NODE_9031_length_3555_cov_211.746123_g244_i75 PRJNA1148190 9031 3555 211.746123 7527.57467265 Caldisericum exile 693075 Bacteria Bacteria 87.9 1.01e-11   NTclustered gi|381363297|dbj|AP012051.1| 511051 g244 i75 94.737 0.261603375527426 57 1 2 2 2705 2760 698007 697952 Caldisericum exile AZM16c01 DNA, complete genome blastn 930 87.9 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
14485176 14485176 PRJNA493244_P_NODE_1733892_length_196_cov_2.474074_g1710767_i0 PRJNA493244 1733892 196 2.474074 4.84918504 Caldisericia bacterium 2758719 Bacteria Bacteria 137 4.55e-28   NTclustered gi|2621713026|emb|OY771555.1| 2758719 g1710767 i0 86.4 843.535714285714 125 17 64 0 62 186 889824 889700 MAG: Caldisericia bacterium isolate 048577e4-24bb-4769-bfae-6f43d69425f4 genome assembly, chromosome: 1 blastn 165333 137 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia       Caldisericia bacterium
16867599 16867599 PRJNA1148190_P_NODE_10974_length_3035_cov_216.567184_g244_i78 PRJNA1148190 10974 3035 216.567184 6572.8140344 Caldisericum exile 693075 Bacteria Bacteria 87.9 8.65e-12   NTclustered gi|381363297|dbj|AP012051.1| 511051 g244 i78 94.737 0.306425041186161 57 1 2 2 2185 2240 698007 697952 Caldisericum exile AZM16c01 DNA, complete genome blastn 930 87.9 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
16869546 16869546 PRJNA1148190_P_NODE_222234_length_360_cov_1.341463_g211064_i0 PRJNA1148190 222234 360 1.341463 4.8292668 Caldisericum exile 693075 Bacteria Bacteria 84.2 1.21e-11   NTclustered gi|381363297|dbj|AP012051.1| 511051 g211064 i0 88.406 3.95277777777778 69 8 19 0 241 309 698189 698257 Caldisericum exile AZM16c01 DNA, complete genome blastn 1423 84.2 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
20074921 20074921 PRJNA976345_P_NODE_27416_length_322_cov_2.048780_g25812_i0 PRJNA976345 27416 322 2.04878 6.5970716 Caldisericia bacterium 2758719 Bacteria Bacteria 52.8 0.03   NTclustered gi|2621713026|emb|OY771555.1| 2758719 g25812 i0 100 0.0869565217391304 28 0 9 0 221 248 1440568 1440541 MAG: Caldisericia bacterium isolate 048577e4-24bb-4769-bfae-6f43d69425f4 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia       Caldisericia bacterium
21078518 21078518 PRJNA695140_S_NODE_3597_length_275_cov_5.168067_g3416_i0 PRJNA695140 3597 275 5.168067 14.21218425 Caldisericia bacterium 2758719 Bacteria Bacteria 62.1 4.2e-5   NTclustered gi|2621713026|emb|OY771555.1| 2758719 g3416 i0 100 0.12 33 0 12 0 226 258 657101 657069 MAG: Caldisericia bacterium isolate 048577e4-24bb-4769-bfae-6f43d69425f4 genome assembly, chromosome: 1 blastn 33 62.1 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia       Caldisericia bacterium
21676086 21676086 PRJNA994919_S_NODE_4697_length_266_cov_4.516908_g4600_i0 PRJNA994919 4697 266 4.516908 12.01497528 Caldisericum 693074 Bacteria Bacteria 106 1.84e-18   NTclustered gi|381363297|dbj|AP012051.1| 511051 g4600 i0 92.105 30.8421052631579 76 5 28 1 167 241 543359 543284 Caldisericum exile AZM16c01 DNA, complete genome blastn 8204 106 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
21967501 21967501 PRJNA1148190_P_NODE_11838_length_2854_cov_215.361021_g244_i84 PRJNA1148190 11838 2854 215.361021 6146.40353934 Caldisericum exile 693075 Bacteria Bacteria 87.9 8.13e-12   NTclustered gi|381363297|dbj|AP012051.1| 511051 g244 i84 94.737 0.325858444288718 57 1 2 2 2004 2059 698007 697952 Caldisericum exile AZM16c01 DNA, complete genome blastn 930 87.9 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
23435924 23435924 PRJNA505329_P_NODE_39759_length_172_cov_2.463415_g39288_i0 PRJNA505329 39759 172 2.463415 4.2370738 Caldisericia bacterium 2758719 Bacteria Bacteria 143 8.32e-30   NTclustered gi|2621713026|emb|OY771555.1| 2758719 g39288 i0 86.26 800.331395348837 131 18 76 0 13 143 889694 889824 MAG: Caldisericia bacterium isolate 048577e4-24bb-4769-bfae-6f43d69425f4 genome assembly, chromosome: 1 blastn 137657 143 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia       Caldisericia bacterium
23976553 23976553 PRJNA1115053_S_NODE_165559_length_210_cov_2.353293_g163742_i0 PRJNA1115053 165559 210 2.353293 4.9419153 Caldisericum 693074 Bacteria Bacteria 97.1 8.39e-16   NTclustered gi|381363297|dbj|AP012051.1| 511051 g163742 i0 95.082 28.3666666666667 61 3 29 0 1 61 543298 543358 Caldisericum exile AZM16c01 DNA, complete genome blastn 5957 97.1 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia Caldisericales Caldisericaceae Caldisericum Caldisericum exile
24657315 24657315 PRJNA436017_P_NODE_6880_length_340_cov_1.495050_g6583_i0 PRJNA436017 6880 340 1.49505 5.08317 Caldisericia bacterium 2758719 Bacteria Bacteria 58.4 6.9e-4   NTclustered gi|2621713026|emb|OY771555.1| 2758719 g6583 i0 100 0.0911764705882353 31 0 9 0 1 31 657071 657101 MAG: Caldisericia bacterium isolate 048577e4-24bb-4769-bfae-6f43d69425f4 genome assembly, chromosome: 1 blastn 31 58.4 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia       Caldisericia 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);;