metadata: contig_metadata: 13 rows where bioproject = "PRJNA1174207", tax_kingdom = "Pseudomonadati" and tax

13 rows where bioproject = "PRJNA1174207", 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
315739	315739	PRJNA1174207_P_NODE_30081_length_264_cov_1.879581_g29552_i0	PRJNA1174207	30081	264	1.879581	4.96209384	Campylobacter gracilis	824	Bacteria	Bacteria	486	5.579999999999999e-133	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g29552	i0	100	244.19696969697	263	0	99	0	1	263	501615	501877	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	64468	486	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
4142758	4142758	PRJNA1174207_P_NODE_38704_length_244_cov_2.181287_g38175_i0	PRJNA1174207	38704	244	2.181287	5.32234028	Campylobacter gracilis	824	Bacteria	Bacteria	374	4.1399999999999986e-99	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g38175	i0	94.262	2	244	14	100	0	1	244	365343	365100	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	488	374	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
6143246	6143246	PRJNA1174207_P_NODE_12605_length_415_cov_1.520468_g12078_i0	PRJNA1174207	12605	415	1.520468	6.3099422	root	1	Root_unresolved	Root_unresolved	767	0	NTclustered	gi\|285182283\|gb\|GU418640.1\|	824	g12078	i0	100	100	415	0	100	0	1	415	2	416	Campylobacter gracilis clone EI016 16S ribosomal RNA gene, partial sequence	blastn	41500	767	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
7968853	7968853	PRJNA1174207_P_NODE_24027_length_290_cov_1.354839_g23498_i0	PRJNA1174207	24027	290	1.354839	3.9290331	Helicobacter pylori	210	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2642589947\|gb\|CP079371.1\|	210	g23498	i0	96.875	2.09655172413793	32	0	11	1	130	160	35702	35671	Helicobacter pylori strain HpGP-MAL-023 chromosome, complete genome	blastn	608	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
11794342	11794342	PRJNA1174207_P_NODE_33050_length_252_cov_1.229050_g32521_i0	PRJNA1174207	33050	252	1.22905	3.097206	uncultured Campylobacter sp.	218934	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|334724791\|gb\|JF795888.1\|	218934	g32521	i0	100	103	252	0	100	0	1	252	292	41	Uncultured Campylobacter sp. clone 2UC34S 3 16S ribosomal RNA gene, partial sequence	blastn	25956	466	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	uncultured Campylobacter sp.
16892737	16892737	PRJNA1174207_P_NODE_29174_length_268_cov_1.410256_g28645_i0	PRJNA1174207	29174	268	1.410256	3.77948608	Campylobacter gracilis	824	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g28645	i0	100	267.90671641791	268	0	100	0	1	268	500798	501065	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	71799	496	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
18167221	18167221	PRJNA1174207_P_NODE_26735_length_278_cov_1.941463_g26206_i0	PRJNA1174207	26735	278	1.941463	5.39726714	Campylobacter gracilis	824	Bacteria	Bacteria	436	6.049999999999999e-118	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g26206	i0	94.964	2	278	14	100	0	1	278	1969670	1969947	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	556	436	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
19441797	19441797	PRJNA1174207_P_NODE_35556_length_248_cov_1.731429_g35027_i0	PRJNA1174207	35556	248	1.731429	4.29394392	Campylobacter gracilis	824	Bacteria	Bacteria	339	1.5399999999999998e-88	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g35027	i0	91.235	2.0241935483871	251	19	100	1	1	248	384004	384254	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	502	339	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
20166748	20166748	PRJNA1174207_P_NODE_13756_length_394_cov_1.352025_g13227_i0	PRJNA1174207	13756	394	1.352025	5.3269785	Arcobacteraceae	2808963	Bacteria	Bacteria	706	0	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g13227	i0	98.985	392.251269035533	394	4	100	0	1	394	1732814	1732421	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	154547	706	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
21442768	21442768	PRJNA1174207_P_NODE_5977_length_683_cov_2.593443_g5467_i0	PRJNA1174207	5977	683	2.593443	17.71321569	Campylobacter	194	Bacteria	Bacteria	1227	0	NTclustered	gi\|1207769201\|gb\|MF351714.1\|	199	g5467	i0	99.122	236.382137628111	683	5	100	1	1	683	1853	1172	Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence	blastn	161449	1227	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
25266993	25266993	PRJNA1174207_P_NODE_36400_length_247_cov_1.528736_g35871_i0	PRJNA1174207	36400	247	1.528736	3.77597792	root	1	Root_unresolved	Root_unresolved	451	1.88e-122	NTclustered	gi\|285196834\|gb\|GU427157.1\|	204	g35871	i0	99.595	107.550607287449	247	1	100	0	1	247	8	254	Campylobacter showae clone CMC1417 16S ribosomal RNA gene, partial sequence	blastn	26565	451	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
30564925	30564925	PRJNA1174207_P_NODE_21973_length_304_cov_1.229437_g21444_i0	PRJNA1174207	21973	304	1.229437	3.73748848	Bacteria	2	Bacteria	Bacteria	166	5e-50	NR	PUB99708.1	210	g21444	i0	100	2.33881578947368	79	0	78	0	237	1	7	85	PUB99708.1 hypothetical protein C2S07_01860, partial [Helicobacter pylori]	diamond	711	166	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31430900	31430900	PRJNA1174207_P_NODE_40356_length_242_cov_1.739645_g39827_i0	PRJNA1174207	40356	242	1.739645	4.2099409	Campylobacterota bacterium	2026809	Bacteria	Bacteria	86.3	1.1e-17	NR	MEA1917427.1	2026809	g39827	i0	42.5	0.991735537190083	80	46	99.2	0	3	242	169	248	MEA1917427.1 heparan-alpha-glucosaminide N-acetyltransferase domain-containing protein [Campylobacterota bacterium]	diamond	240	86.3	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota 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);;