metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA812715" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA812715" 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
812723	812723	PRJNA812715_P_NODE_24581_length_647_cov_65.391986_g22874_i0	PRJNA812715	24581	647	65.391986	423.08614942	Arcobacter iocasae	2906515	Bacteria	Bacteria	54.7	0.018	NTclustered	gi\|2809047151\|gb\|CP090177.1\|	2906515	g22874	i0	100	0.044822256568779	29	0	4	0	97	125	1017122	1017150	Arcobacter sp. KX21116 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter iocasae
3776836	3776836	PRJNA812715_P_NODE_46543_length_401_cov_2.387195_g44746_i0	PRJNA812715	46543	401	2.387195	9.57265195	Pseudomonadati	3379134	Bacteria	Bacteria	721	0	NTclustered	gi\|972494020\|gb\|CP010483.1\|	197	g44746	i0	99.007	85.428927680798	403	2	100	2	1	401	1633230	1633632	Campylobacter jejuni strain CJ677CC535, complete genome	blastn	34257	721	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
13565688	13565688	PRJNA812715_P_NODE_116171_length_244_cov_0.900585_g114370_i0	PRJNA812715	116171	244	0.900585	2.1974274	Campylobacter concisus	199	Bacteria	Bacteria	412	8.759999999999998e-111	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g114370	i0	97.131	12.844262295082	244	7	100	0	1	244	591415	591658	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	3134	412	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
17802958	17802958	PRJNA812715_P_NODE_98774_length_255_cov_1.527473_g96973_i0	PRJNA812715	98774	255	1.527473	3.89505615	Aliarcobacter	2321111	Bacteria	Bacteria	449	7.03e-122	NTclustered	gi\|1817415496\|gb\|CP026656.1\|	28198	g96973	i0	98.431	49.8313725490196	255	4	100	0	1	255	1591014	1590760	Aliarcobacter cryaerophilus strain M830MA chromosome, complete genome	blastn	12707	449	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
18665172	18665172	PRJNA812715_P_NODE_55055_length_358_cov_1.621053_g53256_i0	PRJNA812715	55055	358	1.621053	5.80336974	Halarcobacter mediterraneus	2023153	Bacteria	Bacteria	71.3	9.36e-8	NTclustered	gi\|2621784616\|emb\|OY781074.1\|	2023153	g53256	i0	90.566	0.547486033519553	53	5	15	0	125	177	6388	6336	MAG: Halarcobacter mediterraneus isolate a5fc0a89-db13-449e-aec2-f9d0956b3340 genome assembly, chromosome: 1	blastn	196	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter mediterraneus

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