contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJDB9741" 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 | |||
| 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 | |||
| 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 | |||
| 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 |
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);;