metadata: contig_metadata: 5 rows where bioproject = "PRJEB39269" and tax

5 rows where bioproject = "PRJEB39269" 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
4817103	4817103	PRJEB39269_P_NODE_28304_length_261_cov_3.752252_g27899_i0	PRJEB39269	28304	261	3.752252	9.79337772	Arcobacter	28196	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g27899	i0	100	383.567049808429	261	0	100	0	1	261	1734550	1734290	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	100111	483	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
7709470	7709470	PRJEB39269_P_NODE_727_length_1282_cov_13.806114_g199_i1	PRJEB39269	727	1282	13.806114000000001	176.99438148	Helicobacter canis	29419	Bacteria	Bacteria	1055	0	NTclustered	gi\|50957149\|gb\|AY596234.1\|	29419	g199	i1	98.182	64.2784711388456	605	9	47	2	679	1282	1133	530	Helicobacter canis strain ATCC 51401 23S ribosomal RNA gene, partial sequence	blastn	82405	1055	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canis
20457923	20457923	PRJEB39269_P_NODE_9537_length_450_cov_9.459854_g9134_i0	PRJEB39269	9537	450	9.459854	42.569343	Helicobacter canis	29419	Bacteria	Bacteria	780	0	NTclustered	gi\|1721134163\|emb\|LR698964.1\|	29419	g9134	i0	97.996	139.337777777778	449	9	99	0	2	450	2467	2915	Helicobacter canis isolate MGYG-HGUT-01463 genome assembly, chromosome: 1	blastn	62702	780	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canis
21391323	21391323	PRJEB39269_P_NODE_20677_length_308_cov_4.970260_g20272_i0	PRJEB39269	20677	308	4.97026	15.3084008	Arcobacter	28196	Bacteria	Bacteria	564	2.99e-156	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g20272	i0	99.675	375.012987012987	308	1	100	0	1	308	1733015	1733322	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	115504	564	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
23941553	23941553	PRJEB39269_P_NODE_36679_length_227_cov_4.739362_g36274_i0	PRJEB39269	36679	227	4.739362	10.75835174	Arcobacteraceae	2808963	Bacteria	Bacteria	403	4.85e-108	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g36274	i0	98.678	384.784140969163	227	3	100	0	1	227	1733904	1733678	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	87346	403	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis

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