RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn" and tax_phylum = "Calditrichota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Calditrichota · 16 ✖

tax_kingdom 1

analysis 1

  • blastn · 16 ✖

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
1429590 1429590 PRJNA1009807_S_NODE_3202_length_180_cov_4.510638_g3174_i0 PRJNA1009807 3202 180 4.510638 8.1191484 Caldithrix abyssi 187145 Bacteria Bacteria 158 3.1499999999999993e-34   NTclustered gi|1108618394|gb|CP018099.1| 880073 g3174 i0 86 1.75555555555556 150 18 82 3 31 178 1053614 1053466 Caldithrix abyssi DSM 13497, complete genome blastn 316 158 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
2066175 2066175 PRJNA798511_P_NODE_36562_length_453_cov_2.413158_g32303_i0 PRJNA798511 36562 453 2.413158 10.93160574 Caldithrix abyssi 187145 Bacteria Bacteria 54.7 0.012   NTclustered gi|1108618394|gb|CP018099.1| 880073 g32303 i0 96.97 0.0728476821192053 33 0 7 1 8 39 1875997 1875965 Caldithrix abyssi DSM 13497, complete genome blastn 33 54.7 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
2098509 2098509 PRJNA832865_S_NODE_36342_length_453_cov_2.423684_g31258_i0 PRJNA832865 36342 453 2.423684 10.97928852 Caldithrix abyssi 187145 Bacteria Bacteria 54.7 0.012   NTclustered gi|1108618394|gb|CP018099.1| 880073 g31258 i0 96.97 0.0728476821192053 33 0 7 1 8 39 1875997 1875965 Caldithrix abyssi DSM 13497, complete genome blastn 33 54.7 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
2249378 2249378 PRJNA986547_P_NODE_14642_length_223_cov_4.440000_g14560_i0 PRJNA986547 14642 223 4.44 9.9012 Caldithrix abyssi 187145 Bacteria Bacteria 67.6 7.07e-7   NTclustered gi|1108618394|gb|CP018099.1| 880073 g14560 i0 97.436 6.90134529147982 39 1 17 0 51 89 4410689 4410727 Caldithrix abyssi DSM 13497, complete genome blastn 1539 67.6 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
3152284 3152284 PRJNA630162_P_NODE_103603_length_183_cov_2.477612_g102080_i0 PRJNA630162 103603 183 2.477612 4.53402996 Caldithrix abyssi 187145 Bacteria Bacteria 113 7.050000000000001e-21   NTclustered gi|1108618394|gb|CP018099.1| 880073 g102080 i0 93.421 207.704918032787 76 5 42 0 108 183 1053782 1053857 Caldithrix abyssi DSM 13497, complete genome blastn 38010 113 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
8364609 8364609 PRJNA724039_S_NODE_9707_length_209_cov_2.529070_g9500_i0 PRJNA724039 9707 209 2.52907 5.2857563 Caldithrix abyssi 187145 Bacteria Bacteria 148 2.27e-31   NTclustered gi|1108618394|gb|CP018099.1| 880073 g9500 i0 88.189 1.39712918660287 127 12 60 3 1 125 1053453 1053578 Caldithrix abyssi DSM 13497, complete genome blastn 292 148 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
9055334 9055334 PRJEB64798_P_NODE_215448_length_163_cov_4.061404_g213682_i0 PRJEB64798 215448 163 4.061404 6.62008852 Caldithrix abyssi 187145 Bacteria Bacteria 104 3.7e-18   NTclustered gi|1108618394|gb|CP018099.1| 880073 g213682 i0 83.929 0.687116564417178 112 15 68 3 3 113 1054554 1054445 Caldithrix abyssi DSM 13497, complete genome blastn 112 104 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
9377611 9377611 PRJNA488043_P_NODE_12468_length_273_cov_1.545082_g10227_i0 PRJNA488043 12468 273 1.545082 4.21807386 Caldithrix abyssi 187145 Bacteria Bacteria 183 8.519999999999997e-42   NTclustered gi|1108618394|gb|CP018099.1| 880073 g10227 i0 83.173 1.52747252747253 208 27 75 7 63 266 1053357 1053560 Caldithrix abyssi DSM 13497, complete genome blastn 417 183 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
10819955 10819955 PRJNA641707_P_NODE_313769_length_160_cov_4.783784_g311106_i0 PRJNA641707 313769 160 4.783784 7.6540544 Caldithrix abyssi 187145 Bacteria Bacteria 132 1.6600000000000002e-26   NTclustered gi|1108618394|gb|CP018099.1| 880073 g311106 i0 88.288 274.075 111 12 69 1 11 120 1053468 1053578 Caldithrix abyssi DSM 13497, complete genome blastn 43852 132 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
12146290 12146290 PRJNA688352_P_NODE_7270_length_251_cov_0.865169_g7167_i0 PRJNA688352 7270 251 0.865169 2.17157419 Caldithrix abyssi 187145 Bacteria Bacteria 69.4 2.26e-7   NTclustered gi|1108618394|gb|CP018099.1| 880073 g7167 i0 91.837 0.617529880478088 49 4 20 0 203 251 4552280 4552328 Caldithrix abyssi DSM 13497, complete genome blastn 155 69.4 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
12402108 12402108 PRJNA942359_P_NODE_18070_length_245_cov_0.906977_g17955_i0 PRJNA942359 18070 245 0.906977 2.22209365 Caldithrix abyssi 187145 Bacteria Bacteria 252 2.0299999999999998e-62   NTclustered gi|1108618394|gb|CP018099.1| 880073 g17955 i0 85.141 129.640816326531 249 33 100 4 1 245 1053825 1053577 Caldithrix abyssi DSM 13497, complete genome blastn 31762 252 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
15062669 15062669 PRJNA1148190_P_NODE_349212_length_301_cov_1.013158_g338039_i0 PRJNA1148190 349212 301 1.013158 3.04960558 Pseudomonadati 3379134 Bacteria Bacteria 62.1 4.65e-5   NTclustered gi|1108618394|gb|CP018099.1| 880073 g338039 i0 93.023 3.0797342192691 43 1 14 2 53 95 2515064 2515104 Caldithrix abyssi DSM 13497, complete genome blastn 927 62.1 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
17278017 17278017 PRJNA704949_P_NODE_694434_length_323_cov_2.204380_g679106_i0 PRJNA704949 694434 323 2.20438 7.1201474 Caldithrix abyssi 187145 Bacteria Bacteria 117 1.06e-21   NTclustered gi|1108618394|gb|CP018099.1| 880073 g679106 i0 80.24 20.2631578947368 167 23 51 4 133 298 4552523 4552366 Caldithrix abyssi DSM 13497, complete genome blastn 6545 117 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
17866787 17866787 PRJEB11748_P_NODE_157835_length_326_cov_1.924528_g155653_i0 PRJEB11748 157835 326 1.924528 6.27396128 Caldithrix abyssi 187145 Bacteria Bacteria 73.1 2.35e-8   NTclustered gi|1108618394|gb|CP018099.1| 880073 g155653 i0 86.364 0.202453987730061 66 9 20 0 1 66 75655 75720 Caldithrix abyssi DSM 13497, complete genome blastn 66 73.1 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
18208143 18208143 PRJNA1249535_S_NODE_205155_length_303_cov_5.004348_g201772_i0 PRJNA1249535 205155 303 5.004348 15.16317444 Caldithrix abyssi 187145 Bacteria Bacteria 54.7 0.008   NTclustered gi|1108618394|gb|CP018099.1| 880073 g201772 i0 96.97 0.108910891089109 33 0 11 1 23 54 1875997 1875965 Caldithrix abyssi DSM 13497, complete genome blastn 33 54.7 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
24828134 24828134 PRJNA630162_P_NODE_162400_length_161_cov_6.473214_g160877_i0 PRJNA630162 162400 161 6.473214 10.42187454 Caldithrix abyssi 187145 Bacteria Bacteria 158 2.76e-34   NTclustered gi|1108618394|gb|CP018099.1| 880073 g160877 i0 90.756 122.937888198758 119 9 73 2 43 160 1053740 1053857 Caldithrix abyssi DSM 13497, complete genome blastn 19793 158 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi

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