contig_metadata
6 rows where bioproject = "PRJNA977246", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3820856 | 3820856 | PRJNA977246_S_NODE_29043_length_232_cov_6.610837_g28051_i0 | PRJNA977246 | 29043 | 232 | 6.610837 | 15.33714184 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.54e-33 | NTclustered | gi|1272609481|gb|KY882336.1| | 5807 | g28051 | i0 | 90.083 | 52.0646551724138 | 121 | 10 | 52 | 2 | 1 | 120 | 222 | 103 | Cryptosporidium parvum isolate HS55 28S ribosomal RNA gene, partial sequence | blastn | 12079 | 156 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 9879166 | 9879166 | PRJNA977246_S_NODE_21488_length_293_cov_6910.231061_g20496_i0 | PRJNA977246 | 21488 | 293 | 6910.231061 | 20246.97700873 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 6.75e-83 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g20496 | i0 | 90.496 | 71.2457337883959 | 242 | 23 | 83 | 0 | 1 | 242 | 300541 | 300782 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 20875 | 320 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 16254312 | 16254312 | PRJNA977246_S_NODE_35413_length_199_cov_11.894118_g34421_i0 | PRJNA977246 | 35413 | 199 | 11.894118 | 23.66929482 | Selenidium pyroidea | 2605653 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|1730679298|gb|MN381957.1| | 2605653 | g34421 | i0 | 100 | 0.28643216080402 | 29 | 0 | 15 | 0 | 1 | 29 | 4509 | 4481 | Selenidium pyroidea isolate AK3 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Archigregarinorida | Selenidiidae | Selenidium | Selenidium pyroidea | ||
| 19120140 | 19120140 | PRJNA977246_S_NODE_12835_length_417_cov_5.270619_g11862_i0 | PRJNA977246 | 12835 | 417 | 5.270619 | 21.97848123 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 3.98e-7 | NTclustered | gi|2785764944|ref|XM_067217517.1| | 5824 | g11862 | i0 | 93.478 | 19.9448441247002 | 46 | 3 | 11 | 0 | 114 | 159 | 1051 | 1006 | Plasmodium brasilianum uncharacterized protein (MKS88_004347), partial mRNA | blastn | 8317 | 69.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 22628005 | 22628005 | PRJNA977246_S_NODE_16698_length_350_cov_5.514019_g15706_i0 | PRJNA977246 | 16698 | 350 | 5.514019 | 19.2990665 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 3.28e-7 | NTclustered | gi|820694606|tpe|LN714487.1| | 572307 | g15706 | i0 | 90.385 | 0.294285714285714 | 52 | 5 | 15 | 0 | 52 | 103 | 3559846 | 3559897 | TPA_asm: Neospora caninum Liverpool, chromosome chrXII, complete genome | blastn | 103 | 69.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 30658039 | 30658039 | PRJNA977246_S_NODE_24853_length_263_cov_12.183761_g23861_i0 | PRJNA977246 | 24853 | 263 | 12.183761 | 32.04329143 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0255 | NR | XP_067181760.1 | 310047 | g23861 | i0 | 47.1 | 0.581749049429658 | 51 | 25 | 55.9 | 1 | 180 | 34 | 370 | 420 | XP_067181760.1 interaptin [Cryptosporidium bovis] | diamond | 153 | 43.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis |
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);;