metadata: contig_metadata: 7 rows where bioproject = "PRJNA849646", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA849646", 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
3388958	3388958	PRJNA849646_P_NODE_28403_length_252_cov_2.346369_g28285_i0	PRJNA849646	28403	252	2.346369	5.91284988	Campylobacter armoricus	2505970	Bacteria	Bacteria	65.8	2.94e-6	NTclustered	gi\|1861371805\|gb\|CP053825.1\|	2505970	g28285	i0	84.286	4.83333333333333	70	8	27	3	175	241	217887	217956	Campylobacter armoricus strain CCUG 73571 chromosome, complete genome	blastn	1218	65.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter armoricus
19964513	19964513	PRJNA849646_P_NODE_14476_length_279_cov_1.495146_g14358_i0	PRJNA849646	14476	279	1.495146	4.17145734	Campylobacter concisus	199	Bacteria	Bacteria	477	3.5799999999999985e-130	NTclustered	gi\|1938719709\|gb\|CP049264.1\|	199	g14358	i0	97.491	16.4086021505376	279	7	100	0	1	279	698304	698582	Campylobacter concisus strain P11CDO-S1 chromosome, complete genome	blastn	4578	477	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
21240069	21240069	PRJNA849646_P_NODE_10237_length_287_cov_2.079439_g10119_i0	PRJNA849646	10237	287	2.079439	5.96798993	Campylobacter gracilis	824	Bacteria	Bacteria	459	1.3399999999999999e-124	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g10119	i0	95.238	2.04878048780488	294	6	99	5	1	286	1532380	1532087	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	588	459	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
27276252	27276252	PRJNA849646_P_NODE_23143_length_262_cov_2.354497_g23025_i0	PRJNA849646	23143	262	2.354497	6.16878214	Campylobacter concisus	199	Bacteria	Bacteria	169	5.12e-49	NR	WP_107970286.1	199	g23025	i0	98.9	0.99618320610687	87	1	99.6	0	2	262	58	144	WP_107970286.1 PD-(D/E)XK nuclease family protein [Campylobacter concisus]	diamond	261	169	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
27789873	27789873	PRJNA849646_P_NODE_1084_length_477_cov_3.571782_g967_i0	PRJNA849646	1084	477	3.571782	17.03740014	root	1	Root_unresolved	Root_unresolved	128	3.63e-31	NR	TXH41244.1	2482794	g967	i0	44.9	1.89308176100629	147	81	92.5	0	3	443	268	414	TXH41244.1 MAG: hypothetical protein E6Q97_38065 [Desulfurellales bacterium]	diamond	903	128	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
30054717	30054717	PRJNA849646_P_NODE_24751_length_259_cov_2.446237_g24633_i0	PRJNA849646	24751	259	2.446237	6.33575383	Campylobacterota bacterium	2026809	Bacteria	Bacteria	97.1	2.7500000000000003e-21	NR	MEA2017174.1	2026809	g24633	i0	51.8	0.984555984555985	85	41	98.5	0	255	1	353	437	MEA2017174.1 Fic family protein [Campylobacterota bacterium]	diamond	255	97.1	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
30086408	30086408	PRJNA849646_P_NODE_832_length_540_cov_2.115632_g716_i0	PRJNA849646	832	540	2.115632	11.4244128	Desulfurellales bacterium	2482794	Bacteria	Bacteria	155	8.37e-44	NR	TXH41228.1	2482794	g716	i0	84.1	0.488888888888889	88	14	48.9	0	264	1	10	97	TXH41228.1 MAG: FAD-dependent thymidylate synthase [Desulfurellales bacterium]	diamond	264	155	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium

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