metadata: contig_metadata: 9 rows where bioproject = "PRJNA782551", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJNA782551", 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
4592002	4592002	PRJNA782551_P_NODE_21644_length_244_cov_1.368421_g21522_i0	PRJNA782551	21644	244	1.368421	3.33894724	Campylobacter showae	204	Bacteria	Bacteria	396	8.829999999999997e-106	NTclustered	gi\|1622747600\|gb\|CP012544.1\|	204	g21522	i0	95.902	10.6516393442623	244	10	100	0	1	244	396894	397137	Campylobacter showae strain ATCC 51146 chromosome, complete genome	blastn	2599	396	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
5867183	5867183	PRJNA782551_P_NODE_2065_length_678_cov_2.277686_g1949_i0	PRJNA782551	2065	678	2.277686	15.44271108	Campylobacter showae	204	Bacteria	Bacteria	1247	0	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g1949	i0	99.853	227.37610619469	678	1	100	0	1	678	389859	389182	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	154161	1247	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
7142179	7142179	PRJNA782551_P_NODE_18406_length_248_cov_0.880000_g18284_i0	PRJNA782551	18406	248	0.88	2.1824	Campylobacter showae	204	Bacteria	Bacteria	398	2.5e-106	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g18284	i0	95.565	9.54838709677419	248	11	100	0	1	248	1301537	1301290	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	2368	398	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
7142254	7142254	PRJNA782551_P_NODE_23546_length_242_cov_0.911243_g23424_i0	PRJNA782551	23546	242	0.911243	2.20520806	Campylobacter showae	204	Bacteria	Bacteria	276	1.19e-69	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g23424	i0	87.19	9	242	31	100	0	1	242	66783	66542	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	2178	276	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
12243156	12243156	PRJNA782551_P_NODE_10930_length_287_cov_1.439252_g10808_i0	PRJNA782551	10930	287	1.439252	4.13065324	Campylobacter rectus	203	Bacteria	Bacteria	470	6.18e-128	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g10808	i0	96.491	3.96515679442509	285	9	99	1	1	285	1213577	1213294	Campylobacter rectus strain ATCC 33238, complete genome	blastn	1138	470	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
21166238	21166238	PRJNA782551_P_NODE_17617_length_249_cov_0.875000_g17495_i0	PRJNA782551	17617	249	0.875	2.17875	Campylobacter rectus	203	Bacteria	Bacteria	418	1.9299999999999995e-112	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g17495	i0	97.166	152.618473895582	247	7	99	0	3	249	157332	157578	Campylobacter rectus strain ATCC 33238, complete genome	blastn	38002	418	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
22441021	22441021	PRJNA782551_P_NODE_20298_length_246_cov_0.890173_g20176_i0	PRJNA782551	20298	246	0.890173	2.18982558	Campylobacter showae	204	Bacteria	Bacteria	388	1.49e-103	NTclustered	gi\|1483583493\|emb\|LT631417.1\|	204	g20176	i0	95.122	9.01626016260163	246	12	100	0	1	246	778986	778741	Campylobacter showae genome assembly, chromosome: I	blastn	2218	388	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
23716474	23716474	PRJNA782551_P_NODE_18399_length_248_cov_0.880000_g18277_i0	PRJNA782551	18399	248	0.88	2.1824	Campylobacter showae	204	Bacteria	Bacteria	335	1.9899999999999996e-87	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g18277	i0	94.091	8.5241935483871	220	13	89	0	2	221	1427071	1426852	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	2114	335	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
31380972	31380972	PRJNA782551_P_NODE_19196_length_247_cov_0.885057_g19074_i0	PRJNA782551	19196	247	0.885057	2.18609079	Helicobacter pylori	210	Bacteria	Bacteria	69.7	2.54e-13	NR	GAA6795649.1	210	g19074	i0	84.4	1.91902834008097	77	12	93.5	0	245	15	22	98	GAA6795649.1 hypothetical protein Kyoto200A_0500 [Helicobacter pylori]	diamond	474	69.7	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);;