contig_metadata
5 rows where bioproject = "PRJEB7614", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19264233 | 19264233 | PRJEB7614_P_NODE_976_length_326_cov_389797.838384_g911_i0 | PRJEB7614 | 976 | 326 | 389797.838384 | 1270740.95313184 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 8.34e-18 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g911 | i0 | 88.043 | 23.4631901840491 | 92 | 6 | 28 | 5 | 109 | 199 | 330 | 243 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 7649 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 25661660 | 25661660 | PRJEB7614b_S_NODE_98_length_397_cov_34208.776243_g96_i0 | PRJEB7614 | 98 | 397 | 34208.776243 | 135808.84168471 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.03e-17 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g96 | i0 | 88.043 | 15.1511335012594 | 92 | 6 | 23 | 5 | 89 | 179 | 330 | 243 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 6015 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 26069955 | 26069955 | PRJEB7614d_S_NODE_309_length_327_cov_16.530822_g271_i0 | PRJEB7614 | 309 | 327 | 16.530822 | 54.05578794 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 8.37e-18 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g271 | i0 | 88.043 | 3.75840978593272 | 92 | 6 | 28 | 5 | 190 | 280 | 243 | 330 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 1229 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 26342051 | 26342051 | PRJEB7614b_S_NODE_527_length_262_cov_54548.709251_g525_i0 | PRJEB7614 | 527 | 262 | 54548.709251 | 142917.61823762 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 6.51e-18 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g525 | i0 | 88.043 | 22.6297709923664 | 92 | 6 | 35 | 5 | 89 | 179 | 330 | 243 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 5929 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 26478309 | 26478309 | PRJEB7614b_S_NODE_6912_length_156_cov_1.933884_g6910_i0 | PRJEB7614 | 6912 | 156 | 1.933884 | 3.01685904 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 9.59e-29 | NTclustered | gi|1085197446|ref|XR_001974451.1| | 508771 | g6910 | i0 | 88.235 | 6.12179487179487 | 119 | 11 | 75 | 3 | 31 | 147 | 61 | 178 | Toxoplasma gondii ME49 28S ribosomal RNA rRNA | blastn | 955 | 139 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii |
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);;