contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1108487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1488085 | 1488085 | PRJNA1108487_P_NODE_1822_length_500_cov_4.608899_g1756_i0 | PRJNA1108487 | 1822 | 500 | 4.608899 | 23.044495 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 608 | 2.309999999999999e-169 | NTclustered | gi|300676750|gb|GQ377668.1| | 45107 | g1756 | i0 | 88.755 | 99.37 | 498 | 54 | 99 | 2 | 1 | 497 | 494 | 990 | Heteromita globosa actin gene, partial cds | blastn | 49685 | 608 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 2764158 | 2764158 | PRJNA1108487_P_NODE_4483_length_330_cov_0.910506_g4417_i0 | PRJNA1108487 | 4483 | 330 | 0.910506 | 3.0046698 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 475 | 1.5599999999999994e-129 | NTclustered | gi|302026148|gb|GQ377646.1| | 646463 | g4417 | i0 | 93.189 | 99.2666666666667 | 323 | 22 | 98 | 0 | 1 | 323 | 74 | 396 | Gymnophrys sp. ATCC 50923 beta-tubulin (Btub) gene, partial cds | blastn | 32758 | 475 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 5316296 | 5316296 | PRJNA1108487_P_NODE_11585_length_229_cov_25.615385_g11519_i0 | PRJNA1108487 | 11585 | 229 | 25.615385 | 58.65923165 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 422 | 1.35e-113 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g11519 | i0 | 100 | 100.379912663755 | 228 | 0 | 99 | 0 | 1 | 228 | 714 | 941 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 22987 | 422 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 13773859 | 13773859 | PRJNA1108487_P_NODE_3671_length_358_cov_3.740351_g3605_i0 | PRJNA1108487 | 3671 | 358 | 3.740351 | 13.39045658 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 640 | 5.689999999999999e-179 | NTclustered | gi|225216798|gb|FJ176713.1| | 458884 | g3605 | i0 | 98.886 | 100.653631284916 | 359 | 3 | 100 | 1 | 1 | 358 | 1624 | 1266 | Bodomorpha sp. HFCC92 18S ribosomal RNA gene, partial sequence | blastn | 36034 | 640 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 16790534 | 16790534 | PRJNA1108487_P_NODE_1034_length_648_cov_2.838261_g971_i0 | PRJNA1108487 | 1034 | 648 | 2.838261 | 18.39193128 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 4.48e-78 | NTclustered | gi|300521445|gb|GQ377709.1| | 323453 | g971 | i0 | 83.086 | 16.8271604938272 | 337 | 55 | 52 | 2 | 297 | 632 | 698 | 363 | Heteromita sp. PRA-74 14-3-3 protein-like mRNA, partial sequence | blastn | 10904 | 305 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 18065078 | 18065078 | PRJNA1108487_P_NODE_10535_length_245_cov_0.906977_g10469_i0 | PRJNA1108487 | 10535 | 245 | 0.906977 | 2.22209365 | Cercozoa sp. Hf_SH1_KV | 563738 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 3.47e-45 | NTclustered | gi|224996455|gb|FJ654288.1| | 563738 | g10469 | i0 | 86.813 | 46.6571428571429 | 182 | 14 | 71 | 8 | 52 | 226 | 2 | 180 | Cercozoa sp. Hf_SH1_KV 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 11431 | 195 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. Hf_SH1_KV | ||||||
| 18065121 | 18065121 | PRJNA1108487_P_NODE_5435_length_305_cov_0.818966_g5369_i0 | PRJNA1108487 | 5435 | 305 | 0.818966 | 2.4978463 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 6.77e-113 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g5369 | i0 | 91.749 | 35.6393442622951 | 303 | 23 | 99 | 2 | 2 | 303 | 203 | 504 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 10870 | 420 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 18872162 | 18872162 | PRJNA1108487_P_NODE_8115_length_255_cov_15.373626_g8049_i0 | PRJNA1108487 | 8115 | 255 | 15.373626 | 39.2027463 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 1.5e-128 | NTclustered | gi|225216798|gb|FJ176713.1| | 458884 | g8049 | i0 | 100 | 101.372549019608 | 255 | 0 | 100 | 0 | 1 | 255 | 372 | 118 | Bodomorpha sp. HFCC92 18S ribosomal RNA gene, partial sequence | blastn | 25850 | 472 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 19339285 | 19339285 | PRJNA1108487_P_NODE_3336_length_373_cov_12.183333_g3270_i0 | PRJNA1108487 | 3336 | 373 | 12.183333 | 45.44383209 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 514 | 3.77e-141 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g3270 | i0 | 91.534 | 101.235924932976 | 378 | 24 | 100 | 8 | 1 | 373 | 3048 | 2674 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 37761 | 514 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 20614550 | 20614550 | PRJNA1108487_P_NODE_3057_length_389_cov_1.047468_g2991_i0 | PRJNA1108487 | 3057 | 389 | 1.047468 | 4.07465052 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 479 | 1.4399999999999996e-130 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g2991 | i0 | 88.946 | 83.1670951156812 | 389 | 42 | 100 | 1 | 1 | 389 | 477 | 90 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 32352 | 479 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 20614564 | 20614564 | PRJNA1108487_P_NODE_477_length_917_cov_13.802133_g426_i0 | PRJNA1108487 | 477 | 917 | 13.802133 | 126.56555961 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 1334 | 0 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g426 | i0 | 98.67 | 55.5387131952017 | 752 | 10 | 82 | 0 | 166 | 917 | 1 | 752 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 50929 | 1334 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 21890260 | 21890260 | PRJNA1108487_P_NODE_6438_length_283_cov_1.485714_g6372_i0 | PRJNA1108487 | 6438 | 283 | 1.485714 | 4.20457062 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.43e-64 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g6372 | i0 | 84.375 | 51.0706713780919 | 288 | 19 | 100 | 13 | 1 | 283 | 2718 | 2984 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 14453 | 259 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23165739 | 23165739 | PRJNA1108487_P_NODE_2519_length_427_cov_33.468927_g2453_i0 | PRJNA1108487 | 2519 | 427 | 33.468927 | 142.91231829 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 6.2e-75 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g2453 | i0 | 81.53 | 47.3864168618267 | 379 | 51 | 88 | 11 | 51 | 427 | 4021 | 3660 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20234 | 294 | 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);;