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

14 rows where bioproject = "PRJEB81463", 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
1415162	1415162	PRJEB81463_P_NODE_27042_length_243_cov_1.835294_g26770_i0	PRJEB81463	27042	243	1.835294	4.45976442	Sulfurospirillum sp. UCH001	1581011	Bacteria	Bacteria	243	1.2100000000000004e-59	NTclustered	gi\|757804895\|dbj\|AP014723.1\|	1581011	g26770	i0	84.711	0.995884773662551	242	37	99	0	1	242	1317577	1317336	Sulfurospirillum sp. UCH001 DNA, complete genome	blastn	242	243	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum sp. UCH001
2690627	2690627	PRJEB81463_P_NODE_27123_length_243_cov_1.517647_g26851_i0	PRJEB81463	27123	243	1.517647	3.68788221	Sulfurospirillum sp. 'SP'	3023479	Bacteria	Bacteria	411	3.14e-110	NTclustered	gi\|2591884127\|gb\|CP118373.1\|	3023479	g26851	i0	97.119	2	243	7	100	0	1	243	1212705	1212947	Sulfurospirillum sp. 'SP' chromosome, complete genome	blastn	486	411	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum sp. 'SP'
14168832	14168832	PRJEB81463_P_NODE_20452_length_253_cov_0.866667_g20180_i0	PRJEB81463	20452	253	0.866667	2.19266751	Campylobacter jejuni	197	Bacteria	Bacteria	154	2.6599999999999998e-46	NR	EOH1988414.1	197	g20180	i0	94	0.99604743083004	84	5	99.6	0	2	253	30	113	EOH1988414.1 hypothetical protein [Campylobacter jejuni]	diamond	252	154	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
15025300	15025300	PRJEB81463_P_NODE_8472_length_345_cov_1.661765_g8200_i0	PRJEB81463	8472	345	1.661765	5.73308925	Campylobacter jejuni	197	Bacteria	Bacteria	143	3.929999999999999e-42	NR	WP_240380582.1	197	g8200	i0	98.7	1.34782608695652	77	1	67	0	1	231	9	85	WP_240380582.1 chromate transporter, partial [Campylobacter jejuni]	diamond	465	143	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
16717255	16717255	PRJEB81463_P_NODE_27514_length_243_cov_0.917647_g27242_i0	PRJEB81463	27514	243	0.917647	2.22988221	Arcobacter roscoffensis	2961520	Bacteria	Bacteria	337	5.399999999999998e-88	NTclustered	gi\|2270258285\|gb\|CP100595.1\|	2961520	g27242	i0	92.083	0.987654320987654	240	17	98	2	5	243	35447	35209	Arcobacter roscoffensis strain ARW1-2F2 chromosome, complete genome	blastn	240	337	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter roscoffensis
18849110	18849110	PRJEB81463_P_NODE_27235_length_243_cov_0.917647_g26963_i0	PRJEB81463	27235	243	0.917647	2.22988221	Helicobacter	209	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2165146657\|gb\|CP089283.1\|	210	g26963	i0	100	100	243	0	100	0	1	243	1430785	1430543	Helicobacter pylori strain J99 derivative isolate D1 chromosome, complete genome	blastn	24300	449	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
20541273	20541273	PRJEB81463_P_NODE_12817_length_289_cov_1.083333_g12545_i0	PRJEB81463	12817	289	1.083333	3.13083237	Campylobacter jejuni	197	Bacteria	Bacteria	97.4	2.48e-24	NR	MBP0443134.1	197	g12545	i0	100	0.519031141868512	50	0	51.9	0	150	1	1	50	MBP0443134.1 hypothetical protein [Campylobacter jejuni]	diamond	150	97.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
21399481	21399481	PRJEB81463_P_NODE_28097_length_242_cov_0.923077_g27825_i0	PRJEB81463	28097	242	0.923077	2.23384634	Helicobacter	209	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2165146657\|gb\|CP089283.1\|	210	g27825	i0	100	193.181818181818	242	0	100	0	1	242	578545	578786	Helicobacter pylori strain J99 derivative isolate D1 chromosome, complete genome	blastn	46750	448	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28234219	28234219	PRJEB81463_P_NODE_16586_length_269_cov_1.301020_g16314_i0	PRJEB81463	16586	269	1.30102	3.4997438	Aliarcobacter sp.	2321116	Bacteria	Bacteria	164	2.3199999999999993e-47	NR	MEZ4694713.1	2321116	g16314	i0	88.8	0.992565055762082	89	10	99.3	0	1	267	271	359	MEZ4694713.1 diguanylate cyclase [Aliarcobacter sp.]	diamond	267	164	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter sp.
30445201	30445201	PRJEB81463_P_NODE_25353_length_246_cov_0.901734_g25081_i0	PRJEB81463	25353	246	0.901734	2.21826564	Desulfurellales bacterium	2482794	Bacteria	Bacteria	60.8	4.06e-9	NR	TXH51128.1	2482794	g25081	i0	47	0.804878048780488	66	35	80.5	0	48	245	24	89	TXH51128.1 MAG: hypothetical protein E6Q97_19035 [Desulfurellales bacterium]	diamond	198	60.8	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
30508239	30508239	PRJEB81463_P_NODE_19693_length_254_cov_2.486188_g19421_i0	PRJEB81463	19693	254	2.486188	6.31491752	Sulfurovum sp.	1969726	Bacteria	Bacteria	45.1	0.00625	NR	MCB4784482.1	1969726	g19421	i0	31.9	0.81496062992126	69	47	81.5	0	211	5	12	80	MCB4784482.1 hypothetical protein [Sulfurovum sp.]	diamond	207	45.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
31171463	31171463	PRJEB81463_P_NODE_16435_length_270_cov_0.817259_g16163_i0	PRJEB81463	16435	270	0.817259	2.2065993	Helicobacter pylori	210	Bacteria	Bacteria	143	2.0499999999999998e-42	NR	GAA8683247.1	210	g16163	i0	95.1	0.911111111111111	82	4	91.1	0	246	1	1	82	GAA8683247.1 hypothetical protein Kyoto145A_0510 [Helicobacter pylori]	diamond	246	143	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32057349	32057349	PRJEB81463_P_NODE_1918_length_729_cov_1.544207_g1668_i0	PRJEB81463	1918	729	1.544207	11.25726903	Campylobacterota bacterium	2026809	Bacteria	Bacteria	270	4.26e-88	NR	MDQ1338721.1	2026809	g1668	i0	69.4	0.753086419753086	183	54	75.3	1	1	549	40	220	MDQ1338721.1 hypothetical protein [Campylobacterota bacterium]	diamond	549	270	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
32776662	32776662	PRJEB81463_P_NODE_22620_length_249_cov_2.579545_g22348_i0	PRJEB81463	22620	249	2.579545	6.42306705	Campylobacter	194	Bacteria	Bacteria	129	9.089999999999999e-35	NR	WP_075494431.1	1780362	g22348	i0	73.2	4.91566265060241	82	22	98.8	0	3	248	66	147	WP_075494431.1 indole-3-glycerol phosphate synthase TrpC [Campylobacter geochelonis]	diamond	1224	130	0.992307692307692	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter geochelonis

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