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

10 rows where analysis = "diamond", bioproject = "PRJNA382357" and tax_clade = "Amoebozoa"

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
26948355	26948355	PRJNA382357_P_NODE_101402_length_240_cov_491.061453_g100663_i0	PRJNA382357	101402	240	491.061453	1178.5474872	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	48.1	4.57e-4	NR	XP_004341866.1	1257118	g100663	i0	46.8	0.5875	47	25	58.8	0	100	240	135	181	XP_004341866.1 transmembrane 9 superfamily protein member 4, putative [Acanthamoeba castellanii str. Neff]	diamond	141	48.1	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
26948381	26948381	PRJNA382357_P_NODE_13762_length_576_cov_3.071845_g13041_i0	PRJNA382357	13762	576	3.071845	17.6938272	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	109	2.28e-25	NR	PRP84364.1	1890364	g13041	i0	35.3	1.625	156	98	80.2	2	464	3	16	170	PRP84364.1 GAF domain-containing protein [Planoprotostelium fungivorum]	diamond	936	109	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
27612271	27612271	PRJNA382357_P_NODE_142964_length_207_cov_1.904110_g142225_i0	PRJNA382357	142964	207	1.90411	3.9415077	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	89.7	3.16e-20	NR	PRP81360.1	1890364	g142225	i0	78.6	0.811594202898551	56	12	81.2	0	31	198	7	62	PRP81360.1 ribosomal protein L13 [Planoprotostelium fungivorum]	diamond	168	89.7	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
27833060	27833060	PRJNA382357_P_NODE_10984_length_634_cov_1.244328_g10276_i0	PRJNA382357	10984	634	1.244328	7.88903952	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	281	1.11e-83	NR	PRP79759.1	1890364	g10276	i0	78.9	0.851735015772871	180	37	85.2	1	3	542	535	713	PRP79759.1 non-ribosomal peptide synthetase [Planoprotostelium fungivorum]	diamond	540	281	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
28528042	28528042	PRJNA382357_P_NODE_46927_length_338_cov_1.407942_g46188_i0	PRJNA382357	46927	338	1.407942	4.75884396	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	63.2	7.56e-9	NR	PRP77639.1	1890364	g46188	i0	50	0.585798816568047	66	33	58.6	0	128	325	1	66	PRP77639.1 hypothetical protein PROFUN_00500 [Planoprotostelium fungivorum]	diamond	198	63.2	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
28969897	28969897	PRJNA382357_P_NODE_25268_length_445_cov_1.184896_g24530_i0	PRJNA382357	25268	445	1.184896	5.2727872	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	255	2.19e-81	NR	PRP89538.1	1890364	g24530	i0	75.5	0.964044943820225	143	35	96.4	0	444	16	108	250	PRP89538.1 hypothetical protein PROFUN_00802 [Planoprotostelium fungivorum]	diamond	429	255	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
29664110	29664110	PRJNA382357_P_NODE_19650_length_496_cov_5.009195_g18917_i0	PRJNA382357	19650	496	5.009195	24.8456072	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	48.5	0.00449	NR	PRP73928.1	1890364	g18917	i0	35.1	0.465725806451613	77	49	46.6	1	2	232	250	325	PRP73928.1 hypothetical protein PROFUN_08121 [Planoprotostelium fungivorum]	diamond	231	48.5	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30485885	30485885	PRJNA382357_P_NODE_50553_length_326_cov_21.290566_g49814_i0	PRJNA382357	50553	326	21.290566	69.40724516	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	121	2.04e-29	NR	PRP78553.1	1890364	g49814	i0	63	0.920245398773006	100	32	92	2	325	26	264	358	PRP78553.1 hypothetical protein PROFUN_13610 [Planoprotostelium fungivorum]	diamond	300	121	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
32224872	32224872	PRJNA382357_P_NODE_1458_length_1411_cov_3.008889_g1041_i0	PRJNA382357	1458	1411	3.008889	42.45542379	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	56.2	1.68e-4	NR	XP_012759471.1	1410327	g1041	i0	28	0.372076541459957	175	113	34.9	5	357	848	157	329	XP_012759471.1 hypothetical protein SAMD00019534_005840 [Acytostelium subglobosum LB1]	diamond	525	56.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
32761688	32761688	PRJNA382357_P_NODE_135740_length_210_cov_19.322148_g135001_i0	PRJNA382357	135740	210	19.322148	40.5765108	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	45.4	0.00277	NR	PRP76823.1	1890364	g135001	i0	61.4	0.628571428571429	44	15	61.4	2	7	135	244	286	PRP76823.1 hypothetical protein PROFUN_14863 [Planoprotostelium fungivorum]	diamond	132	45.4	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum

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