contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA1000943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145144 | 145144 | PRJNA1000943_P_NODE_14361_length_244_cov_3.099415_g14223_i0 | PRJNA1000943 | 14361 | 244 | 3.099415 | 7.5625726 | Bodomorpha sp. Panama105 | 555789 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 1.86e-122 | NTclustered | gi|219524917|gb|EU709280.1| | 555789 | g14223 | i0 | 100 | 84.3811475409836 | 244 | 0 | 100 | 0 | 1 | 244 | 1380 | 1623 | Bodomorpha sp. Panama105 18S ribosomal RNA gene, partial sequence | blastn | 20589 | 451 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. Panama105 | |||
| 145162 | 145162 | PRJNA1000943_P_NODE_16101_length_218_cov_5.517241_g15963_i0 | PRJNA1000943 | 16101 | 218 | 5.517241 | 12.02758538 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 398 | 2.1499999999999996e-106 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g15963 | i0 | 99.541 | 100.334862385321 | 218 | 1 | 100 | 0 | 1 | 218 | 1026 | 809 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 21873 | 398 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 3971402 | 3971402 | PRJNA1000943_P_NODE_1384_length_641_cov_5.195423_g1253_i0 | PRJNA1000943 | 1384 | 641 | 5.195423 | 33.30266143 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 990 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g1253 | i0 | 94.251 | 72.3478939157566 | 661 | 17 | 99 | 10 | 2 | 641 | 2122 | 1462 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 46375 | 990 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 3971460 | 3971460 | PRJNA1000943_P_NODE_4344_length_378_cov_1.527869_g4207_i0 | PRJNA1000943 | 4344 | 378 | 1.527869 | 5.77534482 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 1.11e-111 | NTclustered | gi|300676723|gb|GQ377712.1| | 323453 | g4207 | i0 | 86.508 | 1 | 378 | 51 | 100 | 0 | 1 | 378 | 776 | 399 | Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds | blastn | 378 | 416 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 6523416 | 6523416 | PRJNA1000943_P_NODE_1246_length_675_cov_16.443522_g1115_i0 | PRJNA1000943 | 1246 | 675 | 16.443522 | 110.9937735 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 684 | 0 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g1115 | i0 | 84.942 | 79.922962962963 | 684 | 91 | 99 | 9 | 3 | 675 | 2303 | 1621 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 53948 | 684 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 6523489 | 6523489 | PRJNA1000943_P_NODE_3406_length_420_cov_3.221902_g3269_i0 | PRJNA1000943 | 3406 | 420 | 3.221902 | 13.5319884 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 695 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g3269 | i0 | 96.454 | 8.3952380952381 | 423 | 12 | 100 | 3 | 1 | 420 | 385 | 807 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 3526 | 695 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 7797672 | 7797672 | PRJNA1000943_P_NODE_5187_length_350_cov_4.649819_g5050_i0 | PRJNA1000943 | 5187 | 350 | 4.649819 | 16.2743665 | Phytocercomonas venanatans | 2065209 | SAR_Eukaryotes | SAR_Eukaryotes | 381 | 3.709999999999999e-101 | NTclustered | gi|1315527746|gb|MF034898.1| | 2065209 | g5050 | i0 | 87.805 | 92.7257142857143 | 328 | 36 | 93 | 3 | 3 | 328 | 1299 | 974 | Phytocercomonas venanatans actin gene, complete cds | blastn | 32454 | 381 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Phytocercomonas | Phytocercomonas venanatans | |||
| 11202550 | 11202550 | PRJNA1000943_P_NODE_8309_length_286_cov_11.615023_g8171_i0 | PRJNA1000943 | 8309 | 286 | 11.615023 | 33.21896578 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 518 | 2.17e-142 | NTclustered | gi|262262836|gb|FJ790729.1| | 686751 | g8171 | i0 | 99.301 | 100.01048951049 | 286 | 2 | 100 | 0 | 1 | 286 | 80 | 365 | Paracercomonas elongata strain IVY11 18S ribosomal RNA gene, partial sequence | blastn | 28603 | 518 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas elongata | |||
| 11623733 | 11623733 | PRJNA1000943_P_NODE_3290_length_426_cov_11.059490_g3153_i0 | PRJNA1000943 | 3290 | 426 | 11.05949 | 47.1134274 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 1.26e-111 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g3153 | i0 | 86.432 | 50.5422535211268 | 398 | 32 | 92 | 13 | 1 | 393 | 3659 | 4039 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 21531 | 416 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 12478164 | 12478164 | PRJNA1000943_P_NODE_4390_length_376_cov_5.448845_g4253_i0 | PRJNA1000943 | 4390 | 376 | 5.448845 | 20.4876572 | Paracercomonas | 372085 | SAR_Eukaryotes | SAR_Eukaryotes | 678 | 0 | NTclustered | gi|336245467|gb|HM536158.1| | 1043741 | g4253 | i0 | 99.202 | 94.5265957446808 | 376 | 3 | 100 | 0 | 1 | 376 | 605 | 980 | Paracercomonas proboscata strain HFCC 913 18S ribosomal RNA gene, partial sequence | blastn | 35542 | 684 | 0.991228070175439 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas proboscata | |||
| 12898841 | 12898841 | PRJNA1000943_P_NODE_4171_length_384_cov_3.305466_g4034_i0 | PRJNA1000943 | 4171 | 384 | 3.305466 | 12.69298944 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 619 | 8.009999999999999e-173 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g4034 | i0 | 95.833 | 101.052083333333 | 384 | 15 | 100 | 1 | 1 | 384 | 1604 | 1222 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 38804 | 619 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 12898889 | 12898889 | PRJNA1000943_P_NODE_8751_length_280_cov_2.260870_g8613_i0 | PRJNA1000943 | 8751 | 280 | 2.26087 | 6.330436 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 6.539999999999999e-68 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g8613 | i0 | 90.385 | 60.1321428571429 | 208 | 16 | 74 | 4 | 2 | 207 | 3696 | 3901 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 16837 | 270 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 16722034 | 16722034 | PRJNA1000943_P_NODE_4494_length_373_cov_1.820000_g4357_i0 | PRJNA1000943 | 4494 | 373 | 1.82 | 6.7886 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 5.05e-115 | NTclustered | gi|301014702|gb|GQ377715.1| | 323453 | g4357 | i0 | 88.889 | 66.4369973190349 | 351 | 33 | 93 | 6 | 26 | 373 | 40 | 387 | Heteromita sp. PRA-74 ribosomal protein S23a (rps23a) mRNA, complete cds | blastn | 24781 | 427 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 17577100 | 17577100 | PRJNA1000943_P_NODE_15614_length_241_cov_3.321429_g15476_i0 | PRJNA1000943 | 15614 | 241 | 3.321429 | 8.00464389 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 8.519999999999999e-121 | NTclustered | gi|512134093|gb|KC575317.1| | 175275 | g15476 | i0 | 100 | 99.9751037344398 | 241 | 0 | 100 | 0 | 1 | 241 | 388 | 148 | Uncultured cercozoan clone B.17.1 18S ribosomal RNA gene, partial sequence | blastn | 24094 | 446 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 21821992 | 21821992 | PRJNA1000943_P_NODE_2958_length_448_cov_6.088000_g2821_i0 | PRJNA1000943 | 2958 | 448 | 6.088 | 27.27424 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 1.7799999999999999e-90 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g2821 | i0 | 83.417 | 50.90625 | 398 | 41 | 88 | 18 | 54 | 448 | 4039 | 3664 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 22806 | 346 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 21822001 | 21822001 | PRJNA1000943_P_NODE_3838_length_399_cov_19.460123_g3701_i0 | PRJNA1000943 | 3838 | 399 | 19.460123 | 77.64589077 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 5.88e-60 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g3701 | i0 | 91.16 | 52.2932330827068 | 181 | 14 | 45 | 2 | 1 | 179 | 3658 | 3838 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20865 | 244 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 23097244 | 23097244 | PRJNA1000943_P_NODE_1079_length_722_cov_1.922958_g952_i0 | PRJNA1000943 | 1079 | 722 | 1.922958 | 13.88375676 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 702 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g952 | i0 | 98.98 | 66.4473684210526 | 392 | 4 | 54 | 0 | 1 | 392 | 502 | 893 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 47975 | 702 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23097310 | 23097310 | PRJNA1000943_P_NODE_2799_length_458_cov_12.883117_g2662_i0 | PRJNA1000943 | 2799 | 458 | 12.883117 | 59.00467586 | Cercomonas sp. HFCC53 | 458867 | SAR_Eukaryotes | SAR_Eukaryotes | 824 | 0 | NTclustered | gi|161015705|gb|EF681939.1| | 458867 | g2662 | i0 | 99.127 | 43.2292576419214 | 458 | 4 | 100 | 0 | 1 | 458 | 628 | 171 | Cercomonas sp. HFCC53 28S ribosomal RNA gene, partial sequence | blastn | 19799 | 824 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC53 | |||
| 23097358 | 23097358 | PRJNA1000943_P_NODE_7059_length_307_cov_10.705128_g6921_i0 | PRJNA1000943 | 7059 | 307 | 10.705128 | 32.86474296 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 422 | 1.8999999999999996e-113 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g6921 | i0 | 91.586 | 99.3615635179153 | 309 | 21 | 99 | 4 | 2 | 307 | 2886 | 2580 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 30504 | 422 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 24371007 | 24371007 | PRJNA1000943_P_NODE_15240_length_242_cov_1.739645_g15102_i0 | PRJNA1000943 | 15240 | 242 | 1.739645 | 4.2099409 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 4.0699999999999996e-104 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g15102 | i0 | 96.983 | 87.7851239669422 | 232 | 7 | 96 | 0 | 11 | 242 | 259 | 28 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 21244 | 390 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24371053 | 24371053 | PRJNA1000943_P_NODE_5160_length_351_cov_2.615108_g5023_i0 | PRJNA1000943 | 5160 | 351 | 2.615108 | 9.17902908 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 3.7499999999999985e-96 | NTclustered | gi|300676716|gb|GQ377714.1| | 323453 | g5023 | i0 | 86.527 | 63.1225071225071 | 334 | 41 | 95 | 3 | 7 | 340 | 372 | 43 | Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds | blastn | 22156 | 364 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 24371094 | 24371094 | PRJNA1000943_P_NODE_8320_length_286_cov_3.295775_g8182_i0 | PRJNA1000943 | 8320 | 286 | 3.295775 | 9.4259165 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 490 | 4.729999999999998e-134 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g8182 | i0 | 97.552 | 91.479020979021 | 286 | 7 | 100 | 0 | 1 | 286 | 621 | 336 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 26163 | 490 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima |
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);;