contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 974051 | 974051 | PRJNA986481_P_NODE_8641_length_553_cov_5.037698_g8131_i0 | PRJNA986481 | 8641 | 553 | 5.037698 | 27.85846994 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 3.5500000000000004e-123 | NTclustered | gi|300676716|gb|GQ377714.1| | 323453 | g8131 | i0 | 86.538 | 61.1971066907776 | 416 | 52 | 75 | 3 | 4 | 419 | 43 | 454 | Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds | blastn | 33842 | 455 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 2249228 | 2249228 | PRJNA986481_P_NODE_63282_length_204_cov_11.722581_g62757_i0 | PRJNA986481 | 63282 | 204 | 11.722581 | 23.91406524 | Cercozoa sp. Panama112 | 563759 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 2.59e-100 | NTclustered | gi|219524795|gb|EU709158.1| | 563759 | g62757 | i0 | 100 | 99.9656862745098 | 204 | 0 | 100 | 0 | 1 | 204 | 1563 | 1360 | Cercozoa sp. Panama112 18S ribosomal RNA gene, partial sequence | blastn | 20393 | 377 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. Panama112 | ||||||
| 3524037 | 3524037 | PRJNA986481_P_NODE_2723_length_899_cov_1877.987059_g855_i4 | PRJNA986481 | 2723 | 899 | 1877.987059 | 16883.10366041 | Amorphochlora amoebiformis | 1561963 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 6.18e-93 | NTclustered | gi|220983371|dbj|AB453007.1| | 1561963 | g855 | i4 | 78.957 | 46.0856507230256 | 556 | 92 | 61 | 21 | 184 | 730 | 1231 | 692 | Amorphochlora amoebiformis gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 41431 | 355 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Amorphochlora | Amorphochlora amoebiformis | ||||
| 4801895 | 4801895 | PRJNA986481_P_NODE_6544_length_630_cov_2.089501_g6066_i0 | PRJNA986481 | 6544 | 630 | 2.089501 | 13.1638563 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 780 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g6066 | i0 | 89.155 | 98.1015873015873 | 627 | 66 | 99 | 2 | 3 | 628 | 659 | 34 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 61804 | 780 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9901502 | 9901502 | PRJNA986481_P_NODE_20128_length_365_cov_2.632911_g19603_i0 | PRJNA986481 | 20128 | 365 | 2.632911 | 9.61012515 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.5e-53 | NTclustered | gi|300676723|gb|GQ377712.1| | 323453 | g19603 | i0 | 82.558 | 4.73150684931507 | 258 | 39 | 70 | 6 | 111 | 365 | 4 | 258 | Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds | blastn | 1727 | 222 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 13727230 | 13727230 | PRJNA986481_P_NODE_3831_length_784_cov_10.468027_g3443_i0 | PRJNA986481 | 3831 | 784 | 10.468027 | 82.06933168 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 754 | 0 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g3443 | i0 | 91.219 | 61 | 558 | 43 | 77 | 3 | 233 | 784 | 1895 | 1338 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 47824 | 754 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 15001694 | 15001694 | PRJNA986481_P_NODE_48012_length_254_cov_1.697561_g47487_i0 | PRJNA986481 | 48012 | 254 | 1.697561 | 4.31180494 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 470 | 5.37e-128 | NTclustered | gi|224996436|gb|FJ654268.1| | 188950 | g47487 | i0 | 100 | 100.291338582677 | 254 | 0 | 100 | 0 | 1 | 254 | 728 | 475 | Bodomorpha minima 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 25474 | 470 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 16276189 | 16276189 | PRJNA986481_P_NODE_18553_length_380_cov_1.945619_g18028_i0 | PRJNA986481 | 18553 | 380 | 1.945619 | 7.3933522 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 3.3299999999999997e-62 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g18028 | i0 | 79.57 | 94.3289473684211 | 372 | 60 | 96 | 11 | 2 | 365 | 100 | 463 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 35845 | 252 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 20100194 | 20100194 | PRJNA986481_P_NODE_44676_length_258_cov_0.966507_g44151_i0 | PRJNA986481 | 44676 | 258 | 0.966507 | 2.49358806 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 2.77e-66 | NTclustered | gi|300676750|gb|GQ377668.1| | 45107 | g44151 | i0 | 85.214 | 97.515503875969 | 257 | 38 | 99 | 0 | 1 | 257 | 984 | 728 | Heteromita globosa actin gene, partial cds | blastn | 25159 | 265 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 20100198 | 20100198 | PRJNA986481_P_NODE_4496_length_738_cov_8.277213_g4080_i0 | PRJNA986481 | 4496 | 738 | 8.277213 | 61.08583194 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 4.96e-103 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g4080 | i0 | 85.417 | 58.0731707317073 | 384 | 45 | 84 | 10 | 358 | 738 | 4039 | 3664 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 42858 | 388 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 21674461 | 21674461 | PRJNA986481_P_NODE_37797_length_266_cov_9.377880_g37272_i0 | PRJNA986481 | 37797 | 266 | 9.37788 | 24.9451608 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.5900000000000002e-123 | NTclustered | gi|512134093|gb|KC575317.1| | 175275 | g37272 | i0 | 100 | 92.4661654135338 | 246 | 0 | 92 | 0 | 21 | 266 | 149 | 394 | Uncultured cercozoan clone B.17.1 18S ribosomal RNA gene, partial sequence | blastn | 24596 | 455 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 22650707 | 22650707 | PRJNA986481_P_NODE_4018_length_770_cov_9.486824_g3622_i0 | PRJNA986481 | 4018 | 770 | 9.486824 | 73.0485448 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 595 | 2.8499999999999995e-165 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g3622 | i0 | 86.679 | 58.3922077922078 | 548 | 59 | 77 | 10 | 1 | 538 | 1338 | 1881 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 44962 | 595 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 25199537 | 25199537 | PRJNA986481_P_NODE_20220_length_364_cov_3.841270_g19695_i0 | PRJNA986481 | 20220 | 364 | 3.84127 | 13.9822228 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 628 | 1.2499999999999999e-175 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g19695 | i0 | 97.802 | 2 | 364 | 8 | 100 | 0 | 1 | 364 | 350 | 713 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 728 | 628 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 25199888 | 25199888 | PRJNA986481_P_NODE_42900_length_260_cov_1.308057_g42375_i0 | PRJNA986481 | 42900 | 260 | 1.308057 | 3.4009482 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 7.83e-62 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g42375 | i0 | 84.03 | 1.01153846153846 | 263 | 39 | 100 | 2 | 1 | 260 | 25398 | 25660 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 263 | 250 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina |
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);;