contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA564810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 554096 | 554096 | PRJNA564810_S_NODE_8761_length_197_cov_6.712121_g8739_i0 | PRJNA564810 | 8761 | 197 | 6.712121 | 13.22287837 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 1.929999999999999e-96 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g8739 | i0 | 100 | 68.0964467005076 | 197 | 0 | 100 | 0 | 1 | 197 | 1493 | 1689 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 13415 | 364 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 13308239 | 13308239 | PRJNA564810_S_NODE_7071_length_222_cov_2.248408_g7049_i0 | PRJNA564810 | 7071 | 222 | 2.248408 | 4.99146576 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 2.8199999999999996e-110 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g7049 | i0 | 100 | 25.7297297297297 | 222 | 0 | 100 | 0 | 1 | 222 | 2171 | 2392 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 5712 | 411 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15856861 | 15856861 | PRJNA564810_S_NODE_713_length_446_cov_16.049869_g691_i0 | PRJNA564810 | 713 | 446 | 16.049869 | 71.58241574 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 3.85e-82 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g691 | i0 | 82.642 | 46.0493273542601 | 386 | 42 | 86 | 17 | 64 | 446 | 4039 | 3676 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20538 | 318 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 20260047 | 20260047 | PRJNA564810_S_NODE_996_length_404_cov_16.306785_g974_i0 | PRJNA564810 | 996 | 404 | 16.306785 | 65.8794114 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 747 | 0 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g974 | i0 | 100 | 100.44801980198 | 404 | 0 | 100 | 0 | 1 | 404 | 1028 | 625 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 40581 | 747 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 20956287 | 20956287 | PRJNA564810_S_NODE_8097_length_211_cov_2.232877_g8075_i0 | PRJNA564810 | 8097 | 211 | 2.232877 | 4.71137047 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 385 | 1.61e-102 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g8075 | i0 | 99.526 | 67.9952606635071 | 211 | 1 | 100 | 0 | 1 | 211 | 2005 | 1795 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 14347 | 385 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24780404 | 24780404 | PRJNA564810_S_NODE_4720_length_258_cov_5.455959_g4698_i0 | PRJNA564810 | 4720 | 258 | 5.455959 | 14.07637422 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.29e-125 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g4698 | i0 | 98.837 | 79.1511627906977 | 258 | 3 | 100 | 0 | 1 | 258 | 2681 | 2938 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 20421 | 460 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24780414 | 24780414 | PRJNA564810_S_NODE_7220_length_221_cov_0.871795_g7198_i0 | PRJNA564810 | 7220 | 221 | 0.871795 | 1.92666695 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 4.69e-108 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g7198 | i0 | 99.548 | 25.6968325791855 | 221 | 1 | 100 | 0 | 1 | 221 | 370 | 590 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 5679 | 403 | 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);;