contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA890871" and tax_phylum = "Apicomplexa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5967358 | 5967358 | PRJNA890871_P_NODE_26565_length_325_cov_4.059524_g26430_i0 | PRJNA890871 | 26565 | 325 | 4.059524 | 13.193453 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 5.62e-114 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g26430 | i0 | 90.712 | 24.7784615384615 | 323 | 23 | 99 | 6 | 1 | 323 | 60 | 375 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 8053 | 424 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 7241701 | 7241701 | PRJNA890871_P_NODE_11586_length_457_cov_4.468750_g11451_i0 | PRJNA890871 | 11586 | 457 | 4.46875 | 20.4221875 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 625 | 2.0799999999999995e-174 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g11451 | i0 | 91.85 | 31.7024070021882 | 454 | 28 | 99 | 8 | 1 | 454 | 33 | 477 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 14488 | 625 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 7243626 | 7243626 | PRJNA890871_P_NODE_93966_length_202_cov_4.193798_g93831_i0 | PRJNA890871 | 93966 | 202 | 4.193798 | 8.47147196 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 9.59e-70 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g93831 | i0 | 91.584 | 15.9108910891089 | 202 | 13 | 100 | 2 | 1 | 202 | 201 | 4 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 3214 | 276 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 9792148 | 9792148 | PRJNA890871_P_NODE_3108_length_875_cov_7.043641_g2984_i0 | PRJNA890871 | 3108 | 875 | 7.043641 | 61.63185875 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 457 | 1.6000000000000002e-123 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g2984 | i0 | 85.977 | 0.897142857142857 | 435 | 52 | 89 | 8 | 442 | 875 | 501 | 75 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 785 | 457 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 13618387 | 13618387 | PRJNA890871_P_NODE_51511_length_264_cov_2.596859_g51376_i0 | PRJNA890871 | 51511 | 264 | 2.596859 | 6.85570776 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 7.58e-97 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g51376 | i0 | 92.045 | 23.3068181818182 | 264 | 15 | 99 | 5 | 2 | 264 | 404 | 146 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 6153 | 366 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 13619022 | 13619022 | PRJNA890871_P_NODE_8811_length_515_cov_2.581448_g8676_i0 | PRJNA890871 | 8811 | 515 | 2.581448 | 13.2944572 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 1.5899999999999995e-96 | NTclustered | gi|209883104|ref|XM_002142938.1| | 441375 | g8676 | i0 | 79.73 | 4.51456310679612 | 518 | 95 | 99 | 7 | 1 | 513 | 1270 | 758 | Cryptosporidium muris RN66 uncharacterized protein (CMU_004200), partial mRNA | blastn | 2325 | 366 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 13619154 | 13619154 | PRJNA890871_P_NODE_9431_length_500_cov_15.548009_g9296_i0 | PRJNA890871 | 9431 | 500 | 15.548009 | 77.740045 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 1.88e-135 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g9296 | i0 | 86.364 | 9.232 | 462 | 54 | 92 | 8 | 3 | 464 | 49 | 501 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 4616 | 496 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 14892471 | 14892471 | PRJNA890871_P_NODE_40652_length_281_cov_1.447115_g40517_i0 | PRJNA890871 | 40652 | 281 | 1.447115 | 4.06639315 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 2.26e-97 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g40517 | i0 | 90.714 | 16.8007117437722 | 280 | 21 | 99 | 3 | 2 | 281 | 32 | 306 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 4721 | 368 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 16166619 | 16166619 | PRJNA890871_P_NODE_21793_length_352_cov_3.910394_g21658_i0 | PRJNA890871 | 21793 | 352 | 3.910394 | 13.76458688 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 536 | 7.539999999999997e-148 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g21658 | i0 | 94.587 | 32.9460227272727 | 351 | 12 | 99 | 6 | 2 | 352 | 369 | 26 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 11597 | 536 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 18715461 | 18715461 | PRJNA890871_P_NODE_27415_length_321_cov_3.963710_g27280_i0 | PRJNA890871 | 27415 | 321 | 3.96371 | 12.7235091 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.96e-123 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g27280 | i0 | 92.523 | 26.0778816199377 | 321 | 19 | 100 | 4 | 1 | 321 | 161 | 476 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 8371 | 455 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 22542213 | 22542213 | PRJNA890871_P_NODE_9058_length_509_cov_5.077982_g8923_i0 | PRJNA890871 | 9058 | 509 | 5.077982 | 25.84692838 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 880 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g8923 | i0 | 97.839 | 872.838899803536 | 509 | 11 | 100 | 0 | 1 | 509 | 618 | 1126 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 444275 | 880 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 25090857 | 25090857 | PRJNA890871_P_NODE_56860_length_257_cov_2.896739_g56725_i0 | PRJNA890871 | 56860 | 257 | 2.896739 | 7.44461923 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 3.349999999999999e-110 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g56725 | i0 | 96.078 | 31.6770428015564 | 255 | 5 | 100 | 3 | 3 | 257 | 54 | 303 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 8141 | 411 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata |
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);;