contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA884104" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 860306 | 860306 | PRJNA884104_S_NODE_17041_length_487_cov_17.719807_g16302_i0 | PRJNA884104 | 17041 | 487 | 17.719807 | 86.29546009 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 894 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g16302 | i0 | 99.795 | 96.7145790554415 | 487 | 1 | 100 | 0 | 1 | 487 | 1668 | 2154 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 47100 | 894 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 1241250 | 1241250 | PRJNA884104_S_NODE_61381_length_266_cov_2.025907_g60638_i0 | PRJNA884104 | 61381 | 266 | 2.025907 | 5.38891262 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 4.87e-54 | NTclustered | gi|33346926|gb|AY251792.1| | 227086 | g60638 | i0 | 83.197 | 86.8195488721804 | 244 | 41 | 92 | 0 | 1 | 244 | 479 | 236 | Bigelowiella natans ubiquitin/actin fusion protein 1 gene, partial cds | blastn | 23094 | 224 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 2135895 | 2135895 | PRJNA884104_S_NODE_28462_length_381_cov_3.912338_g27719_i0 | PRJNA884104 | 28462 | 381 | 3.912338 | 14.90600778 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 6.639999999999999e-119 | NTclustered | gi|238617666|gb|FJ973412.1| | 188950 | g27719 | i0 | 99.18 | 36.5564304461942 | 244 | 2 | 64 | 0 | 1 | 244 | 244 | 1 | Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds | blastn | 13928 | 440 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2516783 | 2516783 | PRJNA884104_S_NODE_26942_length_391_cov_6.298742_g26199_i0 | PRJNA884104 | 26942 | 391 | 6.298742 | 24.62808122 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 717 | 0 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g26199 | i0 | 99.744 | 100.498721227621 | 391 | 1 | 100 | 0 | 1 | 391 | 1015 | 625 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 39295 | 717 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 5964108 | 5964108 | PRJNA884104_S_NODE_45545_length_309_cov_0.978814_g44802_i0 | PRJNA884104 | 45545 | 309 | 0.978814 | 3.02453526 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 1.26e-45 | NTclustered | gi|319412263|gb|HQ840955.1| | 227086 | g44802 | i0 | 86.096 | 77.2459546925566 | 187 | 20 | 60 | 5 | 72 | 255 | 13886 | 14069 | Bigelowiella natans culture-collection CCMP:621 mitochondrion, partial genome | blastn | 23869 | 196 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 5964746 | 5964746 | PRJNA884104_S_NODE_7705_length_729_cov_2.596037_g7031_i0 | PRJNA884104 | 7705 | 729 | 2.596037 | 18.92510973 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 913 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g7031 | i0 | 98.273 | 79.4938271604938 | 521 | 9 | 71 | 0 | 209 | 729 | 837 | 317 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 57951 | 913 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 5964952 | 5964952 | PRJNA884104_S_NODE_87965_length_225_cov_6.585526_g87222_i0 | PRJNA884104 | 87965 | 225 | 6.585526 | 14.8174335 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 6.159999999999998e-112 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g87222 | i0 | 100 | 82.8 | 225 | 0 | 100 | 0 | 1 | 225 | 1468 | 1692 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 18630 | 416 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 11064460 | 11064460 | PRJNA884104_S_NODE_49369_length_297_cov_14.325893_g48626_i0 | PRJNA884104 | 49369 | 297 | 14.325893 | 42.54790221 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 549 | 8.029999999999997e-152 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g48626 | i0 | 100 | 42.0673400673401 | 297 | 0 | 100 | 0 | 1 | 297 | 2113 | 2409 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 12494 | 549 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 12340433 | 12340433 | PRJNA884104_S_NODE_6890_length_772_cov_4.549356_g6250_i0 | PRJNA884104 | 6890 | 772 | 4.549356 | 35.12102832 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 6.669999999999999e-107 | NTclustered | gi|300676720|gb|GQ377713.1| | 323453 | g6250 | i0 | 83.447 | 67.6774611398964 | 441 | 63 | 56 | 10 | 141 | 576 | 5 | 440 | Heteromita sp. PRA-74 gcr5-like mRNA, partial sequence | blastn | 52247 | 401 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 16164310 | 16164310 | PRJNA884104_S_NODE_8333_length_702_cov_11.359300_g7643_i0 | PRJNA884104 | 8333 | 702 | 11.3593 | 79.742285999999993 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1291 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g7643 | i0 | 99.858 | 51.7236467236467 | 702 | 1 | 100 | 0 | 1 | 702 | 1044 | 343 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 36310 | 1291 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 19987074 | 19987074 | PRJNA884104_S_NODE_2176_length_1343_cov_3.781890_g1871_i0 | PRJNA884104 | 2176 | 1343 | 3.78189 | 50.7907827 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1611 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g1871 | i0 | 99.659 | 70.7505584512286 | 881 | 3 | 66 | 0 | 1 | 881 | 13 | 893 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 95018 | 1611 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 21262146 | 21262146 | PRJNA884104_S_NODE_11977_length_583_cov_2.974510_g11251_i0 | PRJNA884104 | 11977 | 583 | 2.97451 | 17.3413933 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1066 | 0 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g11251 | i0 | 99.657 | 95.0308747855918 | 583 | 2 | 100 | 0 | 1 | 583 | 257 | 839 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 55403 | 1066 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 22538441 | 22538441 | PRJNA884104_S_NODE_86858_length_240_cov_14.323353_g86115_i0 | PRJNA884104 | 86858 | 240 | 14.323353 | 34.3760472 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.05e-120 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g86115 | i0 | 100 | 99.1291666666667 | 240 | 0 | 100 | 0 | 1 | 240 | 2921 | 2682 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 23791 | 444 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23812595 | 23812595 | PRJNA884104_S_NODE_20699_length_443_cov_24.210811_g19956_i0 | PRJNA884104 | 20699 | 443 | 24.210811 | 107.25389273 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 8.17e-89 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g19956 | i0 | 83.166 | 51.4785553047404 | 398 | 42 | 89 | 17 | 49 | 443 | 4039 | 3664 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 22805 | 340 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis |
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);;