contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA407886" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 417484 | 417484 | PRJNA407886_P_NODE_47221_length_314_cov_2.556017_g45527_i0 | PRJNA407886 | 47221 | 314 | 2.556017 | 8.02589338 | Amorphochlora amoebiformis | 1561963 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 2.88e-17 | NTclustered | gi|226427122|gb|FJ209028.1| | 1561963 | g45527 | i0 | 84.404 | 3.47452229299363 | 109 | 12 | 34 | 5 | 207 | 313 | 893 | 788 | Lotharella amoeboformis calreticulin mRNA, complete cds | blastn | 1091 | 102 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Amorphochlora | Amorphochlora amoebiformis | ||||
| 417835 | 417835 | PRJNA407886_P_NODE_64141_length_263_cov_3.242105_g62447_i0 | PRJNA407886 | 64141 | 263 | 3.242105 | 8.52673615 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 457 | 4.35e-124 | NTclustered | gi|48727795|gb|AY620285.1| | 175275 | g62447 | i0 | 98.099 | 98.509505703422107 | 263 | 4 | 100 | 1 | 1 | 263 | 104 | 365 | Uncultured cercozoan clone 4-5.2 small subunit ribosomal RNA gene, partial sequence | blastn | 25908 | 457 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 4910216 | 4910216 | PRJNA407886_P_NODE_42644_length_333_cov_2.615385_g40950_i0 | PRJNA407886 | 42644 | 333 | 2.615385 | 8.70923205 | Paulinella | 39716 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 2.14e-93 | NTclustered | gi|224549833|gb|FJ456915.1| | 39717 | g40950 | i0 | 86.916 | 93.5075075075075 | 321 | 36 | 95 | 5 | 16 | 333 | 841 | 524 | Paulinella chromatophora strain FK01 actin gene, partial cds | blastn | 31138 | 357 | 0.994397759103641 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 5520615 | 5520615 | PRJNA407886_P_NODE_14465_length_740_cov_2.287856_g12890_i0 | PRJNA407886 | 14465 | 740 | 2.287856 | 16.9301344 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 808 | 0 | NTclustered | gi|238617666|gb|FJ973412.1| | 188950 | g12890 | i0 | 86.926 | 98.8972972972973 | 719 | 94 | 97 | 0 | 2 | 720 | 719 | 1 | Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds | blastn | 73184 | 808 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 7460599 | 7460599 | PRJNA407886_P_NODE_84106_length_208_cov_4.340741_g82412_i0 | PRJNA407886 | 84106 | 208 | 4.340741 | 9.02874128 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 89.8 | 1.39e-13 | NTclustered | gi|220983376|dbj|AB453012.1| | 552662 | g82412 | i0 | 100 | 24.3317307692308 | 48 | 0 | 23 | 0 | 161 | 208 | 2311 | 2358 | Cercozoa sp. YPF501 gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 5061 | 89.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. YPF501 | ||||||
| 8070620 | 8070620 | PRJNA407886_P_NODE_38527_length_354_cov_5.042705_g36833_i0 | PRJNA407886 | 38527 | 354 | 5.042705 | 17.8511757 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 6.660000000000001e-59 | NTclustered | gi|300676723|gb|GQ377712.1| | 323453 | g36833 | i0 | 79.758 | 1.05932203389831 | 331 | 67 | 94 | 0 | 22 | 352 | 369 | 699 | Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds | blastn | 375 | 241 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 9346325 | 9346325 | PRJNA407886_P_NODE_82388_length_239_cov_2.759036_g80694_i0 | PRJNA407886 | 82388 | 239 | 2.759036 | 6.59409604 | Thaumatomonas seravini | 188939 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.1599999999999999e-74 | NTclustered | gi|160337402|gb|EF455799.1| | 188939 | g80694 | i0 | 88.703 | 93.9623430962343 | 239 | 27 | 100 | 0 | 1 | 239 | 32 | 270 | Thaumatomonas seravini beta-tubulin (btub) gene, partial cds | blastn | 22457 | 292 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas seravini | ||
| 11895999 | 11895999 | PRJNA407886_P_NODE_30090_length_417_cov_2.494186_g28397_i0 | PRJNA407886 | 30090 | 417 | 2.494186 | 10.40075562 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 4.9e-41 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g28397 | i0 | 88.667 | 2.5347721822542 | 150 | 15 | 36 | 2 | 6 | 154 | 3695 | 3843 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 1057 | 182 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 13171216 | 13171216 | PRJNA407886_P_NODE_45251_length_322_cov_2.682731_g43557_i0 | PRJNA407886 | 45251 | 322 | 2.682731 | 8.63839382 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 3.77e-26 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g43557 | i0 | 97.403 | 17.7515527950311 | 77 | 2 | 46 | 0 | 3 | 79 | 3763 | 3839 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 5716 | 132 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 16994890 | 16994890 | PRJNA407886_P_NODE_41734_length_337_cov_4.719697_g40040_i0 | PRJNA407886 | 41734 | 337 | 4.719697 | 15.90537889 | Bodomorpha sp. HFCC55 | 624126 | SAR_Eukaryotes | SAR_Eukaryotes | 606 | 5.409999999999998e-169 | NTclustered | gi|225216790|gb|FJ176705.1| | 624126 | g40040 | i0 | 99.11 | 1.99406528189911 | 337 | 3 | 100 | 0 | 1 | 337 | 719 | 383 | Bodomorpha sp. 28S ribosomal RNA gene, partial sequence | blastn | 672 | 606 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC55 | |||
| 16995698 | 16995698 | PRJNA407886_P_NODE_83434_length_229_cov_5.884615_g81740_i0 | PRJNA407886 | 83434 | 229 | 5.884615 | 13.47576835 | Cryothecomonas sp. APCC MC5-1Cryo | 741088 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.51e-33 | NTclustered | gi|290760480|gb|GQ144683.1| | 741088 | g81740 | i0 | 79.399 | 32.2445414847162 | 233 | 38 | 100 | 8 | 1 | 229 | 2019 | 2245 | Cryothecomonas sp. APCC MC5-1Cryo large subunit ribosomal RNA gene, partial sequence | blastn | 7384 | 156 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Cryomonadida | Protaspidae | Cryothecomonas | Cryothecomonas sp. APCC MC5-1Cryo | ||
| 16995701 | 16995701 | PRJNA407886_P_NODE_83694_length_227_cov_2.831169_g82000_i0 | PRJNA407886 | 83694 | 227 | 2.831169 | 6.42675363 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.13e-49 | NTclustered | gi|300676723|gb|GQ377712.1| | 323453 | g82000 | i0 | 83.26 | 1 | 227 | 38 | 100 | 0 | 1 | 227 | 570 | 796 | Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds | blastn | 227 | 209 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 19542954 | 19542954 | PRJNA407886_P_NODE_30196_length_416_cov_2.591837_g28503_i0 | PRJNA407886 | 30196 | 416 | 2.591837 | 10.78204192 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 721 | 0 | NTclustered | gi|48727871|gb|AY620361.1| | 175275 | g28503 | i0 | 97.852 | 93.1538461538462 | 419 | 5 | 100 | 3 | 1 | 416 | 1121 | 704 | Uncultured cercozoan clone 7-3.4 small subunit ribosomal RNA gene, partial sequence | blastn | 38752 | 721 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 22094617 | 22094617 | PRJNA407886_P_NODE_80958_length_241_cov_2.255952_g79264_i0 | PRJNA407886 | 80958 | 241 | 2.255952 | 5.43684432 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.23e-39 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g79264 | i0 | 81.301 | 41.49377593361 | 246 | 20 | 100 | 12 | 1 | 241 | 2721 | 2945 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 10000 | 176 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 22759125 | 22759125 | PRJNA407886_P_NODE_39858_length_347_cov_2.149635_g38164_i0 | PRJNA407886 | 39858 | 347 | 2.149635 | 7.45923345 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 636 | 7.13e-178 | NTclustered | gi|82547952|gb|DQ211594.1| | 188950 | g38164 | i0 | 99.712 | 97.4063400576369 | 347 | 1 | 100 | 0 | 1 | 347 | 1009 | 663 | Bodomorpha minima strain HFCC55 18S ribosomal RNA gene, partial sequence | blastn | 33800 | 636 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima |
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);;