metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJDB9741" and tax

10 rows where analysis = "blastn", bioproject = "PRJDB9741" 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
10831	10831	PRJDB9741_P_NODE_13741_length_189_cov_1.285714_g13424_i0	PRJDB9741	13741	189	1.285714	2.42999946	Campylobacter showae	204	Bacteria	Bacteria	344	2.39e-90	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g13424	i0	99.471	10.968253968254	189	1	100	0	1	189	1113146	1112958	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	2073	344	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
6389296	6389296	PRJDB9741_P_NODE_7326_length_231_cov_3.346154_g7009_i0	PRJDB9741	7326	231	3.346154	7.72961574	Wolinella succinogenes	844	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g7009	i0	100	140.926406926407	231	0	100	0	1	231	335287	335517	Wolinella succinogenes, complete genome; segment 4/7	blastn	32554	427	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
9909927	9909927	PRJDB9741_P_NODE_10028_length_208_cov_1.283019_g9711_i0	PRJDB9741	10028	208	1.283019	2.66867952	Campylobacter	194	Bacteria	Bacteria	385	1.58e-102	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g9711	i0	100	224.932692307692	208	0	100	0	1	208	1579	1786	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	46786	385	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
10213855	10213855	PRJDB9741_P_NODE_7989_length_222_cov_3.872832_g7672_i0	PRJDB9741	7989	222	3.872832	8.59768704	Wolinella succinogenes	844	Bacteria	Bacteria	411	2.8199999999999996e-110	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g7672	i0	100	194.936936936937	222	0	100	0	1	222	335165	334944	Wolinella succinogenes, complete genome; segment 4/7	blastn	43276	411	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
13735315	13735315	PRJDB9741_P_NODE_34691_length_163_cov_3.245614_g34374_i0	PRJDB9741	34691	163	3.2456140000000002	5.29035082	Campylobacterales	213849	Bacteria	Bacteria	268	1.24e-67	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g34374	i0	96.319	239.006134969325	163	6	100	0	1	163	43417	43255	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	38958	268	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
15313116	15313116	PRJDB9741_P_NODE_2773_length_428_cov_3.039578_g2458_i0	PRJDB9741	2773	428	3.039578	13.00939384	Wolinella succinogenes	844	Bacteria	Bacteria	780	0	NTclustered	gi\|34482172\|emb\|BX571657.1\|	844	g2458	i0	99.533	176.016355140187	428	2	100	0	1	428	140087	139660	Wolinella succinogenes, complete genome; segment 1/7	blastn	75335	780	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
15313273	15313273	PRJDB9741_P_NODE_7073_length_236_cov_1.165775_g6756_i0	PRJDB9741	7073	236	1.165775	2.751229	uncultured Arcobacter sp.	165434	Bacteria	Bacteria	178	3.35e-40	NTclustered	gi\|682122801\|gb\|KJ739652.1\|	165434	g6756	i0	90.58	84.2542372881356	138	8	58	4	101	236	6	140	Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence	blastn	19884	178	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	uncultured Arcobacter sp.
16587673	16587673	PRJDB9741_P_NODE_10714_length_201_cov_3.138158_g10397_i0	PRJDB9741	10714	201	3.138158	6.30769758	Arcobacter roscoffensis	2961520	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|2270258285\|gb\|CP100595.1\|	2961520	g10397	i0	100	359.89552238806	201	0	100	0	1	201	276320	276120	Arcobacter roscoffensis strain ARW1-2F2 chromosome, complete genome	blastn	72339	372	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter roscoffensis
20411498	20411498	PRJDB9741_P_NODE_19557_length_178_cov_4.837209_g19240_i0	PRJDB9741	19557	178	4.837209	8.61023202	Wolinella succinogenes	844	Bacteria	Bacteria	302	1.35e-77	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g19240	i0	97.191	135.662921348315	178	5	100	0	1	178	334088	334265	Wolinella succinogenes, complete genome; segment 4/7	blastn	24148	302	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
22962973	22962973	PRJDB9741_P_NODE_959_length_881_cov_2.996394_g731_i0	PRJDB9741	959	881	2.996394	26.39823114	Wolinella succinogenes	844	Bacteria	Bacteria	1605	0	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g731	i0	99.546	150	881	4	100	0	1	881	336374	335494	Wolinella succinogenes, complete genome; segment 4/7	blastn	132150	1605	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes

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