metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB75230" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB75230" 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
136076	136076	PRJEB75230_P_NODE_134141_length_249_cov_0.875000_g133959_i0	PRJEB75230	134141	249	0.875	2.17875	Poseidonibacter lekithochrous	1904463	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1850313845\|gb\|CP054052.1\|	1904463	g133959	i0	100	0.112449799196787	28	0	11	0	96	123	1576212	1576239	Poseidonibacter lekithochrous strain DSM 100870 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Poseidonibacter	Poseidonibacter lekithochrous
136431	136431	PRJEB75230_P_NODE_160501_length_244_cov_1.093567_g160319_i0	PRJEB75230	160501	244	1.093567	2.66830348	Campylobacter pinnipediorum	1965231	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1153130550\|gb\|CP012546.1\|	1660067	g160319	i0	100	0.114754098360656	28	0	11	0	44	71	63483	63510	Campylobacter pinnipediorum subsp. pinnipediorum strain RM17260 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter pinnipediorum
2270979	2270979	PRJEB75230_P_NODE_150702_length_246_cov_0.890173_g150520_i0	PRJEB75230	150702	246	0.890173	2.18982558	Pseudomonadati	3379134	Bacteria	Bacteria	73.1	1.71e-8	NTclustered	gi\|817151433\|gb\|CP011308.1\|	206403	g150520	i0	95.652	34.4308943089431	46	1	18	1	202	246	645330	645285	Sulfurovum lithotrophicum strain ATCC BAA-797, complete genome	blastn	8470	73.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum lithotrophicum
3964207	3964207	PRJEB75230_P_NODE_94844_length_267_cov_1.773196_g94662_i0	PRJEB75230	94844	267	1.773196	4.73443332	Campylobacter sp. CN_NE2	2984146	Bacteria	Bacteria	424	4.49e-114	NTclustered	gi\|2427059240\|gb\|CP115608.1\|	2984146	g94662	i0	95.221	219.505617977528	272	6	100	5	1	267	117615	117346	Campylobacter sp. CN_NE2 strain Cn NE2 chromosome	blastn	58608	424	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CN_NE2
10340999	10340999	PRJEB75230_P_NODE_90369_length_271_cov_1.297980_g90187_i0	PRJEB75230	90369	271	1.29798	3.5175258	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1679706893\|gb\|CP021072.1\|	1032070	g90187	i0	100	0.206642066420664	28	0	10	0	167	194	1291375	1291402	Arcobacter cryaerophilus ATCC 43158 strain LMG 9904 genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
11616125	11616125	PRJEB75230_P_NODE_63890_length_295_cov_1.301802_g63708_i0	PRJEB75230	63890	295	1.301802	3.8403159	Arcobacter sp. L	944547	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|345470425\|dbj\|AP012048.1\|	944547	g63708	i0	100	0.0949152542372881	28	0	9	0	265	292	929334	929361	Arcobacter sp. L DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter sp. L
12890990	12890990	PRJEB75230_P_NODE_56491_length_304_cov_1.000000_g56309_i0	PRJEB75230	56491	304	1	3.04	Arcobacter ellisii	913109	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1474793334\|gb\|CP032097.1\|	913109	g56309	i0	94.444	0.118421052631579	36	0	12	2	151	186	1163871	1163838	Arcobacter ellisii strain LMG 26155 chromosome, complete genome	blastn	36	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter ellisii
15438405	15438405	PRJEB75230_P_NODE_119873_length_251_cov_0.865169_g119691_i0	PRJEB75230	119873	251	0.865169	2.17157419	Campylobacter gracilis	824	Bacteria	Bacteria	121	6.149999999999999e-23	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g119691	i0	92.771	0.661354581673307	83	6	33	0	1	83	401414	401332	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	166	121	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
23087757	23087757	PRJEB75230_P_NODE_116299_length_252_cov_1.050279_g116117_i0	PRJEB75230	116299	252	1.050279	2.64670308	Campylobacter showae	204	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1622747600\|gb\|CP012544.1\|	204	g116117	i0	92.105	0.301587301587302	38	2	15	1	65	102	950103	950139	Campylobacter showae strain ATCC 51146 chromosome, complete genome	blastn	76	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae

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