contig_metadata
13 rows where bioproject = "PRJNA1227535" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8700088 | 8700088 | PRJNA1227535_P_NODE_5327_length_322_cov_1.184739_g5204_i0 | PRJNA1227535 | 5327 | 322 | 1.184739 | 3.81485958 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.66e-64 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5204 | i0 | 96.226 | 2.1055900621118 | 159 | 4 | 49 | 1 | 1 | 157 | 2924 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 678 | 259 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 9263445 | 9263445 | PRJNA1227535_P_NODE_28068_length_245_cov_1.430233_g27944_i0 | PRJNA1227535 | 28068 | 245 | 1.430233 | 3.50407085 | Bacillariophyta | 2836 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.78e-36 | NR | EJK48596.1 | 159749 | g27944 | i0 | 81.3 | 25.5061224489796 | 80 | 15 | 98 | 0 | 244 | 5 | 53 | 132 | EJK48596.1 hypothetical protein THAOC_32592 [Thalassiosira oceanica] | diamond | 6249 | 134 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Thalassiosiraceae | Thalassiosira | Thalassiosira oceanica | ||
| 11814006 | 11814006 | PRJNA1227535_P_NODE_27930_length_245_cov_1.813953_g27806_i0 | PRJNA1227535 | 27930 | 245 | 1.813953 | 4.44418485 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 1.49e-98 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g27806 | i0 | 93.927 | 39.4040816326531 | 247 | 13 | 100 | 1 | 1 | 245 | 116085 | 116331 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 9654 | 372 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 20173283 | 20173283 | PRJNA1227535_P_NODE_2496_length_432_cov_2.835655_g2374_i0 | PRJNA1227535 | 2496 | 432 | 2.835655 | 12.2500296 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 702 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2374 | i0 | 96.056 | 71.4722222222222 | 431 | 17 | 99 | 0 | 1 | 431 | 55 | 485 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 30876 | 702 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 22012055 | 22012055 | PRJNA1227535_P_NODE_25098_length_249_cov_0.886364_g24974_i0 | PRJNA1227535 | 25098 | 249 | 0.886364 | 2.20704636 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.98e-92 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g24974 | i0 | 92.683 | 36.9076305220884 | 246 | 15 | 100 | 3 | 1 | 245 | 96675 | 96432 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 9190 | 351 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23287785 | 23287785 | PRJNA1227535_P_NODE_6359_length_312_cov_3.430962_g6236_i0 | PRJNA1227535 | 6359 | 312 | 3.430962 | 10.70460144 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.029 | NTclustered | gi|145479822|ref|XM_001425897.1| | 5888 | g6236 | i0 | 100 | 0.0897435897435897 | 28 | 0 | 9 | 0 | 278 | 305 | 473 | 446 | Paramecium tetraurelia uncharacterized protein (GSPATT00004909001), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 28620394 | 28620394 | PRJNA1227535_P_NODE_10607_length_290_cov_1.976959_g10484_i0 | PRJNA1227535 | 10607 | 290 | 1.976959 | 5.7331811 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.88e-23 | NR | CAI5722522.1 | 134698 | g10484 | i0 | 87.5 | 1.15862068965517 | 56 | 7 | 57.9 | 0 | 288 | 121 | 319 | 374 | CAI5722522.1 unnamed protein product [Peronospora farinosa] | diamond | 336 | 102 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 29188752 | 29188752 | PRJNA1227535_P_NODE_19329_length_261_cov_1.303191_g19205_i0 | PRJNA1227535 | 19329 | 261 | 1.303191 | 3.40132851 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.93e-41 | NR | KAJ1439139.1 | 483371 | g19205 | i0 | 82.8 | 2 | 87 | 15 | 100 | 0 | 261 | 1 | 327 | 413 | KAJ1439139.1 chaperonin Cpn60/TCP-1 family [Ochromonadaceae sp. CCMP2298] | diamond | 522 | 152 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 29567312 | 29567312 | PRJNA1227535_P_NODE_25010_length_249_cov_0.886364_g24886_i0 | PRJNA1227535 | 25010 | 249 | 0.886364 | 2.20704636 | Synura synuroidea | 47573 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 7.57e-5 | NR | NP_038170.1 | 47573 | g24886 | i0 | 36.8 | 0.91566265060241 | 76 | 46 | 90.4 | 2 | 226 | 2 | 371 | 445 | NP_038170.1 NADH dehydrogenase subunit 11 [Synura synuroidea] | diamond | 228 | 50.4 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura synuroidea | |||
| 30281510 | 30281510 | PRJNA1227535_P_NODE_26052_length_247_cov_4.028736_g25928_i0 | PRJNA1227535 | 26052 | 247 | 4.028736 | 9.95097792 | root | 1 | Root_unresolved | Root_unresolved | 46.6 | 0.00179 | NR | CAB9507385.1 | 568900 | g25928 | i0 | 35.8 | 2.79352226720648 | 81 | 51 | 97.2 | 1 | 241 | 2 | 2213 | 2293 | CAB9507385.1 Clustered mitochondria protein homolog [Seminavis robusta] | diamond | 690 | 46.6 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Seminavis | Seminavis robusta | ||
| 31007804 | 31007804 | PRJNA1227535_P_NODE_17414_length_267_cov_1.525773_g17291_i0 | PRJNA1227535 | 17414 | 267 | 1.525773 | 4.07381391 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.84e-22 | NR | OQR90711.1 | 74557 | g17291 | i0 | 56.6 | 4.64044943820225 | 76 | 33 | 85.4 | 0 | 264 | 37 | 158 | 233 | OQR90711.1 coatomer subunit gamma [Thraustotheca clavata] | diamond | 1239 | 100 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31779381 | 31779381 | PRJNA1227535_P_NODE_26717_length_247_cov_0.896552_g26593_i0 | PRJNA1227535 | 26717 | 247 | 0.896552 | 2.21448344 | Mayamaea pseudoterrestris | 2872254 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.78e-22 | NR | GKY97920.1 | 2872254 | g26593 | i0 | 59 | 1.0080971659919 | 83 | 31 | 97.2 | 1 | 245 | 6 | 206 | 288 | GKY97920.1 hypothetical protein MPSEU_000750000 [Mayamaea pseudoterrestris] | diamond | 249 | 100 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Mayamaea | Mayamaea pseudoterrestris | ||
| 31779385 | 31779385 | PRJNA1227535_P_NODE_9617_length_294_cov_2.018100_g9494_i0 | PRJNA1227535 | 9617 | 294 | 2.0181 | 5.933214 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 173 | 6.42e-49 | NR | KAJ1416357.1 | 483371 | g9494 | i0 | 90.7 | 0.989795918367347 | 97 | 9 | 99 | 0 | 292 | 2 | 263 | 359 | KAJ1416357.1 chaperonin Cpn60/TCP-1 family [Ochromonadaceae sp. CCMP2298] | diamond | 291 | 173 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 |
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);;