metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA314497" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA314497" and tax_kingdom = "Metazoa"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
16958014	16958014	PRJNA314497_S_NODE_474_length_349_cov_8.743750_g451_i0	PRJNA314497	474	349	8.74375	30.5156875	Culicoides brevitarsis	469753	Arthropoda	Arthropoda	187	1.84e-59	NR	XP_063703218.1	469753	g451	i0	89.9	0.851002865329513	99	10	85.1	0	14	310	1	99	XP_063703218.1 ATP synthase subunit g, mitochondrial [Culicoides brevitarsis]	diamond	297	187	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Ceratopogonidae	Culicoides	Culicoides brevitarsis
26631189	26631189	PRJNA314497_S_NODE_1521_length_179_cov_2.480000_g1498_i0	PRJNA314497	1521	179	2.48	4.4392	Barbourula kalimantanensis	877557	Chordata	Chordata	95.5	1.04e-22	NR	ADW79448.1	877557	g1498	i0	97.9	904.206703910615	48	1	80.4	0	178	35	103	150	ADW79448.1 cytochrome oxidase subunit I, partial [Barbourula kalimantanensis]	diamond	161853	96.3	0.991692627206646	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Barbourula	Barbourula kalimantanensis
30105808	30105808	PRJNA314497_S_NODE_372_length_397_cov_6.013587_g349_i0	PRJNA314497	372	397	6.013587	23.87394039	Culicoides sonorensis	179676	Arthropoda	Arthropoda	150	1.55e-44	NR	AAU06505.1	179676	g349	i0	84.4	0.581863979848867	77	12	58.2	0	352	122	1	77	AAU06505.1 unknown salivary protein [Culicoides sonorensis]	diamond	231	150	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Ceratopogonidae	Culicoides	Culicoides sonorensis
31306593	31306593	PRJNA314497_S_NODE_455_length_356_cov_6.348624_g432_i0	PRJNA314497	455	356	6.348624	22.60110144	Thrips palmi	161013	Arthropoda	Arthropoda	48.1	0.00175	NR	XP_034240145.1	161013	g432	i0	33.3	0.758426966292135	90	55	74.2	2	83	346	805	891	XP_034240145.1 uncharacterized protein LOC117644643 [Thrips palmi]	diamond	270	48.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Thrips	Thrips palmi
31703727	31703727	PRJNA314497_S_NODE_1277_length_200_cov_2.736842_g1254_i0	PRJNA314497	1277	200	2.736842	5.473684	Chordata	7711	Chordata	Chordata	99	2.81e-22	NR	NP_033640.1	7748	g1254	i0	74.2	264.3	66	17	99	0	2	199	252	317	NP_033640.1 cytochrome c oxidase subunit I [Lampetra fluviatilis]	diamond	52860	99	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
32760961	32760961	PRJNA314497_S_NODE_980_length_236_cov_2.507246_g957_i0	PRJNA314497	980	236	2.507246	5.91710056	Eleutherodactylus atkinsi	448426	Chordata	Chordata	88.6	2.32e-18	NR	AGN71168.1	448426	g957	i0	97.5	14.7457627118644	40	1	50.8	0	102	221	410	449	AGN71168.1 cytochrome c oxidase subunit I [Eleutherodactylus atkinsi]	diamond	3480	89	0.995505617977528	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Eleutherodactylidae	Eleutherodactylus	Eleutherodactylus atkinsi

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