contig_metadata
27 rows where tax_clade = "Ice core isolates"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3665512 | 3665512 | PRJNA526570_S_NODE_3683_length_151_cov_12.745902_g3655_i0 | PRJNA526570 | 3683 | 151 | 12.745902 | 19.24631202 | root | 1 | Root_unresolved | Root_unresolved | 279 | 5.19e-71 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g3655 | i0 | 100 | 100 | 151 | 0 | 100 | 0 | 1 | 151 | 11 | 161 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 15100 | 279 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 3720887 | 3720887 | PRJNA680334_S_NODE_106043_length_150_cov_18.726496_g105557_i0 | PRJNA680334 | 106043 | 150 | 18.726496 | 28.089744 | root | 1 | Root_unresolved | Root_unresolved | 278 | 1.85e-70 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g105557 | i0 | 100 | 100 | 150 | 0 | 100 | 0 | 1 | 150 | 13 | 162 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 15000 | 278 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 4485530 | 4485530 | PRJNA681861_P_NODE_36364_length_186_cov_89.299363_g34264_i0 | PRJNA681861 | 36364 | 186 | 89.299363 | 166.09681518 | Ice core clone 105-11 | 77950 | Root_unresolved | Root_unresolved | 150 | 5.48e-32 | NTclustered | gi|3264669|gb|AF069828.1| | 77950 | g34264 | i0 | 98.81 | 80.7311827956989 | 84 | 1 | 73 | 0 | 53 | 136 | 145 | 62 | Ice core clone 105-11 18S ribosomal RNA gene, partial sequence | blastn | 15016 | 150 | 1 | Eukaryota | Ice core isolates | Ice core clone 105-11 | |||||||
| 4963906 | 4963906 | PRJNA565778_S_NODE_35464_length_182_cov_335.137931_g35168_i0 | PRJNA565778 | 35464 | 182 | 335.137931 | 609.95103442 | root | 1 | Root_unresolved | Root_unresolved | 270 | 3.93e-68 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g35168 | i0 | 100 | 80.2197802197802 | 146 | 0 | 80 | 0 | 37 | 182 | 17 | 162 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 14600 | 270 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 6309994 | 6309994 | PRJNA766854_P_NODE_1525_length_335_cov_13.803922_g1400_i0 | PRJNA766854 | 1525 | 335 | 13.803922 | 46.2431387 | root | 1 | Root_unresolved | Root_unresolved | 289 | 2.2099999999999996e-73 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g1400 | i0 | 100 | 46.7014925373134 | 156 | 0 | 47 | 0 | 1 | 156 | 10 | 165 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 15645 | 289 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 7434591 | 7434591 | PRJNA242641_S_NODE_2366_length_152_cov_5.845528_g2338_i0 | PRJNA242641 | 2366 | 152 | 5.845528 | 8.88520256 | root | 1 | Root_unresolved | Root_unresolved | 281 | 1.46e-71 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g2338 | i0 | 100 | 100 | 152 | 0 | 100 | 0 | 1 | 152 | 10 | 161 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 15200 | 281 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 11292080 | 11292080 | PRJNA432257_S_NODE_91729_length_182_cov_1439.186207_g91348_i0 | PRJNA432257 | 91729 | 182 | 1439.186207 | 2619.31889674 | root | 1 | Root_unresolved | Root_unresolved | 250 | 5.1099999999999995e-62 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g91348 | i0 | 100 | 74.1813186813187 | 135 | 0 | 74 | 0 | 7 | 141 | 151 | 17 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 13501 | 252 | 0.992063492063492 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 12474241 | 12474241 | PRJEB673_P_NODE_8950_length_221_cov_2.440860_g8601_i0 | PRJEB673 | 8950 | 221 | 2.44086 | 5.3943006 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 409 | 1.0100000000000001e-109 | NTclustered | gi|2174921264|emb|LR997963.1| | 77947 | g8601 | i0 | 100 | 98.7692307692308 | 221 | 0 | 100 | 0 | 1 | 221 | 230 | 10 | Ice core clone 147-5 partial 18S rRNA gene, isolate EW OTU5453_S2, clone M01452:264:000000000-D5YNG:1:1102:25513:24554 | blastn | 21828 | 409 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-5 | |||||||
| 12658593 | 12658593 | PRJNA691756_S_NODE_3990_length_158_cov_47.503876_g3974_i0 | PRJNA691756 | 3990 | 158 | 47.503876 | 75.05612408 | root | 1 | Root_unresolved | Root_unresolved | 250 | 4.31e-62 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g3974 | i0 | 100 | 85.4493670886076 | 135 | 0 | 85 | 0 | 1 | 135 | 17 | 151 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 13501 | 252 | 0.992063492063492 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 12685615 | 12685615 | PRJNA766854_P_NODE_2130_length_292_cov_16.228137_g2004_i0 | PRJNA766854 | 2130 | 292 | 16.228137 | 47.38616004 | root | 1 | Root_unresolved | Root_unresolved | 289 | 1.8899999999999996e-73 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g2004 | i0 | 100 | 64.6712328767123 | 156 | 0 | 70 | 0 | 1 | 156 | 10 | 165 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 18884 | 289 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 13985546 | 13985546 | PRJNA848822_P_NODE_14311_length_152_cov_9.682927_g13761_i0 | PRJNA848822 | 14311 | 152 | 9.682927 | 14.71804904 | root | 1 | Root_unresolved | Root_unresolved | 276 | 6.770000000000001e-70 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g13761 | i0 | 99.342 | 100 | 152 | 1 | 100 | 0 | 1 | 152 | 19 | 170 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 15200 | 276 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 16312270 | 16312270 | PRJNA1047551_S_NODE_13053_length_152_cov_9.863248_g12926_i0 | PRJNA1047551 | 13053 | 152 | 9.863248 | 14.99213696 | root | 1 | Root_unresolved | Root_unresolved | 246 | 5.31e-61 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g12926 | i0 | 100 | 87.5 | 133 | 0 | 88 | 0 | 20 | 152 | 30 | 162 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 13300 | 246 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 16436269 | 16436269 | PRJNA565416_S_NODE_5133_length_150_cov_2.363636_g5091_i0 | PRJNA565416 | 5133 | 150 | 2.363636 | 3.545454 | root | 1 | Root_unresolved | Root_unresolved | 255 | 8.680000000000001e-64 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g5091 | i0 | 97.333 | 100 | 150 | 4 | 100 | 0 | 1 | 150 | 13 | 162 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 15000 | 255 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 16452702 | 16452702 | PRJNA615351_P_NODE_125733_length_235_cov_106.190000_g111633_i0 | PRJNA615351 | 125733 | 235 | 106.19 | 249.5465 | root | 1 | Root_unresolved | Root_unresolved | 418 | 1.8e-112 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g111633 | i0 | 99.563 | 97.4468085106383 | 229 | 1 | 97 | 0 | 3 | 231 | 7 | 235 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 22900 | 418 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 16603419 | 16603419 | PRJEB29441_P_NODE_33234_length_181_cov_2.575758_g32793_i0 | PRJEB29441 | 33234 | 181 | 2.575758 | 4.66212198 | Ice core clone 105-7 | 77952 | Root_unresolved | Root_unresolved | 313 | 6.39e-81 | NTclustered | gi|3264671|gb|AF069830.1| | 77952 | g32793 | i0 | 97.79 | 107.585635359116 | 181 | 4 | 100 | 0 | 1 | 181 | 39 | 219 | Ice core clone 105-7 18S ribosomal RNA gene, partial sequence | blastn | 19473 | 313 | 1 | Eukaryota | Ice core isolates | Ice core clone 105-7 | |||||||
| 18852986 | 18852986 | PRJNA1008049_S_NODE_3995_length_158_cov_47.503876_g3977_i0 | PRJNA1008049 | 3995 | 158 | 47.503876 | 75.05612408 | root | 1 | Root_unresolved | Root_unresolved | 250 | 4.31e-62 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g3977 | i0 | 100 | 85.4493670886076 | 135 | 0 | 85 | 0 | 1 | 135 | 17 | 151 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 13501 | 252 | 0.992063492063492 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 21473622 | 21473622 | PRJNA352869_P_NODE_12377_length_156_cov_16.952756_g11978_i0 | PRJNA352869 | 12377 | 156 | 16.952756 | 26.44629936 | root | 1 | Root_unresolved | Root_unresolved | 278 | 1.95e-70 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g11978 | i0 | 99.346 | 98.0961538461538 | 153 | 1 | 98 | 0 | 1 | 153 | 10 | 162 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 15303 | 279 | 0.996415770609319 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 22680107 | 22680107 | PRJNA1020854_S_NODE_26998_length_201_cov_3293.261628_g24234_i0 | PRJNA1020854 | 26998 | 201 | 3293.261628 | 6619.45587228 | root | 1 | Root_unresolved | Root_unresolved | 250 | 5.78e-62 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g24234 | i0 | 100 | 67.1691542288557 | 135 | 0 | 67 | 0 | 55 | 189 | 17 | 151 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 13501 | 252 | 0.992063492063492 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 24034614 | 24034614 | PRJNA414036_P_NODE_31319_length_267_cov_8.823276_g29583_i0 | PRJNA414036 | 31319 | 267 | 8.823276 | 23.55814692 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 255 | 1.73e-63 | NTclustered | gi|2174921264|emb|LR997963.1| | 77947 | g29583 | i0 | 93.182 | 75.0786516853933 | 176 | 9 | 66 | 2 | 10 | 184 | 209 | 36 | Ice core clone 147-5 partial 18S rRNA gene, isolate EW OTU5453_S2, clone M01452:264:000000000-D5YNG:1:1102:25513:24554 | blastn | 20046 | 255 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-5 | |||||||
| 24118004 | 24118004 | PRJNA674048_P_NODE_30459_length_164_cov_4.156522_g30256_i0 | PRJNA674048 | 30459 | 164 | 4.156522 | 6.81669608 | root | 1 | Root_unresolved | Root_unresolved | 303 | 3.42e-78 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g30256 | i0 | 100 | 100 | 164 | 0 | 100 | 0 | 1 | 164 | 3 | 166 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 16400 | 303 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 24197532 | 24197532 | PRJNA900999_S_NODE_8379_length_159_cov_67.661538_g8323_i0 | PRJNA900999 | 8379 | 159 | 67.661538 | 107.58184542 | root | 1 | Root_unresolved | Root_unresolved | 289 | 9.22e-74 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g8323 | i0 | 99.371 | 100 | 159 | 1 | 100 | 0 | 1 | 159 | 159 | 1 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 15900 | 289 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 25307810 | 25307810 | PRJNA407368_S_NODE_10360_length_152_cov_68.227642_g10258_i0 | PRJNA407368 | 10360 | 152 | 68.227642 | 103.70601584 | root | 1 | Root_unresolved | Root_unresolved | 274 | 2.44e-69 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g10258 | i0 | 99.338 | 99.3421052631579 | 151 | 1 | 99 | 0 | 2 | 152 | 161 | 11 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 15100 | 274 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 25370392 | 25370392 | PRJNA604753_S_NODE_4680_length_161_cov_5.742424_g4657_i0 | PRJNA604753 | 4680 | 161 | 5.742424 | 9.24530264 | root | 1 | Root_unresolved | Root_unresolved | 261 | 2.04e-65 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g4657 | i0 | 100 | 87.6024844720497 | 141 | 0 | 88 | 0 | 21 | 161 | 18 | 158 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 14104 | 263 | 0.992395437262357 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 25761102 | 25761102 | PRJNA399711_S_NODE_81722_length_166_cov_19.085271_g81580_i0 | PRJNA399711 | 81722 | 166 | 19.085271 | 31.68154986 | root | 1 | Root_unresolved | Root_unresolved | 254 | 3.55e-63 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g81580 | i0 | 98.601 | 86.1506024096386 | 143 | 2 | 86 | 0 | 5 | 147 | 9 | 151 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 14301 | 255 | 0.996078431372549 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 25888768 | 25888768 | PRJEB7799f_S_NODE_6355_length_159_cov_2.338710_g6339_i0 | PRJEB7799 | 6355 | 159 | 2.33871 | 3.7185489 | root | 1 | Root_unresolved | Root_unresolved | 289 | 9.22e-74 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g6339 | i0 | 99.371 | 100 | 159 | 1 | 100 | 0 | 1 | 159 | 17 | 175 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 15900 | 289 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 25889609 | 25889609 | PRJEB8827e_S_NODE_41715_length_154_cov_2.731092_g41687_i0 | PRJEB8827 | 41715 | 154 | 2.731092 | 4.20588168 | root | 1 | Root_unresolved | Root_unresolved | 246 | 5.4e-61 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g41687 | i0 | 100 | 86.3701298701299 | 133 | 0 | 86 | 0 | 22 | 154 | 151 | 19 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 13301 | 248 | 0.991935483870968 | Eukaryota | Ice core isolates | Ice core clone 147-15 | |||||||
| 26438717 | 26438717 | PRJNA1233465e_S_NODE_44775_length_269_cov_10.363636_g43465_i0 | PRJNA1233465 | 44775 | 269 | 10.363636 | 27.87818084 | root | 1 | Root_unresolved | Root_unresolved | 272 | 1.74e-68 | NTclustered | gi|3264665|gb|AF069824.1| | 77946 | g43465 | i0 | 100 | 98.3754646840149 | 147 | 0 | 55 | 0 | 1 | 147 | 163 | 17 | Ice core clone 147-15 18S ribosomal RNA gene, partial sequence | blastn | 26463 | 272 | 1 | Eukaryota | Ice core isolates | Ice core clone 147-15 |
Advanced export
JSON shape: default, array, newline-delimited
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);;