metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA716463" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA716463" 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
22385733	22385733	PRJNA716463_P_NODE_63738_length_281_cov_1.875000_g63321_i0	PRJNA716463	63738	281	1.875	5.26875	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	162	1.8199999999999993e-46	NR	MEE6488266.1	8439	g63321	i0	87.1	90.3523131672598	93	12	99.3	0	280	2	256	348	MEE6488266.1 hypothetical protein [Ascaphus truei]	diamond	25389	163	0.993865030674847	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ascaphidae	Ascaphus	Ascaphus truei
26904400	26904400	PRJNA716463_P_NODE_88661_length_261_cov_2.962766_g88244_i0	PRJNA716463	88661	261	2.962766	7.73281926	Chordata	7711	Chordata	Chordata	43.5	0.024	NR	KAH0521510.1	79684	g88244	i0	78.3	1.7816091954023	23	5	26.4	0	13	81	175	197	KAH0521510.1 Elongation factor 2 [Microtus ochrogaster]	diamond	465	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Microtus	Microtus ochrogaster
28536553	28536553	PRJNA716463_P_NODE_120087_length_228_cov_3.316129_g119669_i0	PRJNA716463	120087	228	3.316129	7.56077412	Muntiacus reevesi	9886	Chordata	Chordata	88.2	3.07e-18	NR	KAB0374953.1	9886	g119669	i0	82.7	0.684210526315789	52	9	68.4	0	27	182	554	605	KAB0374953.1 hypothetical protein FD755_013445, partial [Muntiacus reevesi]	diamond	156	88.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Muntiacus	Muntiacus reevesi
28978498	28978498	PRJNA716463_P_NODE_115548_length_236_cov_2.447853_g115130_i0	PRJNA716463	115548	236	2.447853	5.77693308	Varanus komodoensis	61221	Chordata	Chordata	75.5	9.78e-14	NR	KAF7248270.1	61221	g115130	i0	58.6	0.889830508474576	70	28	87.7	1	225	19	240	309	KAF7248270.1 Cytoplasmic polyadenylation element-binding protein 2 [Varanus komodoensis]	diamond	210	75.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Varanidae	Varanus	Varanus komodoensis
29420243	29420243	PRJNA716463_P_NODE_81569_length_267_cov_2.427835_g81152_i0	PRJNA716463	81569	267	2.427835	6.48231945	Hyperolius riggenbachi	752182	Chordata	Chordata	67	1.4e-10	NR	XP_068137380.1	752182	g81152	i0	39.7	1.74157303370787	78	43	87.6	1	256	23	352	425	XP_068137380.1 nucleolin [Hyperolius riggenbachi]	diamond	465	67	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hyperoliidae	Hyperolius	Hyperolius riggenbachi

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