metadata: contig_metadata: 3 rows where analysis = "diamond", bioproject = "PRJNA728642" and tax

3 rows where analysis = "diamond", bioproject = "PRJNA728642" 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
26640750	26640750	PRJNA728642_P_NODE_20001_length_230_cov_2.280255_g19730_i0	PRJNA728642	20001	230	2.280255	5.2445865	Phodopus roborovskii	109678	Chordata	Chordata	43.1	0.0226	NR	XP_051031607.1	109678	g19730	i0	33.9	0.808695652173913	62	39	80.9	1	17	202	33	92	XP_051031607.1 LOW QUALITY PROTEIN: mucin-12-like, partial [Phodopus roborovskii]	diamond	186	43.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Phodopus	Phodopus roborovskii
27431790	27431790	PRJNA728642_P_NODE_10463_length_313_cov_2.566667_g10192_i0	PRJNA728642	10463	313	2.566667	8.03366771	Microcaecilia unicolor	1415580	Chordata	Chordata	44.7	0.0189	NR	XP_030045814.1	1415580	g10192	i0	34.9	0.603833865814696	63	39	58.5	1	58	240	754	816	XP_030045814.1 LOW QUALITY PROTEIN: thyroglobulin [Microcaecilia unicolor]	diamond	189	44.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Gymnophiona	Siphonopidae	Microcaecilia	Microcaecilia unicolor
30937140	30937140	PRJNA728642_P_NODE_11734_length_295_cov_1.004505_g11463_i0	PRJNA728642	11734	295	1.004505	2.96328975	Sus scrofa	9823	Chordata	Chordata	197	1.11e-58	NR	XP_020938199.1	9823	g11463	i0	99	2.98983050847458	98	1	99.7	0	2	295	324	421	XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa]	diamond	882	197	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa

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