contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA533114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6883007 | 6883007 | PRJNA533114_P_NODE_61246_length_304_cov_13.424242_g60994_i0 | PRJNA533114 | 61246 | 304 | 13.424242 | 40.80969568 | Cercomonas agilis | 310805 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 9.099999999999999e-82 | NTclustered | gi|58414956|gb|AY748813.1| | 310805 | g60994 | i0 | 86.667 | 151.736842105263 | 285 | 38 | 94 | 0 | 1 | 285 | 1 | 285 | Cercomonas agilis polyubiquitin (UBQ) gene, partial cds | blastn | 46128 | 316 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas agilis | |||
| 9432702 | 9432702 | PRJNA533114_P_NODE_1048_length_1681_cov_54.337065_g998_i0 | PRJNA533114 | 1048 | 1681 | 54.337065 | 913.40606265 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1633 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g998 | i0 | 99.664 | 74.8167757287329 | 893 | 3 | 53 | 0 | 446 | 1338 | 893 | 1 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 125767 | 1633 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 10708897 | 10708897 | PRJNA533114_P_NODE_25429_length_451_cov_1.470899_g25179_i0 | PRJNA533114 | 25429 | 451 | 1.470899 | 6.63375449 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 721 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g25179 | i0 | 95.585 | 4.72062084257206 | 453 | 14 | 100 | 6 | 1 | 451 | 581 | 133 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 2129 | 721 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 10709000 | 10709000 | PRJNA533114_P_NODE_32589_length_401_cov_2.911585_g32337_i0 | PRJNA533114 | 32589 | 401 | 2.911585 | 11.67545585 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 556 | 6.68e-154 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g32337 | i0 | 91.75 | 91.0224438902743 | 400 | 33 | 99 | 0 | 1 | 400 | 186 | 585 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 36500 | 556 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 15807864 | 15807864 | PRJNA533114_P_NODE_48853_length_336_cov_7.855513_g48601_i0 | PRJNA533114 | 48853 | 336 | 7.855513 | 26.39452368 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 499 | 9.42e-137 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g48601 | i0 | 93.491 | 101.339285714286 | 338 | 19 | 100 | 3 | 1 | 336 | 2165 | 2501 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 34050 | 499 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 17081938 | 17081938 | PRJNA533114_P_NODE_122914_length_226_cov_2.712418_g122662_i0 | PRJNA533114 | 122914 | 226 | 2.712418 | 6.13006468 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 3.1099999999999988e-55 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g122662 | i0 | 90.643 | 61.6902654867257 | 171 | 16 | 76 | 0 | 56 | 226 | 795 | 625 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 13942 | 228 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 17082275 | 17082275 | PRJNA533114_P_NODE_28834_length_425_cov_1.548295_g28582_i0 | PRJNA533114 | 28834 | 425 | 1.548295 | 6.58025375 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 754 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g28582 | i0 | 98.598 | 41.04 | 428 | 3 | 100 | 3 | 1 | 425 | 1580 | 2007 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 17442 | 754 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 18356492 | 18356492 | PRJNA533114_P_NODE_38535_length_372_cov_11.093645_g38283_i0 | PRJNA533114 | 38535 | 372 | 11.093645 | 41.2683594 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 1.46e-85 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g38283 | i0 | 83.74 | 54.1182795698925 | 369 | 38 | 99 | 14 | 6 | 372 | 4008 | 3660 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20132 | 329 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 18357012 | 18357012 | PRJNA533114_P_NODE_80895_length_270_cov_1.243655_g80643_i0 | PRJNA533114 | 80895 | 270 | 1.243655 | 3.3578685 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 7.409999999999998e-132 | NTclustered | gi|336041394|gb|HQ834950.1| | 188950 | g80643 | i0 | 98.885 | 75.3148148148148 | 269 | 3 | 99 | 0 | 1 | 269 | 939 | 1207 | Bodomorpha minima strain ATCC 50339 RNA polymerase II largest subunit (Rpb1) gene, partial cds | blastn | 20335 | 483 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 22181284 | 22181284 | PRJNA533114_P_NODE_121438_length_240_cov_2.437126_g121186_i0 | PRJNA533114 | 121438 | 240 | 2.437126 | 5.8491024 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.05e-120 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g121186 | i0 | 100 | 100.2875 | 240 | 0 | 100 | 0 | 1 | 240 | 809 | 1048 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 24069 | 444 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 22181673 | 22181673 | PRJNA533114_P_NODE_33138_length_398_cov_2.867692_g32886_i0 | PRJNA533114 | 33138 | 398 | 2.867692 | 11.41341416 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 603 | 8.389999999999997e-168 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g32886 | i0 | 93.97 | 100.542713567839 | 398 | 24 | 100 | 0 | 1 | 398 | 1216 | 1613 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 40016 | 603 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 23457226 | 23457226 | PRJNA533114_P_NODE_36799_length_380_cov_1.504886_g36547_i0 | PRJNA533114 | 36799 | 380 | 1.504886 | 5.7185668 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 680 | 0 | NTclustered | gi|336041394|gb|HQ834950.1| | 188950 | g36547 | i0 | 98.947 | 1 | 380 | 4 | 100 | 0 | 1 | 380 | 1316 | 1695 | Bodomorpha minima strain ATCC 50339 RNA polymerase II largest subunit (Rpb1) gene, partial cds | blastn | 380 | 680 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23457820 | 23457820 | PRJNA533114_P_NODE_85719_length_262_cov_1.947090_g85467_i0 | PRJNA533114 | 85719 | 262 | 1.94709 | 5.1013758 | Massisteria marina | 127229 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 2.1e-92 | NTclustered | gi|300676725|gb|GQ377649.1| | 127229 | g85467 | i0 | 90.84 | 97.2519083969466 | 262 | 24 | 100 | 0 | 1 | 262 | 235 | 496 | Massisteria marina alpha-tubulin (Atub) gene, partial cds | blastn | 25480 | 351 | 1 | Eukaryota | Sar | Cercozoa | Massisteriidae | Massisteria | Massisteria 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);;