contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA379145" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 401103 | 401103 | PRJNA379145_P_NODE_57741_length_197_cov_3.371951_g55587_i0 | PRJNA379145 | 57741 | 197 | 3.371951 | 6.64274347 | Paulinella chromatophora | 39717 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 7.55e-36 | NTclustered | gi|302563026|dbj|AB546336.1| | 39717 | g55587 | i0 | 83.616 | 83.258883248731 | 177 | 25 | 89 | 4 | 3 | 177 | 528 | 354 | Paulinella chromatophora EF-1a mRNA for elongation factor 1alpha, partial cds | blastn | 16402 | 163 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 1074072 | 1074072 | PRJNA379145_P_NODE_48441_length_242_cov_2.081340_g46287_i0 | PRJNA379145 | 48441 | 242 | 2.08134 | 5.0368428 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 5.889999999999999e-23 | NTclustered | gi|224549835|gb|FJ456916.1| | 39717 | g46287 | i0 | 87.5 | 21.1652892561983 | 104 | 13 | 43 | 0 | 139 | 242 | 771 | 668 | Paulinella chromatophora strain M0880/a actin gene, partial cds | blastn | 5122 | 122 | 0.991803278688525 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 1074113 | 1074113 | PRJNA379145_P_NODE_72081_length_154_cov_3.669421_g69926_i0 | PRJNA379145 | 72081 | 154 | 3.669421 | 5.65090834 | Guttulinopsis | 1144921 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 1.14e-72 | NTclustered | gi|1402550487|gb|MH488773.1| | 2231167 | g69926 | i0 | 100 | 25.3636363636364 | 154 | 0 | 100 | 0 | 1 | 154 | 1355 | 1202 | Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence | blastn | 3906 | 285 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis sp. | ||||
| 1675306 | 1675306 | PRJNA379145_P_NODE_18742_length_626_cov_6.347386_g16925_i0 | PRJNA379145 | 18742 | 626 | 6.347386 | 39.73463636 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 1120 | 0 | NTclustered | gi|1402550485|gb|MH488771.1| | 2231170 | g16925 | i0 | 99.042 | 18.3929712460064 | 626 | 3 | 100 | 2 | 1 | 626 | 643 | 21 | Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 11514 | 1120 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 1675709 | 1675709 | PRJNA379145_P_NODE_53942_length_213_cov_2.027778_g51788_i0 | PRJNA379145 | 53942 | 213 | 2.027778 | 4.31916714 | Cercomonas sp. HFCC549 | 458874 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 1.27e-98 | NTclustered | gi|161015714|gb|EF681948.1| | 458874 | g51788 | i0 | 98.122 | 13.4084507042254 | 213 | 4 | 100 | 0 | 1 | 213 | 333 | 545 | Cercomonas sp. HFCC549 28S ribosomal RNA gene, partial sequence | blastn | 2856 | 372 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC549 | |||
| 2951703 | 2951703 | PRJNA379145_P_NODE_6103_length_1229_cov_2.887124_g5359_i0 | PRJNA379145 | 6103 | 1229 | 2.887124 | 35.48275396 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 527 | 1.7099999999999993e-144 | NTclustered | gi|116222176|gb|DQ980464.1| | 407209 | g5359 | i0 | 83.247 | 40.4849471114727 | 579 | 91 | 47 | 6 | 654 | 1229 | 1051 | 476 | Thaumatomonas sp. TMT002 Hsp90 mRNA, partial cds | blastn | 49756 | 527 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 7451973 | 7451973 | PRJNA379145_P_NODE_48066_length_244_cov_27.890995_g45913_i0 | PRJNA379145 | 48066 | 244 | 27.890995 | 68.0540278 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 398 | 2.4499999999999996e-106 | NTclustered | gi|512134091|gb|KC575315.1| | 175275 | g45913 | i0 | 95.935 | 101.368852459016 | 246 | 8 | 100 | 2 | 1 | 244 | 141 | 386 | Uncultured cercozoan clone A.3.2 18S ribosomal RNA gene, partial sequence | blastn | 24734 | 398 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 8053935 | 8053935 | PRJNA379145_P_NODE_23367_length_525_cov_4.772358_g21384_i0 | PRJNA379145 | 23367 | 525 | 4.772358 | 25.0548795 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 811 | 0 | NTclustered | gi|1402550488|gb|MH488774.1| | 2231170 | g21384 | i0 | 94.857 | 36.8361904761905 | 525 | 17 | 100 | 5 | 1 | 525 | 1500 | 2014 | Guttulinopsis rogosa isolate FOLDEDA sequence | blastn | 19339 | 811 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 9328697 | 9328697 | PRJNA379145_P_NODE_16628_length_683_cov_3.635385_g14920_i0 | PRJNA379145 | 16628 | 683 | 3.635385 | 24.82967955 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.005 | NTclustered | gi|116222178|gb|DQ980465.1| | 407209 | g14920 | i0 | 100 | 0.133235724743777 | 30 | 0 | 4 | 0 | 303 | 332 | 681 | 652 | Thaumatomonas sp. TMT002 Hsp90 mRNA, partial cds | blastn | 91 | 56.5 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 15703471 | 15703471 | PRJNA379145_P_NODE_29253_length_427_cov_2.979695_g27148_i0 | PRJNA379145 | 29253 | 427 | 2.979695 | 12.72329765 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 7.57e-114 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g27148 | i0 | 84.579 | 98.7236533957845 | 428 | 64 | 100 | 2 | 1 | 427 | 668 | 242 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 42155 | 424 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 18252776 | 18252776 | PRJNA379145_P_NODE_68355_length_163_cov_3.546154_g66201_i0 | PRJNA379145 | 68355 | 163 | 3.546154 | 5.78023102 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 9.72e-59 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g66201 | i0 | 93.21 | 100.288343558282 | 162 | 11 | 99 | 0 | 1 | 162 | 1025 | 1186 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 16347 | 239 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 23352654 | 23352654 | PRJNA379145_P_NODE_21719_length_557_cov_4.637405_g19787_i0 | PRJNA379145 | 21719 | 557 | 4.637405 | 25.83034585 | Guttulinopsis sp. | 2231167 | SAR_Eukaryotes | SAR_Eukaryotes | 832 | 0 | NTclustered | gi|1402550487|gb|MH488773.1| | 2231167 | g19787 | i0 | 94.118 | 22.0071813285458 | 561 | 10 | 99 | 14 | 1 | 556 | 1190 | 648 | Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence | blastn | 12258 | 832 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis sp. | ||||
| 25300181 | 25300181 | PRJNA379145_P_NODE_18820_length_624_cov_7.725888_g16999_i0 | PRJNA379145 | 18820 | 624 | 7.725888 | 48.20954112 | Colponemidia | 1492816 | SAR_Eukaryotes | SAR_Eukaryotes | 754 | 0 | NTclustered | gi|238617670|gb|FJ973414.1| | 646463 | g16999 | i0 | 88.462 | 99.5272435897436 | 624 | 72 | 100 | 0 | 1 | 624 | 842 | 219 | Gymnophrys sp. ATCC 50923 alpha-tubulin (atub) gene, partial cds | blastn | 62105 | 754 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 |
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);;