contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJEB76780" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138660 | 138660 | PRJEB76780_P_NODE_10521_length_252_cov_1.307263_g10421_i0 | PRJEB76780 | 10521 | 252 | 1.307263 | 3.29430276 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 1.65e-53 | NTclustered | gi|193875699|gb|EU812202.1| | 407209 | g10421 | i0 | 83.333 | 69.1428571428571 | 246 | 35 | 96 | 6 | 1 | 243 | 317 | 75 | Thaumatomonas sp. TMT002 clone tshsp70-1 70 kDa heat shock protein mRNA, partial cds | blastn | 17424 | 222 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 1413374 | 1413374 | PRJEB76780_P_NODE_13442_length_242_cov_0.923077_g13342_i0 | PRJEB76780 | 13442 | 242 | 0.923077 | 2.23384634 | Sterkiella nova | 200597 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 2.68e-36 | NTclustered | gi|1051275|gb|U37280.1|ONU37280 | 200597 | g13342 | i0 | 81.068 | 5.45867768595041 | 206 | 39 | 85 | 0 | 27 | 232 | 1602 | 1807 | Oxytricha nova Hsp70 gene, complete cds | blastn | 1321 | 165 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella nova | ||
| 3547018 | 3547018 | PRJEB76780_P_NODE_7783_length_290_cov_0.903226_g7683_i0 | PRJEB76780 | 7783 | 290 | 0.903226 | 2.6193554 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 536 | 6.079999999999999e-148 | NTclustered | gi|219524870|gb|EU709233.1| | 175275 | g7683 | i0 | 100 | 99.0068965517241 | 290 | 0 | 100 | 0 | 1 | 290 | 810 | 521 | Uncultured cercozoan isolate HetPan13 18S ribosomal RNA gene, partial sequence | blastn | 28712 | 536 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 3964944 | 3964944 | PRJEB76780_P_NODE_6844_length_308_cov_1.527660_g6744_i0 | PRJEB76780 | 6844 | 308 | 1.52766 | 4.7051928 | Thaumatomonas seravini | 188939 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 1.5e-99 | NTclustered | gi|160337402|gb|EF455799.1| | 188939 | g6744 | i0 | 88.636 | 98.8506493506493 | 308 | 35 | 100 | 0 | 1 | 308 | 273 | 580 | Thaumatomonas seravini beta-tubulin (btub) gene, partial cds | blastn | 30446 | 375 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas seravini | ||
| 5241347 | 5241347 | PRJEB76780_P_NODE_2645_length_504_cov_3.361949_g2545_i0 | PRJEB76780 | 2645 | 504 | 3.361949 | 16.94422296 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.014 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g2545 | i0 | 100 | 0.0575396825396825 | 29 | 0 | 6 | 0 | 474 | 502 | 1789 | 1761 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 5241354 | 5241354 | PRJEB76780_P_NODE_3785_length_419_cov_1.578035_g3685_i0 | PRJEB76780 | 3785 | 419 | 1.578035 | 6.61196665 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.011 | NTclustered | gi|921118745|ref|XM_013578538.1| | 51315 | g3685 | i0 | 94.286 | 0.217183770883055 | 35 | 2 | 8 | 0 | 204 | 238 | 535 | 569 | Eimeria necatrix 5'-3' exoribonuclease 2, related partial mRNA | blastn | 91 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 5241358 | 5241358 | PRJEB76780_P_NODE_3905_length_412_cov_1.643068_g3805_i0 | PRJEB76780 | 3905 | 412 | 1.643068 | 6.76944016 | Lithodesmioides sp. mgcode 4 | 2914905 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1.77e-30 | NTclustered | gi|2073953334|gb|MW849271.1| | 2914905 | g3805 | i0 | 78.298 | 1.9126213592233 | 235 | 45 | 57 | 5 | 68 | 301 | 26938 | 27167 | Lithodesmioides sp. mgcode 4 isolate Qingdao in China mitochondrion, complete genome | blastn | 788 | 147 | 1 | Eukaryota | Sar | Bacillariophyta | Mediophyceae | Lithodesmiales | Lithodesmiaceae | Lithodesmioides | Lithodesmioides sp. mgcode 4 | ||
| 6099583 | 6099583 | PRJEB76780_P_NODE_10905_length_251_cov_0.876404_g10805_i0 | PRJEB76780 | 10905 | 251 | 0.876404 | 2.19977404 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 9.58e-71 | NTclustered | gi|27734360|gb|AY099135.1| | 188952 | g10805 | i0 | 86.905 | 219.466135458167 | 252 | 30 | 99 | 1 | 1 | 249 | 346 | 95 | Cercomonas edax isolate pub7 polyubiquitin gene, partial cds | blastn | 55086 | 279 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas edax | |||
| 7791030 | 7791030 | PRJEB76780_P_NODE_3207_length_456_cov_1.817232_g3107_i0 | PRJEB76780 | 3207 | 456 | 1.817232 | 8.28657792 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 1.88e-65 | NTclustered | gi|695437469|ref|XM_009533931.1| | 67593 | g3107 | i0 | 80.056 | 16.9978070175439 | 356 | 69 | 78 | 2 | 21 | 375 | 562 | 916 | Phytophthora sojae hypothetical protein mRNA | blastn | 7751 | 263 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 12475364 | 12475364 | PRJEB76780_P_NODE_7430_length_296_cov_1.748879_g7330_i0 | PRJEB76780 | 7430 | 296 | 1.748879 | 5.17668184 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 1.2e-45 | NTclustered | gi|85822972|gb|DQ356652.1| | 87106 | g7330 | i0 | 83.333 | 82.4527027027027 | 216 | 32 | 72 | 4 | 11 | 224 | 481 | 268 | Thraustochytrium striatum elongation factor 1-alpha gene, partial cds | blastn | 24406 | 196 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Thraustochytrium | Thraustochytrium striatum | |||
| 14167075 | 14167075 | PRJEB76780_P_NODE_10292_length_253_cov_0.866667_g10192_i0 | PRJEB76780 | 10292 | 253 | 0.866667 | 2.19266751 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.37e-4 | NTclustered | gi|820696962|tpe|LN714494.1| | 432359 | g10192 | i0 | 90.909 | 2.22134387351779 | 44 | 4 | 17 | 0 | 32 | 75 | 1619412 | 1619369 | TPA_asm: Toxoplasma gondii VEG, chromosome chrV, complete genome | blastn | 562 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 14167114 | 14167114 | PRJEB76780_P_NODE_1872_length_607_cov_7.205993_g1773_i0 | PRJEB76780 | 1872 | 607 | 7.205993 | 43.74037751 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 3.119999999999999e-104 | NTclustered | gi|294933094|ref|XM_002780549.1| | 423536 | g1773 | i0 | 81.876 | 32.668863261944 | 469 | 81 | 77 | 4 | 125 | 591 | 128 | 594 | Perkinsus marinus ATCC 50983 40S ribosomal protein S5, putative, mRNA | blastn | 19830 | 392 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 18848131 | 18848131 | PRJEB76780_P_NODE_2035_length_582_cov_3.772102_g1936_i0 | PRJEB76780 | 2035 | 582 | 3.772102 | 21.95363364 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 5.36e-52 | NTclustered | gi|223047900|gb|FJ032683.1| | 329655 | g1936 | i0 | 86.634 | 45.2714776632302 | 202 | 21 | 51 | 6 | 1 | 199 | 2218 | 2416 | Uncultured marine Polycystinea clone Ma_1A27 28S ribosomal RNA gene, partial sequence | blastn | 26348 | 219 | 1 | Eukaryota | Sar | Polycystinea | uncultured marine Polycystinea | ||||||
| 20539702 | 20539702 | PRJEB76780_P_NODE_2977_length_476_cov_1.156328_g2877_i0 | PRJEB76780 | 2977 | 476 | 1.156328 | 5.50412128 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 664 | 0 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g2877 | i0 | 91.983 | 97.8655462184874 | 474 | 36 | 99 | 2 | 1 | 473 | 1579 | 2051 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 46584 | 664 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 21815536 | 21815536 | PRJEB76780_P_NODE_9458_length_264_cov_1.481675_g9358_i0 | PRJEB76780 | 9458 | 264 | 1.481675 | 3.911622 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1843423058|dbj|LC541869.1| | 5823 | g9358 | i0 | 100 | 0.113636363636364 | 30 | 0 | 11 | 0 | 25 | 54 | 51179 | 51150 | Plasmodium berghei ANKA chromosome 1 telomere region, partial sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 23090680 | 23090680 | PRJEB76780_P_NODE_12839_length_244_cov_0.912281_g12739_i0 | PRJEB76780 | 12839 | 244 | 0.912281 | 2.22596564 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|2795624578|ref|XM_068066319.1| | 483139 | g12739 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 113 | 140 | 3076 | 3103 | Cystoisospora suis transmembrane (CSUI_006155), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis |
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);;