metadata: contig_metadata: 11 rows where bioproject = "PRJNA994052", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA994052", 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
3825153	3825153	PRJNA994052_P_NODE_55123_length_233_cov_27.550000_g53868_i0	PRJNA994052	55123	233	27.55	64.1915	Bacteria	2	Bacteria	Bacteria	429	8.239999999999998e-116	NTclustered	gi\|1293068907\|gb\|MF134832.1\|	195	g53868	i0	100	54.7639484978541	232	0	99	0	1	232	1277	1046	Campylobacter coli strain ZTA14/01426 aminoglycoside 2-phosphotransferase IIIa (aph(2)-IIIa), 3-aminoglycoside o-phosphotransferase type IIIa (aph(3)-IIIa), phosphorylase (pnp), spectinomyicin adenyltransferase (aad9), erythromycin resistance methylase B (erm(B)), and Aad6 (aad6) genes, complete cds	blastn	12760	429	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
6377398	6377398	PRJNA994052_P_NODE_76925_length_204_cov_22.664122_g75668_i0	PRJNA994052	76925	204	22.664122	46.23480888	root	1	Root_unresolved	Root_unresolved	377	2.59e-100	NTclustered	gi\|2562786027\|gb\|CP120256.1\|	197	g75668	i0	100	124	204	0	100	0	1	204	1480998	1481201	Campylobacter jejuni strain PS_41_2021 chromosome, complete genome	blastn	25296	377	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
27910707	27910707	PRJNA994052_P_NODE_76705_length_204_cov_56.290076_g75448_i0	PRJNA994052	76705	204	56.290076	114.83175504	Desulfurellales bacterium	2482794	Bacteria	Bacteria	66.6	8.29e-11	NR	TXH41845.1	2482794	g75448	i0	53.1	0.941176470588235	64	29	92.6	1	8	196	640	703	TXH41845.1 MAG: hypothetical protein E6Q97_36780 [Desulfurellales bacterium]	diamond	192	66.6	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
28068769	28068769	PRJNA994052_P_NODE_37825_length_263_cov_21.563158_g36579_i0	PRJNA994052	37825	263	21.563158	56.71110554	Sulfuricurvum sp.	2025608	Bacteria	Bacteria	52	2.68e-5	NR	MBV5334712.1	2025608	g36579	i0	38.1	0.958174904942966	84	50	93.5	2	14	259	985	1068	MBV5334712.1 hypothetical protein [Sulfuricurvum sp.]	diamond	252	52	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Sulfuricurvum sp.
28132113	28132113	PRJNA994052_P_NODE_43785_length_251_cov_102.353933_g42537_i0	PRJNA994052	43785	251	102.353933	256.90837183	Helicobacter pylori	210	Bacteria	Bacteria	66.2	2.32e-12	NR	GAA9246243.1	210	g42537	i0	94.4	0.430278884462151	36	2	43	0	15	122	1	36	GAA9246243.1 hypothetical protein Kyoto199A_0360 [Helicobacter pylori]	diamond	108	66.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28485182	28485182	PRJNA994052_P_NODE_17606_length_312_cov_4.112971_g16385_i0	PRJNA994052	17606	312	4.112971	12.83246952	Bacteria	2	Bacteria	Bacteria	43.1	0.0307	NR	GAA9250408.1	210	g16385	i0	57.6	1.26923076923077	33	14	31.7	0	139	41	81	113	GAA9250408.1 hypothetical protein Kyoto199A_2030 [Helicobacter pylori]	diamond	396	43.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30632519	30632519	PRJNA994052_P_NODE_63493_length_221_cov_15.155405_g62237_i0	PRJNA994052	63493	221	15.155405	33.49344505	Pseudomonadati	3379134	Bacteria	Bacteria	90.5	4.1500000000000003e-22	NR	GAA8688303.1	210	g62237	i0	84.8	1.26244343891403	46	7	62.4	0	83	220	12	57	GAA8688303.1 hypothetical protein oki286_15360 [Helicobacter pylori]	diamond	279	90.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31859623	31859623	PRJNA994052_P_NODE_61217_length_224_cov_27.556291_g59961_i0	PRJNA994052	61217	224	27.556291	61.72609184	Desulfurellales bacterium	2482794	Bacteria	Bacteria	79	4.91e-15	NR	TXH55567.1	2482794	g59961	i0	53.5	0.950892857142857	71	33	95.1	0	1	213	46	116	TXH55567.1 MAG: hypothetical protein E6Q97_08580 [Desulfurellales bacterium]	diamond	213	79	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
31928849	31928849	PRJNA994052_P_NODE_71017_length_211_cov_26.971014_g69761_i0	PRJNA994052	71017	211	26.971014	56.90883954	Bacteria	2	Bacteria	Bacteria	60.8	1.24e-10	NR	GAA9037979.1	210	g69761	i0	71.4	2.28909952606635	35	10	49.8	0	207	103	3	37	GAA9037979.1 hypothetical protein Kyoto184A_00910 [Helicobacter pylori]	diamond	483	61.2	0.993464052287582	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32207866	32207866	PRJNA994052_P_NODE_57218_length_230_cov_21.286624_g55963_i0	PRJNA994052	57218	230	21.286624	48.9592352	Campylobacter coli	195	Bacteria	Bacteria	43.9	0.00151	NR	RJF75347.1	195	g55963	i0	59.5	0.482608695652174	37	15	48.3	0	111	1	22	58	RJF75347.1 hypothetical protein D4Z77_08730, partial [Campylobacter coli]	diamond	111	43.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
32902099	32902099	PRJNA994052_P_NODE_38180_length_262_cov_53.005291_g36934_i0	PRJNA994052	38180	262	53.005291	138.87386242	Helicobacter pylori	210	Bacteria	Bacteria	47.4	1e-4	NR	GAA6904105.1	210	g36934	i0	50	0.50381679389313	44	21	49.2	1	7	135	2	45	GAA6904105.1 hypothetical protein Kyoto207A_2120 [Helicobacter pylori]	diamond	132	47.4	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);;