metadata: contig_metadata: 12 rows where bioproject = "PRJNA608660", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA608660", tax_kingdom = "Pseudomonadati" 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
584471	584471	PRJNA608660_P_NODE_13281_length_404_cov_7.205634_g12932_i0	PRJNA608660	13281	404	7.205634	29.11076136	Candidatus Sulfuricurvum sp. RIFRC-1	1249480	Bacteria	Bacteria	619	8.47e-173	NTclustered	gi\|410994849\|gb\|CP003920.1\|	1249480	g12932	i0	95.833	251.725247524752	384	15	95	1	9	391	644382	644765	Candidatus Sulfuricurvum sp. RIFRC-1, complete genome	blastn	101697	619	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Candidatus Sulfuricurvum sp. RIFRC-1
8799716	8799716	PRJNA608660_P_NODE_12207_length_425_cov_1.861702_g11860_i0	PRJNA608660	12207	425	1.861702	7.9122335	Aliarcobacter	2321111	Bacteria	Bacteria	497	4.3799999999999996e-136	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g11860	i0	98.925	380.945882352941	279	1	95	2	8	285	852034	851757	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	161902	497	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
8799730	8799730	PRJNA608660_P_NODE_17167_length_348_cov_6.692308_g16812_i0	PRJNA608660	17167	348	6.692308	23.28923184	Aliarcobacter	2321111	Bacteria	Bacteria	385	2.86e-102	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g16812	i0	100	311.140804597701	208	0	96	0	8	215	849882	849675	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	108277	385	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
13900988	13900988	PRJNA608660_P_NODE_7931_length_529_cov_11.958333_g7596_i0	PRJNA608660	7931	529	11.958333	63.25958157	Campylobacter	194	Bacteria	Bacteria	704	0	NTclustered	gi\|240265855\|gb\|GQ167692.1\|	827	g7596	i0	91.346	279.897920604915	520	38	98	7	1	517	1072	1587	Bacteroides ureolyticus strain UNSWJ 23S ribosomal RNA gene, partial sequence	blastn	148066	704	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
18998382	18998382	PRJNA608660_P_NODE_41095_length_184_cov_1.540741_g40738_i0	PRJNA608660	41095	184	1.540741	2.83496344	Aliarcobacter	2321111	Bacteria	Bacteria	300	5.08e-77	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g40738	i0	100	318.010869565217	162	0	90	0	11	172	851360	851199	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	58514	300	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
19711345	19711345	PRJNA608660_P_NODE_39916_length_188_cov_3.683453_g39559_i0	PRJNA608660	39916	188	3.683453	6.92489164	Helicobacter pylori	210	Bacteria	Bacteria	117	1.27e-28	NR	GAA8845099.1	210	g39559	i0	96.8	1.97872340425532	62	2	98.9	0	187	2	252	313	GAA8845099.1 DEAD/DEAH box helicase [Helicobacter pylori]	diamond	372	117	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
19711369	19711369	PRJNA608660_P_NODE_42976_length_177_cov_1.625000_g42619_i0	PRJNA608660	42976	177	1.625	2.87625	Campylobacter showae	204	Bacteria	Bacteria	281	1.75e-71	NTclustered	gi\|1483583565\|emb\|LT631545.1\|	204	g42619	i0	100	185.757062146893	152	0	86	0	14	165	58156	58005	Campylobacter showae strain B32_SW genome assembly, chromosome: I	blastn	32879	281	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
20273420	20273420	PRJNA608660_P_NODE_40076_length_188_cov_1.489209_g39719_i0	PRJNA608660	40076	188	1.489209	2.79971292	Campylobacter	194	Bacteria	Bacteria	307	3.1100000000000005e-79	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g39719	i0	96.757	117.771276595745	185	5	98	1	3	186	1036490	1036306	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	22141	307	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
20986980	20986980	PRJNA608660_P_NODE_24577_length_273_cov_1.392857_g24221_i0	PRJNA608660	24577	273	1.392857	3.80249961	Campylobacter gracilis	824	Bacteria	Bacteria	407	4.639999999999999e-109	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g24221	i0	93.773	6.29304029304029	273	13	100	2	1	273	1170391	1170123	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	1718	407	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
21548786	21548786	PRJNA608660_P_NODE_20037_length_315_cov_2.597744_g19681_i0	PRJNA608660	20037	315	2.597744	8.1828936	Sulfurimonas	202746	Bacteria	Bacteria	466	8.89e-127	NTclustered	gi\|470477533\|ref\|NR_076390.1\|	39766	g19681	i0	98.127	319.498412698413	267	5	100	0	1	267	1045	779	Sulfurimonas denitrificans strain DSM 1251 23S ribosomal RNA gene, complete sequence	blastn	100642	466	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas denitrificans
21548853	21548853	PRJNA608660_P_NODE_37437_length_198_cov_2.335570_g37081_i0	PRJNA608660	37437	198	2.33557	4.6244286	Campylobacter	194	Bacteria	Bacteria	318	1.53e-82	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g37081	i0	99.429	214.772727272727	175	1	88	0	9	183	30287	30461	Campylobacter showae genome assembly, plasmid: V	blastn	42525	318	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
28816707	28816707	PRJNA608660_P_NODE_40608_length_186_cov_1.175182_g40251_i0	PRJNA608660	40608	186	1.175182	2.18583852	Campylobacteraceae bacterium	2268179	Bacteria	Bacteria	79	1.52e-15	NR	MCI4398930.1	2268179	g40251	i0	74.1	1.74193548387097	54	14	87.1	0	8	169	69	122	MCI4398930.1 transaldolase [Campylobacteraceae bacterium]	diamond	324	79	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae		Campylobacteraceae bacterium

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