contig_metadata
18 rows where bioproject = "PRJEB11748" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16933 | 16933 | PRJEB11748_P_NODE_253981_length_244_cov_5.601093_g251798_i0 | PRJEB11748 | 253981 | 244 | 5.601093 | 13.66666692 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.24e-44 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g251798 | i0 | 82.533 | 45.5368852459016 | 229 | 30 | 91 | 7 | 22 | 244 | 2721 | 2945 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 11111 | 193 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 1289881 | 1289881 | PRJEB11748_P_NODE_186642_length_295_cov_16.645299_g184459_i0 | PRJEB11748 | 186642 | 295 | 16.645299 | 49.10363205 | Paracercomonas tenuis | 686767 | SAR_Eukaryotes | SAR_Eukaryotes | 497 | 2.9299999999999998e-136 | NTclustered | gi|262262884|gb|FJ797475.1| | 686767 | g184459 | i0 | 99.632 | 38.4779661016949 | 272 | 1 | 92 | 0 | 1 | 272 | 343 | 72 | Paracercomonas tenuis strain SA-S 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 11351 | 497 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas tenuis | |||
| 2259521 | 2259521 | PRJEB11748_P_NODE_309602_length_215_cov_1.993506_g307419_i0 | PRJEB11748 | 309602 | 215 | 1.993506 | 4.2860379 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 7.76e-91 | NTclustered | gi|2493707699|dbj|LC764482.1| | 45107 | g307419 | i0 | 98.964 | 89.8976744186047 | 193 | 2 | 90 | 0 | 23 | 215 | 117 | 309 | Heteromita globosa LAP3-2017 gene for 18S rRNA, partial sequence | blastn | 19328 | 346 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 2564161 | 2564161 | PRJEB11748_P_NODE_122023_length_375_cov_10.044586_g119847_i0 | PRJEB11748 | 122023 | 375 | 10.044586 | 37.6671975 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.9299999999999993e-74 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g119847 | i0 | 82.022 | 94.1386666666667 | 356 | 53 | 93 | 8 | 28 | 375 | 2200 | 2552 | Rosculus vulgaris isolate CCA sequence | blastn | 35302 | 292 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 2569971 | 2569971 | PRJEB11748_P_NODE_75163_length_485_cov_29.492925_g73008_i0 | PRJEB11748 | 75163 | 485 | 29.492925 | 143.04068625 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 534 | 3.85e-147 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g73008 | i0 | 90.418 | 0.839175257731959 | 407 | 37 | 84 | 2 | 2 | 406 | 18144 | 17738 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 407 | 534 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 5122103 | 5122103 | PRJEB11748_P_NODE_61245_length_542_cov_9.338877_g59108_i0 | PRJEB11748 | 61245 | 542 | 9.338877 | 50.61671334 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 405 | 3.55e-108 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g59108 | i0 | 81.132 | 89.3284132841328 | 530 | 78 | 96 | 18 | 1 | 519 | 2170 | 1652 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 48416 | 405 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 6398734 | 6398734 | PRJEB11748_P_NODE_98146_length_422_cov_1.271468_g95976_i0 | PRJEB11748 | 98146 | 422 | 1.271468 | 5.36559496 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 597 | 4.1599999999999986e-166 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g95976 | i0 | 92.199 | 100.796208530806 | 423 | 32 | 100 | 1 | 1 | 422 | 2060 | 1638 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 42536 | 597 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 11493615 | 11493615 | PRJEB11748_P_NODE_186870_length_295_cov_7.025641_g184687_i0 | PRJEB11748 | 186870 | 295 | 7.025641 | 20.72564095 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.19e-50 | NTclustered | gi|2651357801|gb|PP174314.1| | 1979794 | g184687 | i0 | 90.854 | 54.5016949152542 | 164 | 8 | 92 | 5 | 114 | 275 | 3930 | 3772 | Cercomonas sp. isolate P5 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 16078 | 213 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 11497137 | 11497137 | PRJEB11748_P_NODE_389810_length_172_cov_7.423423_g387627_i0 | PRJEB11748 | 389810 | 172 | 7.423423 | 12.76828756 | uncultured Endomyxa | 1821257 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 5.04e-22 | NTclustered | gi|2915662207|gb|PV134975.1| | 1821257 | g387627 | i0 | 87.379 | 24.3953488372093 | 103 | 11 | 59 | 2 | 37 | 138 | 2422 | 2321 | Uncultured Endomyxa isolate IOM_2014_45 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 4196 | 117 | 1 | Eukaryota | Sar | Cercozoa | uncultured Endomyxa | ||||||
| 14042315 | 14042315 | PRJEB11748_P_NODE_121272_length_376_cov_97.987302_g119096_i0 | PRJEB11748 | 121272 | 376 | 97.987302 | 368.43225552 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 592 | 1.71e-164 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g119096 | i0 | 97.151 | 43.1329787234043 | 351 | 8 | 93 | 2 | 17 | 366 | 1943 | 2292 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 16218 | 592 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 15319723 | 15319723 | PRJEB11748_P_NODE_282933_length_228_cov_2.119760_g280750_i0 | PRJEB11748 | 282933 | 228 | 2.11976 | 4.8330528 | Cercomonas sp. C59 | 372078 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 2.45e-51 | NTclustered | gi|88792584|gb|DQ386165.1| | 372078 | g280750 | i0 | 84.932 | 51.3464912280702 | 219 | 26 | 94 | 7 | 15 | 228 | 2084 | 2300 | Cercomonas sp. C59 28S ribosomal RNA gene, partial sequence | blastn | 11707 | 215 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. C59 | |||
| 17866779 | 17866779 | PRJEB11748_P_NODE_157535_length_326_cov_4.373585_g155353_i0 | PRJEB11748 | 157535 | 326 | 4.373585 | 14.2578871 | Cercomonas sp. C59 | 372078 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 1.6199999999999994e-89 | NTclustered | gi|88792584|gb|DQ386165.1| | 372078 | g155353 | i0 | 86.378 | 56.6932515337423 | 323 | 33 | 97 | 10 | 11 | 326 | 2315 | 1997 | Cercomonas sp. C59 28S ribosomal RNA gene, partial sequence | blastn | 18482 | 342 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. C59 | |||
| 19144198 | 19144198 | PRJEB11748_P_NODE_355596_length_195_cov_2.492537_g353413_i0 | PRJEB11748 | 355596 | 195 | 2.492537 | 4.86044715 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 76.8 | 1e-9 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g353413 | i0 | 88.889 | 7.08717948717949 | 63 | 5 | 32 | 2 | 134 | 195 | 1812 | 1873 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 1382 | 76.8 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 20418215 | 20418215 | PRJEB11748_P_NODE_290577_length_224_cov_2.619632_g288394_i0 | PRJEB11748 | 290577 | 224 | 2.619632 | 5.86797568 | Cercozoa sp. 900 | 1215612 | SAR_Eukaryotes | SAR_Eukaryotes | 414 | 2.1999999999999996e-111 | NTclustered | gi|399764281|gb|JQ271792.1| | 1215612 | g288394 | i0 | 100 | 51.5044642857143 | 224 | 0 | 100 | 0 | 1 | 224 | 62 | 285 | Cercozoa sp. 900 18S ribosomal RNA gene, partial sequence | blastn | 11537 | 414 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. 900 | ||||||
| 20418432 | 20418432 | PRJEB11748_P_NODE_302477_length_218_cov_4.343949_g300294_i0 | PRJEB11748 | 302477 | 218 | 4.343949 | 9.46980882 | Eocercomonas perecta | 1043734 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.73e-77 | NTclustered | gi|336245462|gb|HM536153.1| | 1043734 | g300294 | i0 | 93.689 | 90.7981651376147 | 206 | 5 | 91 | 5 | 21 | 218 | 282 | 487 | Eocercomonas perecta strain HFCC 908 18S ribosomal RNA gene, partial sequence | blastn | 19794 | 302 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Eocercomonas | Eocercomonas perecta | |||
| 21694929 | 21694929 | PRJEB11748_P_NODE_327598_length_207_cov_3.787671_g325415_i0 | PRJEB11748 | 327598 | 207 | 3.787671 | 7.84047897 | Cercomonas sp. HFCC500 | 458865 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.76e-22 | NTclustered | gi|161015654|gb|EF666119.1| | 458865 | g325415 | i0 | 95.946 | 0.714975845410628 | 74 | 1 | 35 | 1 | 113 | 184 | 112 | 39 | Cercomonas sp. HFCC500 28S ribosomal RNA gene, partial sequence | blastn | 148 | 119 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC500 | |||
| 24244634 | 24244634 | PRJEB11748_P_NODE_362560_length_191_cov_5.315385_g360377_i0 | PRJEB11748 | 362560 | 191 | 5.315385 | 10.15238535 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 3.2400000000000005e-64 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g360377 | i0 | 95.122 | 102.858638743456 | 164 | 7 | 86 | 1 | 17 | 180 | 3830 | 3668 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 19646 | 257 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 30664849 | 30664849 | PRJEB11748_P_NODE_358053_length_193_cov_13.878788_g355870_i0 | PRJEB11748 | 358053 | 193 | 13.878788 | 26.78606084 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 5.05e-16 | NR | YP_009118053.1 | 372086 | g355870 | i0 | 100 | 0.637305699481865 | 41 | 0 | 63.7 | 0 | 70 | 192 | 1 | 41 | YP_009118053.1 ATP synthase F0 subunit c [Paracercomonas marina] | diamond | 123 | 75.1 | 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);;