contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA909412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 890668 | 890668 | PRJNA909412_P_NODE_2601_length_329_cov_24.462069_g2461_i0 | PRJNA909412 | 2601 | 329 | 24.462069 | 80.48020701 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 3.76e-46 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g2461 | i0 | 79.933 | 28.7173252279635 | 299 | 36 | 90 | 16 | 34 | 329 | 4039 | 3762 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 9448 | 198 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 11094227 | 11094227 | PRJNA909412_P_NODE_11769_length_166_cov_3.236220_g11628_i0 | PRJNA909412 | 11769 | 166 | 3.23622 | 5.3721252 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.69e-79 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g11628 | i0 | 100 | 100.777108433735 | 166 | 0 | 100 | 0 | 1 | 166 | 826 | 991 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 16729 | 307 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 12369802 | 12369802 | PRJNA909412_P_NODE_1910_length_392_cov_4.291785_g1770_i0 | PRJNA909412 | 1910 | 392 | 4.291785 | 16.8237972 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 719 | 0 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g1770 | i0 | 99.745 | 37.2678571428571 | 392 | 1 | 100 | 0 | 1 | 392 | 634 | 243 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 14609 | 719 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 13644342 | 13644342 | PRJNA909412_P_NODE_4631_length_242_cov_6.384236_g4490_i0 | PRJNA909412 | 4631 | 242 | 6.384236 | 15.44985112 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.11e-114 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g4490 | i0 | 98.347 | 99.3223140495868 | 242 | 4 | 100 | 0 | 1 | 242 | 648 | 889 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 24036 | 425 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 17468972 | 17468972 | PRJNA909412_P_NODE_2034_length_378_cov_5.277286_g1894_i0 | PRJNA909412 | 2034 | 378 | 5.277286 | 19.94814108 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 684 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g1894 | i0 | 99.211 | 85.7592592592593 | 380 | 1 | 100 | 1 | 1 | 378 | 2111 | 1732 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 32417 | 684 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 17469014 | 17469014 | PRJNA909412_P_NODE_94_length_1535_cov_8.555481_g71_i0 | PRJNA909412 | 94 | 1535 | 8.555481 | 131.32663335 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1491 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g71 | i0 | 98.805 | 73.0332247557003 | 837 | 10 | 55 | 0 | 426 | 1262 | 837 | 1 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 112106 | 1491 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 21292614 | 21292614 | PRJNA909412_P_NODE_5397_length_224_cov_2.437838_g5256_i0 | PRJNA909412 | 5397 | 224 | 2.437838 | 5.46075712 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 414 | 2.1999999999999996e-111 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g5256 | i0 | 100 | 19.8214285714286 | 224 | 0 | 100 | 0 | 1 | 224 | 253 | 476 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 4440 | 414 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23842893 | 23842893 | PRJNA909412_P_NODE_1439_length_458_cov_9.269690_g1300_i0 | PRJNA909412 | 1439 | 458 | 9.26969 | 42.4551802 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 846 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g1300 | i0 | 100 | 19.1310043668122 | 458 | 0 | 100 | 0 | 1 | 458 | 347 | 804 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 8762 | 846 | 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);;