metadata: contig_metadata: 13 rows where bioproject = "PRJNA745553", tax_kingdom = "Pseudomonadati" and tax

13 rows where bioproject = "PRJNA745553", 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
3750311	3750311	PRJNA745553_S_NODE_12963_length_341_cov_23.052239_g12768_i0	PRJNA745553	12963	341	23.052239	78.60813499	Helicobacter	209	Bacteria	Bacteria	599	9.18e-167	NTclustered	gi\|50957170\|gb\|AY596255.1\|	37372	g12768	i0	99.695	123	328	0	96	1	15	341	276	603	Helicobacter bilis strain ATCC 51630 23S ribosomal RNA gene, partial sequence	blastn	41943	599	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter bilis
4552996	4552996	PRJNA745553_S_NODE_9704_length_389_cov_1.572785_g9509_i0	PRJNA745553	9704	389	1.572785	6.11813365	Helicobacter bilis	37372	Bacteria	Bacteria	664	0	NTclustered	gi\|1147511402\|gb\|CP019645.1\|	37372	g9509	i0	97.429	1	389	10	100	0	1	389	2544694	2545082	Helicobacter bilis strain AAQJH, complete genome	blastn	389	664	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter bilis
12203648	12203648	PRJNA745553_S_NODE_20990_length_270_cov_1.563452_g20795_i0	PRJNA745553	20990	270	1.563452	4.2213204	Helicobacter bilis	37372	Bacteria	Bacteria	370	6.02e-98	NTclustered	gi\|1147511402\|gb\|CP019645.1\|	37372	g20795	i0	92.913	0.940740740740741	254	18	94	0	1	254	1952810	1952557	Helicobacter bilis strain AAQJH, complete genome	blastn	254	370	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter bilis
12678209	12678209	PRJNA745553_S_NODE_11670_length_358_cov_17.112281_g11475_i0	PRJNA745553	11670	358	17.112281	61.26196598	Campylobacter	194	Bacteria	Bacteria	453	7.95e-123	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g11475	i0	98.824	177.360335195531	255	1	71	1	23	275	890	1144	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	63495	453	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
16501583	16501583	PRJNA745553_S_NODE_14173_length_327_cov_1.885827_g13978_i0	PRJNA745553	14173	327	1.885827	6.16665429	Campylobacter	194	Bacteria	Bacteria	604	1.8799999999999993e-168	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g13978	i0	100	235.535168195719	327	0	100	0	1	327	1033081	1032755	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	77020	604	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
17776455	17776455	PRJNA745553_S_NODE_5854_length_477_cov_4.232673_g5660_i0	PRJNA745553	5854	477	4.232673	20.18985021	Arcobacteraceae	2808963	Bacteria	Bacteria	704	0	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g5660	i0	94.518	398.310272536688	456	25	96	0	1	456	849704	850159	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	189994	710	0.991549295774648	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
19851295	19851295	PRJNA745553_S_NODE_25896_length_244_cov_3.584795_g25701_i0	PRJNA745553	25896	244	3.584795	8.7468998	Helicobacter bilis	37372	Bacteria	Bacteria	366	6.92e-97	NTclustered	gi\|1147511402\|gb\|CP019645.1\|	37372	g25701	i0	94.894	0.963114754098361	235	11	96	1	8	242	529586	529819	Helicobacter bilis strain AAQJH, complete genome	blastn	235	366	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter bilis
21600795	21600795	PRJNA745553_S_NODE_14817_length_320_cov_1.765182_g14622_i0	PRJNA745553	14817	320	1.765182	5.6485824	Campylobacter	194	Bacteria	Bacteria	556	5.22e-154	NTclustered	gi\|1938726479\|gb\|CP049270.1\|	199	g14622	i0	100	229.271875	301	0	94	0	1	301	1054178	1054478	Campylobacter concisus strain P26UCO-S2 chromosome, complete genome	blastn	73367	556	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
22401907	22401907	PRJNA745553_S_NODE_8818_length_406_cov_2.216216_g8623_i0	PRJNA745553	8818	406	2.216216	8.99783696	Helicobacter bilis	37372	Bacteria	Bacteria	230	1.6799999999999997e-55	NTclustered	gi\|1147511402\|gb\|CP019645.1\|	37372	g8623	i0	93.038	0.620689655172414	158	10	62	1	249	406	2543731	2543575	Helicobacter bilis strain AAQJH, complete genome	blastn	252	230	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter bilis
23677356	23677356	PRJNA745553_S_NODE_30719_length_196_cov_4.447154_g30524_i0	PRJNA745553	30719	196	4.447154	8.71642184	Sulfurospirillum sp. 'SP'	3023479	Bacteria	Bacteria	315	1.9599999999999999e-81	NTclustered	gi\|2591884127\|gb\|CP118373.1\|	3023479	g30524	i0	96.335	257.464285714286	191	7	97	0	1	191	1821285	1821095	Sulfurospirillum sp. 'SP' chromosome, complete genome	blastn	50463	315	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum sp. 'SP'
26672565	26672565	PRJNA745553_S_NODE_25621_length_245_cov_7.174419_g25426_i0	PRJNA745553	25621	245	7.174419	17.57732655	Helicobacter canadensis MIT 98-5491	537970	Bacteria	Bacteria	52	9.03e-7	NR	EFR49424.1	537970	g25426	i0	70.3	0.453061224489796	37	11	45.3	0	144	34	11	47	EFR49424.1 LOW QUALITY PROTEIN: hypothetical protein HCMG_01598, partial [Helicobacter canadensis MIT 98-5491]	diamond	111	52	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canadensis
28578692	28578692	PRJNA745553_S_NODE_20467_length_273_cov_4.670000_g20272_i0	PRJNA745553	20467	273	4.67	12.7491	root	1	Root_unresolved	Root_unresolved	58.5	1.1e-8	NR	KJD20933.1	32022	g20272	i0	46.7	4.04395604395604	60	32	65.9	0	41	220	48	107	KJD20933.1 hypothetical protein TM01_09170, partial [Campylobacter jejuni subsp. jejuni]	diamond	1104	58.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
29326338	29326338	PRJNA745553_S_NODE_27529_length_236_cov_2.392638_g27334_i0	PRJNA745553	27529	236	2.392638	5.64662568	Campylobacterales bacterium	2268180	Bacteria	Bacteria	43.1	0.024	NR	MDD3467525.1	2268180	g27334	i0	30.6	0.788135593220339	62	37	71.2	1	210	43	119	180	MDD3467525.1 glycosyltransferase [Campylobacterales bacterium]	diamond	186	43.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales 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);;