metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA939369" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA939369" 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
16217550	16217550	PRJNA939369_S_NODE_72433_length_243_cov_0.905882_g72016_i0	PRJNA939369	72433	243	0.905882	2.20129326	Ciliophora	5878	SAR_Eukaryotes	SAR_Eukaryotes	100	2.41e-22	NR	KAL4436229.1	5901	g72016	i0	63.6	5.91358024691358	77	25	91.4	1	241	20	173	249	KAL4436229.1 hypothetical protein ABPG74_015820 [Tetrahymena malaccensis]	diamond	1437	100	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
26803354	26803354	PRJNA939369_S_NODE_28601_length_305_cov_0.995690_g28184_i0	PRJNA939369	28601	305	0.99569	3.0368545	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	73.6	3.63e-13	NR	XP_004032259.1	5932	g28184	i0	40.7	0.895081967213115	91	54	89.5	0	283	11	20	110	XP_004032259.1 hypothetical protein IMG5_126280, partial [Ichthyophthirius multifiliis]	diamond	273	73.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
26842335	26842335	PRJNA939369_S_NODE_61801_length_248_cov_0.880000_g61384_i0	PRJNA939369	61801	248	0.88	2.1824	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	89	4.52e-20	NR	TNV75589.1	5974	g61384	i0	63.9	8.9758064516129	72	25	87.1	1	245	30	101	171	TNV75589.1 hypothetical protein FGO68_gene3445 [Halteria grandinella]	diamond	2226	89	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Halteriidae	Halteria	Halteria grandinella
27909167	27909167	PRJNA939369_S_NODE_61365_length_248_cov_0.880000_g60948_i0	PRJNA939369	61365	248	0.88	2.1824	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	68.2	4.28e-11	NR	CDW86847.1	5949	g60948	i0	57.5	0.967741935483871	80	34	96.8	0	247	8	334	413	CDW86847.1 UNKNOWN [Stylonychia lemnae]	diamond	240	68.2	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
28635919	28635919	PRJNA939369_S_NODE_75887_length_241_cov_0.916667_g75470_i0	PRJNA939369	75887	241	0.916667	2.20916747	Paramecium octaurelia	43137	SAR_Eukaryotes	SAR_Eukaryotes	52.8	9.04e-6	NR	CAD8157178.1	43137	g75470	i0	39.2	0.921161825726141	74	44	90.9	1	11	229	107	180	CAD8157178.1 unnamed protein product [Paramecium octaurelia]	diamond	222	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
29614134	29614134	PRJNA939369_S_NODE_75890_length_241_cov_0.916667_g75473_i0	PRJNA939369	75890	241	0.916667	2.20916747	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.00175	NR	CDW77678.1	5949	g75473	i0	41.4	0.721991701244813	58	30	72.2	1	2	175	51	104	CDW77678.1 uncharacterized protein at2g34160-like [Stylonychia lemnae]	diamond	174	45.1	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
32213429	32213429	PRJNA939369_S_NODE_62018_length_248_cov_0.880000_g61601_i0	PRJNA939369	62018	248	0.88	2.1824	Spirotrichea	33829	SAR_Eukaryotes	SAR_Eukaryotes	107	2.3599999999999997e-25	NR	CAI2368938.1	5936	g61601	i0	58	2.95161290322581	81	34	98	0	243	1	312	392	CAI2368938.1 unnamed protein product [Moneuplotes crassus]	diamond	732	107	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
32269782	32269782	PRJNA939369_S_NODE_76298_length_241_cov_0.916667_g75881_i0	PRJNA939369	76298	241	0.916667	2.20916747	Philasterides dicentrarchi	282688	SAR_Eukaryotes	SAR_Eukaryotes	66.2	1.91e-10	NR	AWX67871.1	282688	g75881	i0	38.5	1.92946058091286	78	48	97.1	0	6	239	4099	4176	AWX67871.1 dynein heavy chain 17 [Philasterides dicentrarchi]	diamond	465	66.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Philasteridae	Philasterides	Philasterides dicentrarchi
32427875	32427875	PRJNA939369_S_NODE_75979_length_241_cov_0.916667_g75562_i0	PRJNA939369	75979	241	0.916667	2.20916747	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	55.1	8.54e-7	NR	KRX05012.1	266149	g75562	i0	42.9	0.784232365145228	63	29	78.4	2	42	230	1	56	KRX05012.1 hypothetical protein PPERSA_06646 [Pseudocohnilembus persalinus]	diamond	189	55.1	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
32774722	32774722	PRJNA939369_S_NODE_58600_length_249_cov_1.181818_g58183_i0	PRJNA939369	58600	249	1.181818	2.94272682	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	115	5.800000000000001e-30	NR	OMJ75804.1	5963	g58183	i0	63.9	2	83	30	100	0	249	1	77	159	OMJ75804.1 hypothetical protein SteCoe_24985 [Stentor coeruleus]	diamond	498	115	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus

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