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

6 rows where analysis = "diamond", bioproject = "PRJNA393181" and tax_phylum = "Chordata"

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
13164090	13164090	PRJNA393181_S_NODE_22391_length_246_cov_2.636364_g22285_i0	PRJNA393181	22391	246	2.636364	6.48545544	root	1	Root_unresolved	Root_unresolved	70.5	2e-12	NR	MEE6515959.1	8439	g22285	i0	44.3	9.40243902439024	79	33	82.9	1	3	206	67	145	MEE6515959.1 hypothetical protein [Ascaphus truei]	diamond	2313	70.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ascaphidae	Ascaphus	Ascaphus truei
27675797	27675797	PRJNA393181_S_NODE_26384_length_222_cov_2.178378_g26278_i0	PRJNA393181	26384	222	2.178378	4.83599916	Lacerta agilis	80427	Chordata	Chordata	79.7	2.77e-15	NR	XP_033002290.1	80427	g26278	i0	63.1	1.75675675675676	65	21	87.8	2	195	1	1191	1252	XP_033002290.1 uncharacterized protein K02A2.6-like [Lacerta agilis]	diamond	390	79.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Lacerta	Lacerta agilis
27739073	27739073	PRJNA393181_S_NODE_44764_length_157_cov_1.300000_g44658_i0	PRJNA393181	44764	157	1.3	2.041	Mirounga leonina	9715	Chordata	Chordata	45.8	8.35e-4	NR	KAF3830524.1	9715	g44658	i0	64.7	0.974522292993631	51	18	97.5	0	155	3	98	148	KAF3830524.1 hypothetical protein GH733_004343 [Mirounga leonina]	diamond	153	45.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Mirounga	Mirounga leonina
27864851	27864851	PRJNA393181_S_NODE_37385_length_177_cov_1.821429_g37279_i0	PRJNA393181	37385	177	1.821429	3.22392933	Lacerta agilis	80427	Chordata	Chordata	91.7	8.89e-20	NR	XP_033002290.1	80427	g37279	i0	77.2	2.89830508474576	57	13	96.6	0	3	173	387	443	XP_033002290.1 uncharacterized protein K02A2.6-like [Lacerta agilis]	diamond	513	91.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Lacerta	Lacerta agilis
28906718	28906718	PRJNA393181_S_NODE_27948_length_214_cov_2.355932_g27842_i0	PRJNA393181	27948	214	2.355932	5.04169448	Strigops habroptila	2489341	Chordata	Chordata	42	0.0482	NR	XP_030331398.1	2489341	g27842	i0	36.2	0.658878504672897	47	30	65.9	0	195	55	105	151	XP_030331398.1 ancient ubiquitous protein 1 isoform X1 [Strigops habroptila]	diamond	141	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Psittaciformes	Psittacidae	Strigops	Strigops habroptila
29917462	29917462	PRJNA393181_S_NODE_30691_length_202_cov_1.339394_g30585_i0	PRJNA393181	30691	202	1.339394	2.70557588	Lacerta agilis	80427	Chordata	Chordata	99	3.53e-22	NR	XP_033002290.1	80427	g30585	i0	66.7	3.07425742574257	69	21	99.5	1	201	1	244	312	XP_033002290.1 uncharacterized protein K02A2.6-like [Lacerta agilis]	diamond	621	99	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Lacerta	Lacerta agilis

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