metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA798905" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA798905" 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
2493664	2493664	PRJNA798905_S_NODE_29122_length_280_cov_2.850242_g28673_i0	PRJNA798905	29122	280	2.850242	7.9806776	Aliarcobacter	2321111	Bacteria	Bacteria	490	4.61e-134	NTclustered	gi\|1704610973\|gb\|CP041386.1\|	28197	g28673	i0	98.214	49.3214285714286	280	5	100	0	1	280	1107649	1107928	Aliarcobacter butzleri strain ED-1 chromosome, complete genome	blastn	13810	490	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
5895612	5895612	PRJNA798905_S_NODE_2985_length_778_cov_10.697872_g2577_i0	PRJNA798905	2985	778	10.697872	83.22944416	Malaciobacter canalis	1912871	Bacteria	Bacteria	676	0	NTclustered	gi\|1724553138\|gb\|CP042812.1\|	1912871	g2577	i0	96.359	2.24678663239075	412	14	100	1	1	411	123525	123936	Malaciobacter canalis strain LMG 29148 chromosome, complete genome	blastn	1748	676	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter canalis
7169933	7169933	PRJNA798905_S_NODE_10266_length_432_cov_5.693593_g9817_i0	PRJNA798905	10266	432	5.693593	24.59632176	Arcobacter suis	1278212	Bacteria	Bacteria	420	9.92e-113	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g9817	i0	99.142	0.951388888888889	233	2	94	0	13	245	2512239	2512471	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	411	420	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
7170446	7170446	PRJNA798905_S_NODE_31006_length_271_cov_3.924242_g30557_i0	PRJNA798905	31006	271	3.924242	10.63469582	Arcobacter suis	1278212	Bacteria	Bacteria	496	9.55e-136	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g30557	i0	99.631	15	271	1	100	0	1	271	2477114	2476844	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	4065	496	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
8445361	8445361	PRJNA798905_S_NODE_39047_length_243_cov_1.594118_g38598_i0	PRJNA798905	39047	243	1.594118	3.87370674	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g38598	i0	100	0.11522633744856	28	0	12	0	96	123	1771318	1771291	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
10996027	10996027	PRJNA798905_S_NODE_27589_length_288_cov_1.358140_g27140_i0	PRJNA798905	27589	288	1.35814	3.9114432	Arcobacter suis	1278212	Bacteria	Bacteria	411	3.819999999999999e-110	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g27140	i0	95.367	0.899305555555556	259	11	90	1	26	284	487700	487957	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	259	411	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
12271475	12271475	PRJNA798905_S_NODE_30970_length_271_cov_6.505051_g30521_i0	PRJNA798905	30970	271	6.505051	17.62868821	Aliarcobacter butzleri	28197	Bacteria	Bacteria	468	2.08e-127	NTclustered	gi\|1672832549\|gb\|CP040507.1\|	888827	g30521	i0	97.786	58.3468634686347	271	6	100	0	1	271	69060	69330	Aliarcobacter butzleri JV22 chromosome, complete genome	blastn	15812	468	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
13546047	13546047	PRJNA798905_S_NODE_5751_length_557_cov_3.615702_g5304_i0	PRJNA798905	5751	557	3.615702	20.13946014	Arcobacter defluvii	873191	Bacteria	Bacteria	158	1.13e-33	NTclustered	gi\|1847331607\|gb\|CP053835.1\|	873191	g5304	i0	95.918	1.88689407540395	98	3	17	1	407	503	1290412	1290315	Arcobacter defluvii strain LMG 25694 chromosome, complete genome	blastn	1051	158	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter defluvii
17370435	17370435	PRJNA798905_S_NODE_26974_length_291_cov_2.119266_g26525_i0	PRJNA798905	26974	291	2.119266	6.16706406	Arcobacter suis	1278212	Bacteria	Bacteria	128	4.35e-25	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g26525	i0	98.63	0.491408934707904	73	0	48	1	165	236	2581621	2581693	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	143	128	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
17370770	17370770	PRJNA798905_S_NODE_41294_length_234_cov_2.739130_g40845_i0	PRJNA798905	41294	234	2.73913	6.4095642	Malaciobacter mytili	603050	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1435908220\|gb\|CP031219.1\|	1032238	g40845	i0	100	0.123931623931624	29	0	12	0	154	182	2394386	2394358	Malaciobacter mytili LMG 24559 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter mytili
17370822	17370822	PRJNA798905_S_NODE_43394_length_221_cov_4.925676_g42945_i0	PRJNA798905	43394	221	4.925676	10.88574396	Arcobacter defluvii	873191	Bacteria	Bacteria	398	2.1799999999999995e-106	NTclustered	gi\|1847331607\|gb\|CP053835.1\|	873191	g42945	i0	99.095	20.9276018099548	221	2	100	0	1	221	462298	462518	Arcobacter defluvii strain LMG 25694 chromosome, complete genome	blastn	4625	398	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter defluvii
19918865	19918865	PRJNA798905_S_NODE_28476_length_283_cov_3.623810_g28027_i0	PRJNA798905	28476	283	3.62381	10.2553823	Arcobacter suis	1278212	Bacteria	Bacteria	490	4.67e-134	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g28027	i0	97.88	2.97173144876325	283	6	100	0	1	283	105359	105641	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	841	490	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
20344550	20344550	PRJNA798905_S_NODE_19236_length_338_cov_2.113208_g18787_i0	PRJNA798905	19236	338	2.113208	7.14264304	Arcobacter	28196	Bacteria	Bacteria	603	7.019999999999999e-168	NTclustered	gi\|1847331607\|gb\|CP053835.1\|	873191	g18787	i0	98.817	47.9556213017751	338	4	100	0	1	338	2781426	2781763	Arcobacter defluvii strain LMG 25694 chromosome, complete genome	blastn	16209	603	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter defluvii
20344577	20344577	PRJNA798905_S_NODE_21736_length_321_cov_2.665323_g21287_i0	PRJNA798905	21736	321	2.665323	8.55568683	Bacteria	2	Bacteria	Bacteria	588	1.8599999999999994e-163	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g21287	i0	99.688	383.311526479751	321	1	100	0	1	321	554405	554085	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	123043	588	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli

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