contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA541476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 508402 | 508402 | PRJNA541476_P_NODE_1021_length_1153_cov_8.037963_g852_i1 | PRJNA541476 | 1021 | 1153 | 8.037963 | 92.67771339 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1170 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g852 | i1 | 98.206 | 57.2515177797051 | 669 | 12 | 58 | 0 | 1 | 669 | 169 | 837 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 66011 | 1170 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 509318 | 509318 | PRJNA541476_P_NODE_6401_length_446_cov_3.898123_g6198_i0 | PRJNA541476 | 6401 | 446 | 3.898123 | 17.38562858 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 597 | 4.4199999999999985e-166 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g6198 | i0 | 90.828 | 100.80269058296 | 447 | 39 | 100 | 2 | 1 | 446 | 1639 | 1194 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 44958 | 597 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 509341 | 509341 | PRJNA541476_P_NODE_8441_length_389_cov_24.246835_g8237_i0 | PRJNA541476 | 8441 | 389 | 24.246835 | 94.32018815 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 712 | 0 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g8237 | i0 | 99.743 | 86.1645244215938 | 389 | 0 | 100 | 1 | 1 | 389 | 1705 | 1318 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 33518 | 712 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 509369 | 509369 | PRJNA541476_P_NODE_981_length_1172_cov_9.822566_g852_i0 | PRJNA541476 | 981 | 1172 | 9.822566 | 115.12047352 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1170 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g852 | i0 | 98.206 | 56.3233788395904 | 669 | 12 | 57 | 0 | 1 | 669 | 169 | 837 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 66011 | 1170 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 1784670 | 1784670 | PRJNA541476_P_NODE_5162_length_500_cov_113.700234_g4961_i0 | PRJNA541476 | 5162 | 500 | 113.700234 | 568.50117 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 917 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g4961 | i0 | 99.8 | 22.774 | 499 | 1 | 99 | 0 | 2 | 500 | 819 | 321 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 11387 | 917 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 4336228 | 4336228 | PRJNA541476_P_NODE_7104_length_423_cov_35.320000_g6900_i0 | PRJNA541476 | 7104 | 423 | 35.32 | 149.4036 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 782 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g6900 | i0 | 100 | 101.330969267139 | 423 | 0 | 100 | 0 | 1 | 423 | 3094 | 2672 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 42863 | 782 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 4336264 | 4336264 | PRJNA541476_P_NODE_964_length_1182_cov_5.495041_g836_i0 | PRJNA541476 | 964 | 1182 | 5.495041 | 64.95138462 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1633 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g836 | i0 | 99.664 | 81.6116751269035 | 893 | 3 | 76 | 0 | 285 | 1177 | 893 | 1 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 96465 | 1633 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 5613049 | 5613049 | PRJNA541476_P_NODE_42305_length_206_cov_49.052632_g42099_i0 | PRJNA541476 | 42305 | 206 | 49.052632 | 101.04842192 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 2.62e-100 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g42099 | i0 | 100 | 70.3398058252427 | 204 | 0 | 99 | 0 | 3 | 206 | 1663 | 1460 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 14490 | 377 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 6886905 | 6886905 | PRJNA541476_P_NODE_5926_length_465_cov_4.260204_g5723_i0 | PRJNA541476 | 5926 | 465 | 4.260204 | 19.8099486 | Paulinella chromatophora | 39717 | SAR_Eukaryotes | SAR_Eukaryotes | 381 | 5.069999999999999e-101 | NTclustered | gi|302563026|dbj|AB546336.1| | 39717 | g5723 | i0 | 82.619 | 73.3741935483871 | 443 | 64 | 94 | 9 | 28 | 465 | 591 | 157 | Paulinella chromatophora EF-1a mRNA for elongation factor 1alpha, partial cds | blastn | 34119 | 381 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 15811292 | 15811292 | PRJNA541476_P_NODE_16713_length_298_cov_6.453333_g16507_i0 | PRJNA541476 | 16713 | 298 | 6.453333 | 19.23093234 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 5.83e-19 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g16507 | i0 | 75.591 | 14.2248322147651 | 254 | 43 | 85 | 11 | 47 | 298 | 4021 | 3785 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4239 | 108 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 17086759 | 17086759 | PRJNA541476_P_NODE_42114_length_216_cov_60.139860_g41908_i0 | PRJNA541476 | 42114 | 216 | 60.13986 | 129.9020976 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 5.909999999999999e-107 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g41908 | i0 | 100 | 100.282407407407 | 216 | 0 | 100 | 0 | 1 | 216 | 1039 | 824 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 21661 | 399 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 20910403 | 20910403 | PRJNA541476_P_NODE_12057_length_335_cov_2.763359_g11851_i0 | PRJNA541476 | 12057 | 335 | 2.763359 | 9.25725265 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 569 | 7.049999999999998e-158 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g11851 | i0 | 97.313 | 1.92238805970149 | 335 | 9 | 100 | 0 | 1 | 335 | 692 | 358 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 644 | 569 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 22186062 | 22186062 | PRJNA541476_P_NODE_6198_length_454_cov_125.094488_g5995_i0 | PRJNA541476 | 6198 | 454 | 125.094488 | 567.92897552 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 3.87e-92 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g5995 | i0 | 83.416 | 48.6651982378855 | 404 | 42 | 88 | 17 | 1 | 401 | 3658 | 4039 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 22094 | 351 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 23461526 | 23461526 | PRJNA541476_P_NODE_7819_length_404_cov_4.570997_g7615_i0 | PRJNA541476 | 7819 | 404 | 4.570997 | 18.46682788 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 736 | 0 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g7615 | i0 | 99.505 | 35.8267326732673 | 404 | 2 | 100 | 0 | 1 | 404 | 250 | 653 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 14474 | 736 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24735234 | 24735234 | PRJNA541476_P_NODE_8180_length_395_cov_7.245342_g7976_i0 | PRJNA541476 | 8180 | 395 | 7.245342 | 28.6191009 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.91e-124 | NTclustered | gi|238617666|gb|FJ973412.1| | 188950 | g7976 | i0 | 99.602 | 35.4556962025316 | 251 | 1 | 64 | 0 | 145 | 395 | 1 | 251 | Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds | blastn | 14005 | 459 | 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);;