contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJEB14664" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3847338 | 3847338 | PRJEB14664_P_NODE_1064_length_898_cov_3.396292_g274_i2 | PRJEB14664 | 1064 | 898 | 3.396292 | 30.49870216 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 926 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g274 | i2 | 98.659 | 63.511135857461 | 522 | 7 | 58 | 0 | 377 | 898 | 837 | 316 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 57033 | 926 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 8948246 | 8948246 | PRJEB14664_P_NODE_5328_length_365_cov_9.390909_g5198_i0 | PRJEB14664 | 5328 | 365 | 9.390909 | 34.27681785 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 592 | 1.6499999999999996e-164 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g5198 | i0 | 95.89 | 77.1808219178082 | 365 | 15 | 100 | 0 | 1 | 365 | 3100 | 2736 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 28171 | 592 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14049258 | 14049258 | PRJEB14664_P_NODE_10712_length_230_cov_2.051282_g10582_i0 | PRJEB14664 | 10712 | 230 | 2.051282 | 4.7179486 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 409 | 1.0600000000000001e-109 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g10582 | i0 | 98.707 | 19.8260869565217 | 232 | 0 | 99 | 1 | 1 | 229 | 171 | 402 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 4560 | 409 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14049390 | 14049390 | PRJEB14664_P_NODE_3792_length_454_cov_4.002387_g3666_i0 | PRJEB14664 | 3792 | 454 | 4.002387 | 18.17083698 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 1.39e-91 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g3666 | i0 | 83.5 | 46.2334801762115 | 400 | 41 | 87 | 17 | 58 | 454 | 4039 | 3662 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20990 | 350 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 15323403 | 15323403 | PRJEB14664_P_NODE_2473_length_582_cov_3.585009_g2359_i0 | PRJEB14664 | 2473 | 582 | 3.585009 | 20.86475238 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 660 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g2359 | i0 | 99.449 | 79.5257731958763 | 363 | 2 | 62 | 0 | 1 | 363 | 531 | 893 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 46284 | 660 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 16597992 | 16597992 | PRJEB14664_P_NODE_14494_length_187_cov_4.473684_g14364_i0 | PRJEB14664 | 14494 | 187 | 4.473684 | 8.36578908 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 6.56e-91 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g14364 | i0 | 100 | 59.5294117647059 | 187 | 0 | 100 | 0 | 1 | 187 | 1659 | 1473 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 11132 | 346 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 17872806 | 17872806 | PRJEB14664_P_NODE_1695_length_710_cov_26.438519_g1593_i0 | PRJEB14664 | 1695 | 710 | 26.438519 | 187.7134849 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1284 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g1593 | i0 | 99.296 | 72.5323943661972 | 710 | 5 | 100 | 0 | 1 | 710 | 1698 | 2407 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 51498 | 1284 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 20421850 | 20421850 | PRJEB14664_P_NODE_14017_length_191_cov_2.750000_g13887_i0 | PRJEB14664 | 14017 | 191 | 2.75 | 5.2525 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 353 | 4.02e-93 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g13887 | i0 | 100 | 100.397905759162 | 191 | 0 | 100 | 0 | 1 | 191 | 1019 | 829 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 19176 | 353 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 21697926 | 21697926 | PRJEB14664_P_NODE_19818_length_152_cov_1.735043_g19688_i0 | PRJEB14664 | 19818 | 152 | 1.735043 | 2.63726536 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 7.02e-45 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g19688 | i0 | 89.474 | 100.875 | 152 | 16 | 100 | 0 | 1 | 152 | 1176 | 1327 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 15333 | 193 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24247077 | 24247077 | PRJEB14664_P_NODE_4800_length_392_cov_2.535014_g4670_i0 | PRJEB14664 | 4800 | 392 | 2.535014 | 9.93725488 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 475 | 1.88e-129 | NTclustered | gi|238617666|gb|FJ973412.1| | 188950 | g4670 | i0 | 99.615 | 40.8877551020408 | 260 | 1 | 66 | 0 | 133 | 392 | 1 | 260 | Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds | blastn | 16028 | 475 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24247105 | 24247105 | PRJEB14664_P_NODE_7080_length_305_cov_2.711111_g6950_i0 | PRJEB14664 | 7080 | 305 | 2.711111 | 8.26888855 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 553 | 6.39e-153 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g6950 | i0 | 99.344 | 1 | 305 | 2 | 100 | 0 | 1 | 305 | 717 | 413 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 305 | 553 | 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);;