metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA473799" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA473799" 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
3646720	3646720	PRJNA473799_P_NODE_16023_length_287_cov_1.233645_g15749_i0	PRJNA473799	16023	287	1.233645	3.54056115	root	1	Root_unresolved	Root_unresolved	525	1.2999999999999995e-144	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g15749	i0	99.652	100	287	1	100	0	1	287	698300	698586	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	28700	525	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
4923786	4923786	PRJNA473799_P_NODE_22284_length_274_cov_1.044776_g22010_i0	PRJNA473799	22284	274	1.044776	2.86268624	Campylobacter	194	Bacteria	Bacteria	470	5.859999999999999e-128	NTclustered	gi\|1376251231\|gb\|CP021642.1\|	199	g22010	i0	97.794	12.9233576642336	272	6	99	0	3	274	343183	343454	Campylobacter concisus strain P2CDO4 chromosome, complete genome	blastn	3541	470	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
9373557	9373557	PRJNA473799_P_NODE_41608_length_247_cov_1.747126_g41334_i0	PRJNA473799	41608	247	1.747126	4.31540122	Campylobacter ureolyticus	827	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|909715533\|gb\|CP012195.1\|	1032069	g41334	i0	98.381	5.7085020242915	247	4	100	0	1	247	206444	206690	Campylobacter ureolyticus RIGS 9880 chromosome, complete genome	blastn	1410	435	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
10023978	10023978	PRJNA473799_P_NODE_29388_length_260_cov_1.267380_g29114_i0	PRJNA473799	29388	260	1.26738	3.295188	Arcobacteraceae	2808963	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|1847324382\|gb\|CP053840.1\|	1054033	g29114	i0	100	407.753846153846	260	0	100	0	1	260	2091765	2091506	Arcobacter venerupis strain LMG 26156 chromosome, complete genome	blastn	106016	481	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter venerupis
11924338	11924338	PRJNA473799_P_NODE_34630_length_251_cov_1.179775_g34356_i0	PRJNA473799	34630	251	1.179775	2.96123525	Arcobacter porcinus	1935204	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1739646276\|gb\|CP036246.2\|	1935204	g34356	i0	100	0.235059760956175	30	0	12	0	11	40	1286053	1286024	Arcobacter porcinus strain CCUG 56899 chromosome, complete genome	blastn	59	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter porcinus
14474319	14474319	PRJNA473799_P_NODE_36852_length_250_cov_0.870056_g36578_i0	PRJNA473799	36852	250	0.870056	2.17514	Campylobacter showae	204	Bacteria	Bacteria	196	9.88e-46	NTclustered	gi\|1483583541\|emb\|LT631465.1\|	204	g36578	i0	82.553	5.256	235	30	93	8	5	237	7111	7336	Campylobacter showae strain 129_VTPP genome assembly, plasmid: VI	blastn	1314	196	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
18297308	18297308	PRJNA473799_P_NODE_34955_length_251_cov_0.865169_g34681_i0	PRJNA473799	34955	251	0.865169	2.17157419	Campylobacter curvus	200	Bacteria	Bacteria	172	1.67e-38	NTclustered	gi\|1861373391\|gb\|CP053826.1\|	200	g34681	i0	79.518	1.9840637450199201	249	45	98	5	4	249	1680812	1680567	Campylobacter curvus strain ATCC 35224 chromosome, complete genome	blastn	498	172	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter curvus
18297567	18297567	PRJNA473799_P_NODE_53855_length_241_cov_0.916667_g53581_i0	PRJNA473799	53855	241	0.916667	2.20916747	Campylobacter jejuni	197	Bacteria	Bacteria	368	1.9e-97	NTclustered	gi\|972488604\|gb\|CP010480.1\|	197	g53581	i0	94.191	78.1659751037344	241	14	100	0	1	241	1662600	1662360	Campylobacter jejuni strain CJ677CC524, complete genome	blastn	18838	368	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
18947045	18947045	PRJNA473799_P_NODE_14975_length_289_cov_1.740741_g14701_i0	PRJNA473799	14975	289	1.740741	5.03074149	Campylobacter	194	Bacteria	Bacteria	529	1.01e-145	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g14701	i0	99.654	236.349480968858	289	1	100	0	1	289	1634	1922	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	68305	529	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
19571642	19571642	PRJNA473799_P_NODE_4856_length_573_cov_4.816000_g4591_i0	PRJNA473799	4856	573	4.816	27.59568	Campylobacter showae	204	Bacteria	Bacteria	1059	0	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g4591	i0	100	233.987783595113	573	0	100	0	1	573	390118	389546	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	134075	1059	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
23397782	23397782	PRJNA473799_P_NODE_2619_length_877_cov_5.144279_g2388_i0	PRJNA473799	2619	877	5.144279	45.11532683	Campylobacter showae	204	Bacteria	Bacteria	1565	0	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g2388	i0	98.861	252.009122006841	878	9	100	1	1	877	390091	390968	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	221012	1565	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
24671818	24671818	PRJNA473799_P_NODE_38160_length_249_cov_1.193182_g37886_i0	PRJNA473799	38160	249	1.193182	2.97102318	uncultured Arcobacter sp.	165434	Bacteria	Bacteria	86.1	2.22e-12	NTclustered	gi\|682122801\|gb\|KJ739652.1\|	165434	g37886	i0	88.571	29.6064257028112	70	8	28	0	180	249	6	75	Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence	blastn	7372	86.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	uncultured Arcobacter sp.

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