metadata: contig_metadata: 14 rows where bioproject = "PRJNA879067", tax_kingdom = "Pseudomonadati" and tax

14 rows where bioproject = "PRJNA879067", 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
856290	856290	PRJNA879067_P_NODE_85481_length_316_cov_1.806584_g81995_i0	PRJNA879067	85481	316	1.806584	5.70880544	uncultured Aliarcobacter sp.	2321118	Bacteria	Bacteria	510	4.06e-140	NTclustered	gi\|2621785459\|emb\|OY781917.1\|	2321118	g81995	i0	98.611	2.92721518987342	288	4	91	0	1	288	1060077	1060364	MAG: uncultured Aliarcobacter sp. isolate 35e71162-57ce-4606-8f28-3f72018c63bd genome assembly, chromosome: 2	blastn	925	510	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	uncultured Aliarcobacter sp.
2514500	2514500	PRJNA879067_P_NODE_37682_length_650_cov_30.847487_g34259_i0	PRJNA879067	37682	650	30.847487	200.5086655	Campylobacter	194	Bacteria	Bacteria	1090	0	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g34259	i0	98.083	3.78	626	12	96	0	1	626	281449	282074	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	2457	1090	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
3791143	3791143	PRJNA879067_P_NODE_76863_length_353_cov_1.621429_g73377_i0	PRJNA879067	76863	353	1.621429	5.72364437	Aliarcobacter	2321111	Bacteria	Bacteria	597	3.42e-166	NTclustered	gi\|1896712910\|gb\|CP060264.1\|	28198	g73377	i0	99.392	35.8838526912181	329	2	93	0	25	353	1298643	1298315	Aliarcobacter cryaerophilus strain 16CS0369-1-AR-4 chromosome, complete genome	blastn	12667	597	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
14882744	14882744	PRJNA879067_P_NODE_32792_length_718_cov_4.141085_g29431_i0	PRJNA879067	32792	718	4.141085	29.7329903	Campylobacter showae	204	Bacteria	Bacteria	1149	0	NTclustered	gi\|1483583536\|emb\|LT631460.1\|	204	g29431	i0	95.556	5.01392757660167	720	28	100	4	1	718	2855	2138	Campylobacter showae strain 129_VTPP genome assembly, plasmid: I	blastn	3600	1149	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
14884515	14884515	PRJNA879067_P_NODE_95892_length_277_cov_1.509804_g92406_i0	PRJNA879067	95892	277	1.509804	4.18215708	Campylobacter vulpis	1655500	Bacteria	Bacteria	361	3.729999999999999e-95	NTclustered	gi\|1891168965\|gb\|CP041617.1\|	1655500	g92406	i0	92.52	0.916967509025271	254	16	91	2	26	277	643913	643661	Campylobacter vulpis strain 251/13 chromosome, complete genome	blastn	254	361	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vulpis
16158768	16158768	PRJNA879067_P_NODE_78773_length_344_cov_2.638376_g75287_i0	PRJNA879067	78773	344	2.638376	9.07601344	uncultured Aliarcobacter sp.	2321118	Bacteria	Bacteria	555	2.0299999999999995e-153	NTclustered	gi\|2621785459\|emb\|OY781917.1\|	2321118	g75287	i0	98.119	0.927325581395349	319	4	93	2	26	344	1161312	1161628	MAG: uncultured Aliarcobacter sp. isolate 35e71162-57ce-4606-8f28-3f72018c63bd genome assembly, chromosome: 2	blastn	319	555	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	uncultured Aliarcobacter sp.
17434621	17434621	PRJNA879067_P_NODE_92774_length_288_cov_1.609302_g89288_i0	PRJNA879067	92774	288	1.609302	4.63478976	Campylobacter ureolyticus	827	Bacteria	Bacteria	457	4.8299999999999984e-124	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g89288	i0	97.736	4.23263888888889	265	6	92	0	24	288	1237562	1237298	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	1219	457	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
19982374	19982374	PRJNA879067_P_NODE_64636_length_419_cov_2.465318_g61151_i0	PRJNA879067	64636	419	2.465318	10.32968242	Helicobacter typhlonius	76936	Bacteria	Bacteria	708	0	NTclustered	gi\|953940668\|emb\|LN907858.1\|	76936	g61151	i0	99.237	1.60143198090692	393	1	93	1	29	419	46141	45749	Helicobacter typhlonius genome assembly htyphlonius_mit97-6810, chromosome : I	blastn	671	708	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter typhlonius
21640817	21640817	PRJNA879067_P_NODE_101757_length_256_cov_1.382514_g98271_i0	PRJNA879067	101757	256	1.382514	3.53923584	Bacteria	2	Bacteria	Bacteria	411	3.329999999999999e-110	NTclustered	gi\|2030395107\|gb\|CP068586.1\|	195	g98271	i0	99.123	88.546875	228	2	89	0	29	256	1535826	1536053	Campylobacter coli strain CC19CH076 chromosome, complete genome	blastn	22668	411	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
21641255	21641255	PRJNA879067_P_NODE_67297_length_403_cov_2.169697_g63812_i0	PRJNA879067	67297	403	2.169697	8.74387891	Bacteria	2	Bacteria	Bacteria	676	0	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g63812	i0	98.698	95.2853598014888	384	0	94	2	1	379	556269	556652	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	38400	676	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
22532783	22532783	PRJNA879067_P_NODE_77358_length_351_cov_1.100719_g73872_i0	PRJNA879067	77358	351	1.100719	3.86352369	Pseudomonadati	3379134	Bacteria	Bacteria	154	3.2299999999999993e-46	NR	MCH3765100.1	195	g73872	i0	97.3	1.24786324786325	73	2	62.4	0	347	129	14	86	MCH3765100.1 hypothetical protein [Campylobacter coli]	diamond	438	154	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
25466021	25466021	PRJNA879067_P_NODE_87220_length_309_cov_1.957627_g83734_i0	PRJNA879067	87220	309	1.957627	6.04906743	Helicobacter	209	Bacteria	Bacteria	69.4	2.87e-7	NTclustered	gi\|2288874529\|dbj\|AP026684.1\|	35817	g83734	i0	100	3.01618122977346	37	0	12	0	208	244	717985	718021	Helicobacter heilmannii ASB1 DNA, complete genome	blastn	932	69.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter heilmannii
26873763	26873763	PRJNA879067_P_NODE_102321_length_253_cov_3.372222_g98835_i0	PRJNA879067	102321	253	3.372222	8.53172166	Bacteria	2	Bacteria	Bacteria	44.7	0.00247	NR	MDU9799813.1	210	g98835	i0	84.6	0.924901185770751	26	4	30.8	0	158	81	14	39	MDU9799813.1 hypothetical protein [Helicobacter pylori]	diamond	234	44.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28350130	28350130	PRJNA879067_P_NODE_72506_length_374_cov_6.289037_g69021_i0	PRJNA879067	72506	374	6.289037	23.52099838	Poseidonibacter antarcticus	2478538	Bacteria	Bacteria	90.5	1.69e-19	NR	WP_162984614.1	2478538	g69021	i0	36.9	1.8048128342246	122	74	97.9	1	372	7	45	163	WP_162984614.1 GAG-pre-integrase domain-containing protein, partial [Poseidonibacter antarcticus]	diamond	675	90.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Poseidonibacter	Poseidonibacter antarcticus

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