contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192465 | 192465 | PRJNA1078753_P_NODE_19721_length_279_cov_2.485437_g19525_i0 | PRJNA1078753 | 19721 | 279 | 2.485437 | 6.93436923 | Thaumatomonas seravini | 188939 | SAR_Eukaryotes | SAR_Eukaryotes | 505 | 1.6399999999999995e-138 | NTclustered | gi|161015724|gb|EF681958.1| | 188939 | g19525 | i0 | 99.286 | 100.272401433692 | 280 | 1 | 100 | 1 | 1 | 279 | 711 | 990 | Thaumatomonas seravini strain HFCC58 28S ribosomal RNA gene, partial sequence | blastn | 27976 | 505 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas seravini | ||
| 192553 | 192553 | PRJNA1078753_P_NODE_31361_length_248_cov_5.274286_g31165_i0 | PRJNA1078753 | 31361 | 248 | 5.274286 | 13.08022928 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 4.59e-39 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g31165 | i0 | 80.081 | 23.5120967741935 | 246 | 40 | 99 | 8 | 1 | 246 | 3764 | 4000 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 5831 | 174 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 4019008 | 4019008 | PRJNA1078753_P_NODE_15504_length_302_cov_3.161572_g15308_i0 | PRJNA1078753 | 15504 | 302 | 3.161572 | 9.54794744 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 492 | 1.4e-134 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g15308 | i0 | 96.053 | 102.284768211921 | 304 | 9 | 100 | 2 | 1 | 302 | 2480 | 2782 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 30890 | 492 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 5295514 | 5295514 | PRJNA1078753_P_NODE_8305_length_380_cov_10.312704_g8109_i0 | PRJNA1078753 | 8305 | 380 | 10.312704 | 39.1882752 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 5.189999999999999e-110 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g8109 | i0 | 87.234 | 54.9473684210526 | 376 | 28 | 98 | 11 | 9 | 380 | 4018 | 3659 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20880 | 411 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 10395999 | 10395999 | PRJNA1078753_P_NODE_5209_length_461_cov_3.610825_g5013_i0 | PRJNA1078753 | 5209 | 461 | 3.610825 | 16.64590325 | Cholamonas cyrtodiopsidis | 507873 | SAR_Eukaryotes | SAR_Eukaryotes | 398 | 4.989999999999998e-106 | NTclustered | gi|238617578|gb|FJ973424.1| | 507873 | g5013 | i0 | 82.353 | 94.9132321041215 | 459 | 79 | 99 | 2 | 4 | 461 | 463 | 920 | Cholamonas cyrtodiopsidis strain ATCC 50325 beta-tubulin (btub) gene, partial cds | blastn | 43755 | 398 | 1 | Eukaryota | Sar | Cercozoa | Sainouridae | Cholamonas | Cholamonas cyrtodiopsidis | ||||
| 11671321 | 11671321 | PRJNA1078753_P_NODE_37410_length_245_cov_0.895349_g37214_i0 | PRJNA1078753 | 37410 | 245 | 0.895349 | 2.19360505 | Cercomonas sp. C59 | 372078 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 7.249999999999999e-67 | NTclustered | gi|88792584|gb|DQ386165.1| | 372078 | g37214 | i0 | 86.531 | 42.4285714285714 | 245 | 29 | 99 | 3 | 1 | 244 | 1993 | 2234 | Cercomonas sp. C59 28S ribosomal RNA gene, partial sequence | blastn | 10395 | 267 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. C59 | |||
| 11671363 | 11671363 | PRJNA1078753_P_NODE_4170_length_505_cov_1.067130_g3974_i0 | PRJNA1078753 | 4170 | 505 | 1.06713 | 5.3890065 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 1.23e-77 | NTclustered | gi|193875699|gb|EU812202.1| | 407209 | g3974 | i0 | 81.644 | 57.2 | 365 | 67 | 72 | 0 | 141 | 505 | 4 | 368 | Thaumatomonas sp. TMT002 clone tshsp70-1 70 kDa heat shock protein mRNA, partial cds | blastn | 28886 | 303 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 12946179 | 12946179 | PRJNA1078753_P_NODE_10231_length_352_cov_12.315412_g10035_i0 | PRJNA1078753 | 10231 | 352 | 12.315412 | 43.35025024 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 3.9799999999999995e-56 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g10035 | i0 | 90.805 | 57.5568181818182 | 174 | 14 | 49 | 2 | 1 | 172 | 3665 | 3838 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20260 | 231 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 12946475 | 12946475 | PRJNA1078753_P_NODE_7571_length_394_cov_3.392523_g7375_i0 | PRJNA1078753 | 7571 | 394 | 3.392523 | 13.36654062 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 719 | 0 | NTclustered | gi|116222192|gb|DQ980477.1| | 407209 | g7375 | i0 | 99.495 | 65.8248730964467 | 396 | 0 | 100 | 2 | 1 | 394 | 1907 | 2302 | Thaumatomonas sp. TMT002 large subunit ribosomal RNA gene, partial sequence | blastn | 25935 | 719 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 15044662 | 15044662 | PRJNA1078753_P_NODE_4172_length_504_cov_8.914153_g3976_i0 | PRJNA1078753 | 4172 | 504 | 8.914153 | 44.92733112 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 800 | 0 | NTclustered | gi|319659368|gb|GU320605.1| | 943207 | g3976 | i0 | 95.635 | 98.9523809523809 | 504 | 13 | 100 | 5 | 1 | 504 | 1808 | 1314 | Reticulamoeba sp. COHH 9 18S ribosomal RNA gene, partial sequence | blastn | 49872 | 800 | 1 | Eukaryota | Sar | Cercozoa | Reticulamoeba | Reticulamoeba sp. COHH 9 | |||||
| 16769565 | 16769565 | PRJNA1078753_P_NODE_3174_length_565_cov_2.386179_g2981_i0 | PRJNA1078753 | 3174 | 565 | 2.386179 | 13.48191135 | Cercomonas sp. ATCC 50316 | 45110 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 3.87e-78 | NTclustered | gi|27734378|gb|AY099144.1| | 45110 | g2981 | i0 | 91.781 | 108.869026548673 | 219 | 18 | 39 | 0 | 68 | 286 | 209 | 427 | Cercomonas ATCC50316 isolate pub6 polyubiquitin gene, partial cds | blastn | 61511 | 305 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. ATCC 50316 | |||
| 18044241 | 18044241 | PRJNA1078753_P_NODE_16675_length_294_cov_1.330317_g16479_i0 | PRJNA1078753 | 16675 | 294 | 1.330317 | 3.91113198 | Phytocercomonas venanatans | 2065209 | SAR_Eukaryotes | SAR_Eukaryotes | 353 | 6.68e-93 | NTclustered | gi|1315527746|gb|MF034898.1| | 2065209 | g16479 | i0 | 88.699 | 99.2380952380952 | 292 | 29 | 99 | 3 | 3 | 292 | 1010 | 1299 | Phytocercomonas venanatans actin gene, complete cds | blastn | 29176 | 353 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Phytocercomonas | Phytocercomonas venanatans | |||
| 19318192 | 19318192 | PRJNA1078753_P_NODE_18076_length_286_cov_3.929577_g17880_i0 | PRJNA1078753 | 18076 | 286 | 3.929577 | 11.23859022 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 512 | 1.01e-140 | NTclustered | gi|116222192|gb|DQ980477.1| | 407209 | g17880 | i0 | 98.951 | 60.7167832167832 | 286 | 3 | 100 | 0 | 1 | 286 | 2887 | 2602 | Thaumatomonas sp. TMT002 large subunit ribosomal RNA gene, partial sequence | blastn | 17365 | 512 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 20593592 | 20593592 | PRJNA1078753_P_NODE_2557_length_622_cov_2.701275_g2366_i0 | PRJNA1078753 | 2557 | 622 | 2.701275 | 16.8019305 | Cercomonas sp. HFCC53 | 458867 | SAR_Eukaryotes | SAR_Eukaryotes | 1144 | 0 | NTclustered | gi|161015705|gb|EF681939.1| | 458867 | g2366 | i0 | 99.839 | 57.4823151125402 | 622 | 1 | 100 | 0 | 1 | 622 | 204 | 825 | Cercomonas sp. HFCC53 28S ribosomal RNA gene, partial sequence | blastn | 35754 | 1144 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC53 | |||
| 20593740 | 20593740 | PRJNA1078753_P_NODE_5977_length_435_cov_1.795580_g5781_i0 | PRJNA1078753 | 5977 | 435 | 1.79558 | 7.810773 | Thaumatomastix sp. NIES-2378 | 717846 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 6.23e-85 | NTclustered | gi|302563030|dbj|AB546338.1| | 717846 | g5781 | i0 | 81.39 | 0.926436781609195 | 403 | 65 | 91 | 8 | 38 | 435 | 1131 | 734 | Thaumatomastix sp. NIES-2378 EFL mRNA for elongation factor like, partial cds | blastn | 403 | 327 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. NIES-2378 |
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);;