metadata: contig_metadata: 5 rows where bioproject = "PRJNA896973", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA896973", 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
3795960	3795960	PRJNA896973_P_NODE_29223_length_203_cov_4.461538_g29129_i0	PRJNA896973	29223	203	4.461538	9.05692214	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	171	4.68e-38	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g29129	i0	97.03	2.57635467980296	101	3	50	0	1	101	2982	3082	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	523	171	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
16546496	16546496	PRJNA896973_P_NODE_13313_length_306_cov_4.214592_g13219_i0	PRJNA896973	13313	306	4.214592	12.89665152	Litostomatea	5988	SAR_Eukaryotes	SAR_Eukaryotes	372	1.93e-98	NTclustered	gi\|375305431\|gb\|JF975391.1\|	1143725	g13219	i0	88.599	89.516339869281	307	34	100	1	1	306	1535	1841	Paraspathidium apofuscum isolate FXP08102701 28S ribosomal RNA gene, partial sequence	blastn	27392	375	0.992	Eukaryota	Sar	Ciliophora	Litostomatea	Haptorida	Paraspathidiidae	Paraspathidium	Paraspathidium apofuscum
18724915	18724915	PRJNA896973_S_NODE_1095_length_355_cov_4.617021_g1081_i0	PRJNA896973	1095	355	4.617021	16.39042455	Euplotes aediculatus	5940	SAR_Eukaryotes	SAR_Eukaryotes	575	1.6099999999999995e-159	NTclustered	gi\|6980030\|gb\|AF223571.1\|AF223571	5940	g1081	i0	96.045	94.7352112676056	354	13	99	1	2	355	546	898	Euplotes aediculatus internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	33631	575	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Euplotes	Euplotes aediculatus
21275270	21275270	PRJNA896973_P_NODE_28657_length_233_cov_3.706250_g28563_i0	PRJNA896973	28657	233	3.70625	8.6355625	Epistylis sp. 6	2979169	SAR_Eukaryotes	SAR_Eukaryotes	364	2.359999999999999e-96	NTclustered	gi\|2304601482\|gb\|OP458303.1\|	2979169	g28563	i0	94.85	28.656652360515	233	12	100	0	1	233	391	623	Epistylis sp. 6 large subunit ribosomal RNA gene, partial sequence	blastn	6677	364	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Epistylidae	Epistylis	Epistylis sp. 6
32773828	32773828	PRJNA896973_S_NODE_2800_length_244_cov_1.198830_g2786_i0	PRJNA896973	2800	244	1.19883	2.9251452	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	76.6	2.15e-14	NR	CAI2374926.1	5936	g2786	i0	47.5	0.983606557377049	80	42	98.4	0	242	3	224	303	CAI2374926.1 unnamed protein product [Moneuplotes crassus]	diamond	240	76.6	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus

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