contig_metadata
25 rows where bioproject = "PRJDB9741", tax_clade = "Sar" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10802 | 10802 | PRJDB9741_P_NODE_11521_length_198_cov_1.174497_g11204_i0 | PRJDB9741 | 11521 | 198 | 1.174497 | 2.32550406 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 4.32e-73 | NTclustered | gi|300676750|gb|GQ377668.1| | 45107 | g11204 | i0 | 92.893 | 89.0151515151515 | 197 | 14 | 99 | 0 | 2 | 198 | 785 | 981 | Heteromita globosa actin gene, partial cds | blastn | 17625 | 287 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 10807 | 10807 | PRJDB9741_P_NODE_11801_length_196_cov_1.843537_g11484_i0 | PRJDB9741 | 11801 | 196 | 1.843537 | 3.61333252 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.2699999999999999e-23 | NTclustered | gi|300676723|gb|GQ377712.1| | 323453 | g11484 | i0 | 83.582 | 10.5765306122449 | 134 | 18 | 67 | 4 | 65 | 196 | 4 | 135 | Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds | blastn | 2073 | 122 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 10937 | 10937 | PRJDB9741_P_NODE_26901_length_167_cov_2.076271_g26584_i0 | PRJDB9741 | 26901 | 167 | 2.076271 | 3.46737257 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.5e-78 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g26584 | i0 | 99.401 | 96.9101796407186 | 167 | 1 | 100 | 0 | 1 | 167 | 795 | 629 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 16184 | 303 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 981858 | 981858 | PRJDB9741_P_NODE_3821_length_340_cov_1.168385_g3505_i0 | PRJDB9741 | 3821 | 340 | 1.168385 | 3.972509 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 7.71e-32 | NR | AAY21202.1 | 227086 | g3505 | i0 | 68.8 | 1.41176470588235 | 80 | 25 | 70.6 | 0 | 99 | 338 | 17 | 96 | AAY21202.1 Rpl7A, partial [Bigelowiella natans] | diamond | 480 | 120 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 1285163 | 1285163 | PRJDB9741_P_NODE_19782_length_178_cov_1.581395_g19465_i0 | PRJDB9741 | 19782 | 178 | 1.581395 | 2.8148831 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 3.929999999999999e-48 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g19465 | i0 | 87.432 | 6.4438202247191 | 183 | 15 | 99 | 6 | 3 | 178 | 1691 | 1872 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 1147 | 204 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 1285405 | 1285405 | PRJDB9741_P_NODE_8382_length_217_cov_6.285714_g8065_i0 | PRJDB9741 | 8382 | 217 | 6.285714 | 13.63999938 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 2.31e-51 | NTclustered | gi|1389527545|dbj|LC383945.1| | 1928728 | g8065 | i0 | 84.651 | 36.9493087557604 | 215 | 33 | 99 | 0 | 2 | 216 | 231 | 445 | Paulinella micropora gene for actin, complete cds | blastn | 8018 | 215 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 4809853 | 4809853 | PRJDB9741_P_NODE_7324_length_231_cov_4.197802_g7007_i0 | PRJDB9741 | 7324 | 231 | 4.197802 | 9.69692262 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 422 | 1.37e-113 | NTclustered | gi|512134093|gb|KC575317.1| | 175275 | g7007 | i0 | 99.567 | 99.8311688311688 | 231 | 1 | 100 | 0 | 1 | 231 | 374 | 144 | Uncultured cercozoan clone B.17.1 18S ribosomal RNA gene, partial sequence | blastn | 23061 | 422 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 7663297 | 7663297 | PRJDB9741_P_NODE_3427_length_366_cov_5.794953_g3111_i0 | PRJDB9741 | 3427 | 366 | 5.794953 | 21.20952798 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 2.87e-137 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g3111 | i0 | 91.375 | 101.155737704918 | 371 | 24 | 100 | 8 | 1 | 366 | 3041 | 2674 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 37023 | 501 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9910092 | 9910092 | PRJDB9741_P_NODE_7268_length_232_cov_5.349727_g6951_i0 | PRJDB9741 | 7268 | 232 | 5.349727 | 12.41136664 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 2.05e-12 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g6951 | i0 | 97.959 | 15.4094827586207 | 49 | 1 | 45 | 0 | 184 | 232 | 3839 | 3791 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 3575 | 86.1 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 10213819 | 10213819 | PRJDB9741_P_NODE_5549_length_268_cov_1.260274_g5233_i0 | PRJDB9741 | 5549 | 268 | 1.260274 | 3.37753432 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 9.979999999999997e-96 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g5233 | i0 | 91.045 | 97.4738805970149 | 268 | 24 | 100 | 0 | 1 | 268 | 273 | 540 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 26123 | 363 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 11488904 | 11488904 | PRJDB9741_P_NODE_2990_length_406_cov_5.086835_g2675_i0 | PRJDB9741 | 2990 | 406 | 5.086835 | 20.6525501 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 737 | 0 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g2675 | i0 | 99.507 | 86.5394088669951 | 406 | 1 | 100 | 1 | 1 | 406 | 1301 | 1705 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 35135 | 737 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14039146 | 14039146 | PRJDB9741_P_NODE_6632_length_243_cov_3.407216_g6315_i0 | PRJDB9741 | 6632 | 243 | 3.407216 | 8.27953488 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 2.69e-33 | NR | MES1907458.1 | 1215613 | g6315 | i0 | 76.5 | 2.02469135802469 | 81 | 19 | 100 | 0 | 243 | 1 | 51 | 131 | MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 492 | 125 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 15313004 | 15313004 | PRJDB9741_P_NODE_14453_length_188_cov_0.985612_g14136_i0 | PRJDB9741 | 14453 | 188 | 0.985612 | 1.85295056 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 1.87e-76 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g14136 | i0 | 95.213 | 96.0851063829787 | 188 | 9 | 100 | 0 | 1 | 188 | 721 | 534 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 18064 | 298 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 16587762 | 16587762 | PRJDB9741_P_NODE_2134_length_515_cov_1.564378_g1823_i0 | PRJDB9741 | 2134 | 515 | 1.564378 | 8.0565467 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 946 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g1823 | i0 | 99.806 | 97.2252427184466 | 515 | 1 | 100 | 0 | 1 | 515 | 308 | 822 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 50071 | 946 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 16587795 | 16587795 | PRJDB9741_P_NODE_2594_length_453_cov_2.254950_g2280_i0 | PRJDB9741 | 2594 | 453 | 2.25495 | 10.2149235 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 214 | 1.4499999999999998e-66 | NR | MES1907458.1 | 1215613 | g2280 | i0 | 73.3 | 1.98013245033113 | 146 | 39 | 96.7 | 0 | 1 | 438 | 16 | 161 | MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 897 | 214 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 16587897 | 16587897 | PRJDB9741_P_NODE_4054_length_327_cov_1.097122_g3738_i0 | PRJDB9741 | 4054 | 327 | 1.097122 | 3.58758894 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 593 | 4.0699999999999987e-165 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g3738 | i0 | 99.388 | 93.5993883792049 | 327 | 2 | 100 | 0 | 1 | 327 | 327 | 653 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 30607 | 593 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 17862732 | 17862732 | PRJDB9741_P_NODE_26915_length_167_cov_1.983051_g26598_i0 | PRJDB9741 | 26915 | 167 | 1.983051 | 3.31169517 | Paulinella chromatophora | 39717 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 6.2e-36 | NTclustered | gi|238617607|gb|FJ973382.1| | 39717 | g26598 | i0 | 95.146 | 58.3053892215569 | 103 | 5 | 62 | 0 | 65 | 167 | 1348 | 1246 | Paulinella chromatophora strain MO88/a 28S ribosomal RNA gene, partial sequence | blastn | 9737 | 163 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 17862868 | 17862868 | PRJDB9741_P_NODE_4495_length_305_cov_1.917969_g4179_i0 | PRJDB9741 | 4495 | 305 | 1.917969 | 5.84980545 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 1.5099999999999997e-89 | NTclustered | gi|301014702|gb|GQ377715.1| | 323453 | g4179 | i0 | 89.209 | 58.855737704918 | 278 | 24 | 90 | 6 | 24 | 298 | 40 | 314 | Heteromita sp. PRA-74 ribosomal protein S23a (rps23a) mRNA, complete cds | blastn | 17951 | 342 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 19136483 | 19136483 | PRJDB9741_P_NODE_3396_length_368_cov_12.717868_g3080_i0 | PRJDB9741 | 3396 | 368 | 12.717868 | 46.80175424 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 619 | 7.64e-173 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g3080 | i0 | 97.011 | 100.510869565217 | 368 | 11 | 100 | 0 | 1 | 368 | 2674 | 3041 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 36988 | 619 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 21687481 | 21687481 | PRJDB9741_P_NODE_2578_length_455_cov_3.753695_g2264_i0 | PRJDB9741 | 2578 | 455 | 3.753695 | 17.07931225 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 795 | 0 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g2264 | i0 | 98.238 | 21.0197802197802 | 454 | 8 | 99 | 0 | 2 | 455 | 711 | 258 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 9564 | 795 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 22658759 | 22658759 | PRJDB9741_P_NODE_12298_length_193_cov_1.416667_g11981_i0 | PRJDB9741 | 12298 | 193 | 1.416667 | 2.73416731 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 3.33e-54 | NTclustered | gi|220983376|dbj|AB453012.1| | 552662 | g11981 | i0 | 95.683 | 73.4766839378238 | 139 | 6 | 72 | 0 | 53 | 191 | 1691 | 1553 | Cercozoa sp. YPF501 gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 14181 | 224 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. YPF501 | ||||||
| 22962976 | 22962976 | PRJDB9741_P_NODE_9879_length_209_cov_2.587500_g9562_i0 | PRJDB9741 | 9879 | 209 | 2.5875 | 5.407875 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 4.149999999999999e-31 | NR | ADK26624.1 | 323453 | g9562 | i0 | 81.2 | 0.990430622009569 | 69 | 13 | 99 | 0 | 1 | 207 | 116 | 184 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 207 | 119 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 29306130 | 29306130 | PRJDB9741_P_NODE_11929_length_195_cov_2.116438_g11612_i0 | PRJDB9741 | 11929 | 195 | 2.116438 | 4.1270541 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 96.7 | 1.95e-22 | NR | ADK26624.1 | 323453 | g11612 | i0 | 82.7 | 0.8 | 52 | 9 | 80 | 0 | 2 | 157 | 225 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 156 | 96.7 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 32119057 | 32119057 | PRJDB9741_P_NODE_21378_length_175_cov_3.404762_g21061_i0 | PRJDB9741 | 21378 | 175 | 3.404762 | 5.9583335 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 1.14e-29 | NR | ADK26624.1 | 323453 | g21061 | i0 | 84.5 | 0.994285714285714 | 58 | 9 | 99.4 | 0 | 1 | 174 | 54 | 111 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 174 | 115 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 32530458 | 32530458 | PRJDB9741_P_NODE_10119_length_207_cov_1.601266_g9802_i0 | PRJDB9741 | 10119 | 207 | 1.601266 | 3.31462062 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.02e-36 | NR | ADK26622.1 | 323453 | g9802 | i0 | 85.5 | 1 | 69 | 10 | 100 | 0 | 207 | 1 | 48 | 116 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 207 | 129 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 |
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);;