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

5 rows where analysis = "diamond", bioproject = "PRJNA800090" and tax_phylum = "Campylobacterota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
28926165	28926165	PRJNA800090_P_NODE_71108_length_404_cov_0.979104_g68923_i0	PRJNA800090	71108	404	0.979104	3.95558016	Bacteria	2	Bacteria	Bacteria	64.3	5.03e-9	NR	MDR1615092.1	2268179	g68923	i0	46.6	2.16831683168317	73	39	54.2	0	391	173	16	88	MDR1615092.1 hypothetical protein [Campylobacteraceae bacterium]	diamond	876	64.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae		Campylobacteraceae bacterium
29769680	29769680	PRJNA800090_P_NODE_145311_length_261_cov_1.000000_g143126_i0	PRJNA800090	145311	261	1	2.61	Campylobacteraceae bacterium	2268179	Bacteria	Bacteria	51.2	4.62e-5	NR	MDR1615017.1	2268179	g143126	i0	39.3	1.02298850574713	89	47	94.3	5	261	16	81	169	MDR1615017.1 hypothetical protein [Campylobacteraceae bacterium]	diamond	267	51.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae		Campylobacteraceae bacterium
30307363	30307363	PRJNA800090_P_NODE_176332_length_234_cov_1.515152_g174147_i0	PRJNA800090	176332	234	1.515152	3.54545568	Campylobacter troglodytis	654363	Bacteria	Bacteria	40.4	0.0491	NR	TQR61090.1	654363	g174147	i0	38.9	0.692307692307692	54	29	67.9	2	211	53	36	86	TQR61090.1 hypothetical protein DMC01_02855 [Campylobacter troglodytis]	diamond	162	40.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter troglodytis
30307368	30307368	PRJNA800090_P_NODE_184592_length_231_cov_0.901235_g182407_i0	PRJNA800090	184592	231	0.901235	2.08185285	Helicobacteraceae bacterium	2212472	Bacteria	Bacteria	76.6	2.44e-14	NR	MDR0746336.1	2212472	g182407	i0	43.2	0.961038961038961	74	42	96.1	0	10	231	54	127	MDR0746336.1 hypothetical protein [Helicobacteraceae bacterium]	diamond	222	76.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae		Helicobacteraceae bacterium
32339509	32339509	PRJNA800090_P_NODE_150359_length_256_cov_1.037433_g148174_i0	PRJNA800090	150359	256	1.037433	2.65582848	root	1	Root_unresolved	Root_unresolved	42	0.012	NR	GAA6904105.1	210	g148174	i0	65.5	1.03125	29	10	34	0	205	119	45	73	GAA6904105.1 hypothetical protein Kyoto207A_2120 [Helicobacter pylori]	diamond	264	42.4	0.990566037735849	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori

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