contig_metadata
6 rows where bioproject = "PRJNA596867" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11343782 | 11343782 | PRJNA596867_P_NODE_6829_length_311_cov_1.294118_g6754_i0 | PRJNA596867 | 6829 | 311 | 1.294118 | 4.02470698 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 575 | 1.3899999999999995e-159 | NTclustered | gi|2308292763|gb|OK574305.1| | 4784 | g6754 | i0 | 100 | 100.04501607717 | 311 | 0 | 100 | 0 | 1 | 311 | 30113 | 29803 | Phytophthora capsici voucher Pc389 mitochondrion, complete genome | blastn | 31114 | 575 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 18419874 | 18419874 | PRJNA596867_P_NODE_10595_length_259_cov_3.010753_g10520_i0 | PRJNA596867 | 10595 | 259 | 3.010753 | 7.79785027 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 9.529999999999998e-101 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g10520 | i0 | 93.077 | 89.027027027027 | 260 | 17 | 100 | 1 | 1 | 259 | 1630 | 1371 | Vorticella sp. 4 JG-2011 clone 2 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 | 23058 | 379 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 19694444 | 19694444 | PRJNA596867_P_NODE_4476_length_364_cov_8.168385_g4401_i0 | PRJNA596867 | 4476 | 364 | 8.168385 | 29.7329214 | Vorticella sp. 1 | 2979179 | SAR_Eukaryotes | SAR_Eukaryotes | 645 | 1.2499999999999996e-180 | NTclustered | gi|2304601489|gb|OP458310.1| | 2979179 | g4401 | i0 | 98.626 | 92.4450549450549 | 364 | 5 | 100 | 0 | 1 | 364 | 1469 | 1832 | Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence | blastn | 33650 | 645 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 1 | ||
| 23520450 | 23520450 | PRJNA596867_P_NODE_8159_length_289_cov_1.296296_g8084_i0 | PRJNA596867 | 8159 | 289 | 1.296296 | 3.74629544 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 8.71e-72 | NTclustered | gi|2795059548|ref|XM_067942762.1| | 4785 | g8084 | i0 | 88.745 | 1.59861591695502 | 231 | 26 | 80 | 0 | 57 | 287 | 645 | 415 | Phytophthora cinnamomi uncharacterized protein (IUM83_17794), partial mRNA | blastn | 462 | 283 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 24794133 | 24794133 | PRJNA596867_P_NODE_15320_length_240_cov_4.604790_g15245_i0 | PRJNA596867 | 15320 | 240 | 4.60479 | 11.051496 | Ophrydium crassicaule | 2919885 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 3.07e-115 | NTclustered | gi|2198905072|gb|OM801562.1| | 2919885 | g15245 | i0 | 98.75 | 100.195833333333 | 240 | 3 | 100 | 0 | 1 | 240 | 325 | 86 | Ophrydium crassicaule isolate WT2020072401 large subunit ribosomal RNA gene, partial sequence | blastn | 24047 | 427 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Ophrydiidae | Ophrydium | Ophrydium crassicaule | ||
| 29195726 | 29195726 | PRJNA596867_P_NODE_10749_length_258_cov_0.827027_g10674_i0 | PRJNA596867 | 10749 | 258 | 0.827027 | 2.13372966 | Eimeria brunetti | 51314 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0434 | NR | CDJ53954.1 | 51314 | g10674 | i0 | 42.9 | 0.732558139534884 | 63 | 32 | 70.9 | 2 | 64 | 246 | 10 | 70 | CDJ53954.1 zinc finger, putative [Eimeria brunetti] | diamond | 189 | 42.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria brunetti |
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);;