contig_metadata
13 rows where bioproject = "PRJNA1012699" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 158032 | 158032 | PRJNA1012699_P_NODE_441_length_513_cov_1.763636_g409_i0 | PRJNA1012699 | 441 | 513 | 1.763636 | 9.04745268 | Arachnula sp. CL22 | 862246 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 2.64e-94 | NTclustered | gi|301014696|gb|GQ377694.1| | 862246 | g409 | i0 | 88.966 | 41.140350877193 | 290 | 32 | 57 | 0 | 193 | 482 | 2 | 291 | Arachnula sp. CL22 ribosomal protein S23a (rps23a) mRNA, partial cds | blastn | 21105 | 359 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Leptophryidae | Arachnula | Arachnula sp. CL22 | |||
| 7380073 | 7380073 | PRJNA1012699_P_NODE_4186_length_221_cov_33.695946_g4154_i0 | PRJNA1012699 | 4186 | 221 | 33.695946 | 74.46804066 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 3.63e-109 | NTclustered | gi|291495599|gb|GU823226.1| | 152704 | g4154 | i0 | 100 | 99.5475113122172 | 220 | 0 | 99 | 0 | 1 | 220 | 841 | 1060 | Uncultured stramenopile clone BCA5F13RJ3F09 18S ribosomal RNA gene, partial sequence | blastn | 22000 | 407 | 1 | Eukaryota | Sar | uncultured stramenopile | |||||||
| 10361255 | 10361255 | PRJNA1012699_P_NODE_2529_length_256_cov_2.530055_g2497_i0 | PRJNA1012699 | 2529 | 256 | 2.530055 | 6.4769408 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 3.5e-75 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g2497 | i0 | 87.5 | 99.5234375 | 256 | 30 | 100 | 2 | 1 | 256 | 1621 | 1368 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 25478 | 294 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 10361275 | 10361275 | PRJNA1012699_P_NODE_3689_length_244_cov_0.912281_g3657_i0 | PRJNA1012699 | 3689 | 244 | 0.912281 | 2.22596564 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 2.08e-33 | NR | KUF77207.1 | 4792 | g3657 | i0 | 76.3 | 17.7049180327869 | 80 | 19 | 98.4 | 0 | 242 | 3 | 141 | 220 | KUF77207.1 Ras-related GTP-binding protein A [Phytophthora nicotianae] | diamond | 4320 | 125 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 19283680 | 19283680 | PRJNA1012699_P_NODE_476_length_498_cov_2.190588_g444_i0 | PRJNA1012699 | 476 | 498 | 2.190588 | 10.90912824 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 225 | 1.2099999999999998e-72 | NR | CEP00218.1 | 37360 | g444 | i0 | 69.4 | 2.82530120481928 | 157 | 45 | 92.8 | 1 | 2 | 463 | 7 | 163 | CEP00218.1 hypothetical protein PBRA_007952 [Plasmodiophora brassicae] | diamond | 1407 | 225 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 26717916 | 26717916 | PRJNA1012699_P_NODE_3641_length_245_cov_0.901163_g3609_i0 | PRJNA1012699 | 3641 | 245 | 0.901163 | 2.20784935 | Chaetoceros tenuissimus | 426638 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 3.61e-7 | NR | GFH53639.1 | 426638 | g3609 | i0 | 43.3 | 0.820408163265306 | 67 | 28 | 69.8 | 1 | 237 | 67 | 740 | 806 | GFH53639.1 hypothetical protein CTEN210_10115 [Chaetoceros tenuissimus] | diamond | 201 | 57 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Chaetocerotaceae | Chaetoceros | Chaetoceros tenuissimus | ||
| 28550981 | 28550981 | PRJNA1012699_P_NODE_3867_length_243_cov_0.917647_g3835_i0 | PRJNA1012699 | 3867 | 243 | 0.917647 | 2.22988221 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 5.26e-5 | NR | KAH9116918.1 | 100861 | g3835 | i0 | 49.2 | 1.5679012345679 | 59 | 25 | 72.8 | 2 | 222 | 46 | 318 | 371 | KAH9116918.1 hypothetical protein LEN26_012844 [Aphanomyces euteiches] | diamond | 381 | 50.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 29245454 | 29245454 | PRJNA1012699_P_NODE_3129_length_249_cov_0.886364_g3097_i0 | PRJNA1012699 | 3129 | 249 | 0.886364 | 2.20704636 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0269 | NR | CEP02334.1 | 37360 | g3097 | i0 | 34.9 | 1 | 83 | 50 | 98.8 | 2 | 247 | 2 | 122 | 201 | CEP02334.1 hypothetical protein PBRA_008918 [Plasmodiophora brassicae] | diamond | 249 | 43.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29371773 | 29371773 | PRJNA1012699_P_NODE_3269_length_248_cov_0.891429_g3237_i0 | PRJNA1012699 | 3269 | 248 | 0.891429 | 2.21074392 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 1.45e-9 | NR | XP_004039736.1 | 5932 | g3237 | i0 | 42.3 | 0.858870967741935 | 71 | 41 | 85.9 | 0 | 215 | 3 | 2 | 72 | XP_004039736.1 hypothetical protein IMG5_011820 [Ichthyophthirius multifiliis] | diamond | 213 | 63.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 29561015 | 29561015 | PRJNA1012699_P_NODE_1790_length_291_cov_1.068807_g1758_i0 | PRJNA1012699 | 1790 | 291 | 1.068807 | 3.11022837 | Cafeteria roenbergensis | 33653 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 3.3200000000000004e-26 | NR | KAA0161520.1 | 33653 | g1758 | i0 | 65 | 4.16494845360825 | 80 | 26 | 80.4 | 1 | 3 | 236 | 247 | 326 | KAA0161520.1 hypothetical protein FNF31_03803 [Cafeteria roenbergensis] | diamond | 1212 | 108 | 1 | Eukaryota | Sar | Bigyra | Bicosoecida | Cafeteriaceae | Cafeteria | Cafeteria roenbergensis | |||
| 29718771 | 29718771 | PRJNA1012699_P_NODE_1890_length_285_cov_1.462264_g1858_i0 | PRJNA1012699 | 1890 | 285 | 1.462264 | 4.1674524 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 2.49e-5 | NR | KAF0720703.1 | 120398 | g1858 | i0 | 34.9 | 1.74736842105263 | 83 | 50 | 87.4 | 1 | 272 | 24 | 536 | 614 | KAF0720703.1 hypothetical protein As57867_000128 [Aphanomyces stellatus] | diamond | 498 | 52.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 31290884 | 31290884 | PRJNA1012699_P_NODE_2755_length_252_cov_0.871508_g2723_i0 | PRJNA1012699 | 2755 | 252 | 0.871508 | 2.19620016 | root | 1 | Root_unresolved | Root_unresolved | 42.7 | 0.0385 | NR | RQM20357.1 | 112090 | g2723 | i0 | 53.3 | 1.46428571428571 | 30 | 14 | 35.7 | 0 | 239 | 150 | 260 | 289 | RQM20357.1 hypothetical protein B5M09_003936 [Aphanomyces astaci] | diamond | 369 | 42.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 31425252 | 31425252 | PRJNA1012699_P_NODE_3696_length_244_cov_0.912281_g3664_i0 | PRJNA1012699 | 3696 | 244 | 0.912281 | 2.22596564 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 2.9e-5 | NR | CAE8595186.1 | 89957 | g3664 | i0 | 57.9 | 0.467213114754098 | 38 | 16 | 46.7 | 0 | 237 | 124 | 559 | 596 | CAE8595186.1 unnamed protein product [Polarella glacialis] | diamond | 114 | 51.6 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis |
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);;