metadata: contig_metadata: 6 rows where bioproject = "PRJNA399711", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA399711", tax_clade = "Sar" and tax_phylum = "Ciliophora"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
25837703	25837703	PRJNA399711_S_NODE_99523_length_155_cov_3.271186_g99381_i0	PRJNA399711	99523	155	3.271186	5.0703383	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	82	3.01e-17	NR	KRX09037.1	266149	g99381	i0	73.5	6.63870967741935	49	13	94.8	0	147	1	160	208	KRX09037.1 hypothetical protein PPERSA_01924 [Pseudocohnilembus persalinus]	diamond	1029	82	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
25896803	25896803	PRJNA399711_S_NODE_77787_length_169_cov_12.500000_g77645_i0	PRJNA399711	77787	169	12.5	21.125	Colpoda	5979	SAR_Eukaryotes	SAR_Eukaryotes	302	1.27e-77	NTclustered	gi\|1802599797\|gb\|MT001206.1\|	41631	g77645	i0	98.817	99.1538461538462	169	2	100	0	1	169	680	512	Colpoda sp. strain HFCC1227 small subunit ribosomal RNA gene, partial sequence	blastn	16757	302	1	Eukaryota	Sar	Ciliophora	Colpodea	Colpodida	Colpodidae	Colpoda	Colpoda sp.
25896829	25896829	PRJNA399711_S_NODE_83227_length_165_cov_10.695312_g83085_i0	PRJNA399711	83227	165	10.695312	17.6472648	Colpoda	5979	SAR_Eukaryotes	SAR_Eukaryotes	303	3.45e-78	NTclustered	gi\|1802599796\|gb\|MT001205.1\|	41631	g83085	i0	100	100.139393939394	164	0	99	0	1	164	129	292	Colpoda sp. strain HFCC864 small subunit ribosomal RNA gene, partial sequence	blastn	16523	303	1	Eukaryota	Sar	Ciliophora	Colpodea	Colpodida	Colpodidae	Colpoda	Colpoda sp.
25971300	25971300	PRJNA399711_S_NODE_27116_length_247_cov_9.128571_g26974_i0	PRJNA399711	27116	247	9.128571	22.54757037	Colpoda sp.	41631	SAR_Eukaryotes	SAR_Eukaryotes	401	1.9199999999999992e-107	NTclustered	gi\|2651357791\|gb\|PP174306.1\|	41631	g26974	i0	96.694	97.7044534412955	242	7	98	1	6	247	3693	3453	Colpoda sp. isolate JGP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	24133	401	1	Eukaryota	Sar	Ciliophora	Colpodea	Colpodida	Colpodidae	Colpoda	Colpoda sp.
25971930	25971930	PRJNA399711_S_NODE_40812_length_214_cov_4.774011_g40670_i0	PRJNA399711	40812	214	4.774011	10.21638354	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	209	1.06e-49	NTclustered	gi\|11466252\|ref\|NC_000862.1\|	5908	g40670	i0	85.507	73.1168224299065	207	23	95	6	11	213	1149	946	Tetrahymena pyriformis mitochondrion, complete genome	blastn	15647	209	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
33111816	33111816	PRJNA399711_S_NODE_38366_length_219_cov_2.978022_g38224_i0	PRJNA399711	38366	219	2.978022	6.52186818	Ciliophora	5878	SAR_Eukaryotes	SAR_Eukaryotes	101	1.92e-24	NR	XP_004039566.1	5932	g38224	i0	94	5.47945205479452	50	3	68.5	0	2	151	200	249	XP_004039566.1 parkin co-regulated gene protein, putative [Ichthyophthirius multifiliis]	diamond	1200	101	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis

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);;