metadata: contig_metadata: 5 rows where bioproject = "PRJNA812001", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA812001", tax_kingdom = "Pseudomonadati" 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
5052573	5052573	PRJNA812001_P_NODE_89984_length_249_cov_0.875000_g89738_i0	PRJNA812001	89984	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	459	1.1399999999999998e-124	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g89738	i0	100	113.542168674699	248	0	99	0	2	249	315732	315485	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	28272	459	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
22487350	22487350	PRJNA812001_P_NODE_25498_length_351_cov_44.143885_g25252_i0	PRJNA812001	25498	351	44.143885	154.94503635	Desulfurellales bacterium	2482794	Bacteria	Bacteria	130	2.52e-32	NR	TXH53568.1	2482794	g25252	i0	59.8	0.871794871794872	102	39	85.5	1	45	344	247	348	TXH53568.1 MAG: hypothetical protein E6Q97_12950 [Desulfurellales bacterium]	diamond	306	130	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
29462691	29462691	PRJNA812001_P_NODE_129450_length_242_cov_0.911243_g129204_i0	PRJNA812001	129450	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	52	8.52e-7	NR	GAA8997938.1	210	g129204	i0	51	8.85123966942149	51	25	63.2	0	177	25	7	57	GAA8997938.1 hypothetical protein Kyoto181A_6390 [Helicobacter pylori]	diamond	2142	52	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30780955	30780955	PRJNA812001_P_NODE_71914_length_259_cov_1.586022_g71668_i0	PRJNA812001	71914	259	1.586022	4.10779698	Helicobacter pylori	210	Bacteria	Bacteria	72.8	5.19e-15	NR	GAA8812112.1	210	g71668	i0	51.4	0.833976833976834	72	10	83.4	1	249	34	2	48	GAA8812112.1 hypothetical protein Kyoto149A_3190 [Helicobacter pylori]	diamond	216	72.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32615100	32615100	PRJNA812001_P_NODE_51220_length_288_cov_0.953488_g50974_i0	PRJNA812001	51220	288	0.953488	2.74604544	Helicobacter pylori	210	Bacteria	Bacteria	43.1	0.00437	NR	GAA8930966.1	210	g50974	i0	51.1	0.916666666666667	45	15	39.6	2	134	21	2	46	GAA8930966.1 hypothetical protein Kyoto166A_4300 [Helicobacter pylori]	diamond	264	43.1	1	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);;