metadata: contig_metadata: 10 rows where bioproject = "PRJNA1041773", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA1041773", 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
5272910	5272910	PRJNA1041773_P_NODE_27145_length_400_cov_1.079511_g26814_i0	PRJNA1041773	27145	400	1.079511	4.318044	Candidatus Sulfurimonas baltica	2740404	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|1929272150\|gb\|CP054492.1\|	2740404	g26814	i0	100	0.07	28	0	7	0	122	149	1962145	1962172	Candidatus Sulfurimonas baltica strain GD2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Candidatus Sulfurimonas baltica
18021655	18021655	PRJNA1041773_P_NODE_100075_length_241_cov_1.505952_g99742_i0	PRJNA1041773	100075	241	1.505952	3.62934432	Campylobacter	194	Bacteria	Bacteria	119	4.21e-29	NR	WP_270873904.1	2983821	g99742	i0	95	5.43983402489627	60	3	74.7	0	2	181	367	426	WP_270873904.1 reverse transcriptase domain-containing protein [Campylobacter sp. JMF_08 NE1]	diamond	1311	119	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. JMF_08 NE1
19296942	19296942	PRJNA1041773_P_NODE_99016_length_242_cov_0.911243_g98683_i0	PRJNA1041773	99016	242	0.911243	2.20520806	Halarcobacter mediterraneus	2023153	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621784616\|emb\|OY781074.1\|	2023153	g98683	i0	100	0.115702479338843	28	0	12	0	86	113	1830706	1830679	MAG: Halarcobacter mediterraneus isolate a5fc0a89-db13-449e-aec2-f9d0956b3340 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter mediterraneus
27129598	27129598	PRJNA1041773_P_NODE_61642_length_277_cov_0.754902_g61309_i0	PRJNA1041773	61642	277	0.754902	2.09107854	Helicobacter pylori	210	Bacteria	Bacteria	62.4	2.65e-10	NR	GAA9038095.1	210	g61309	i0	84.4	0.346570397111913	32	5	34.7	0	270	175	7	38	GAA9038095.1 hypothetical protein Kyoto184A_00980 [Helicobacter pylori]	diamond	96	62.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27161340	27161340	PRJNA1041773_P_NODE_103402_length_234_cov_6.900621_g103069_i0	PRJNA1041773	103402	234	6.900621	16.14745314	Helicobacter pylori	210	Bacteria	Bacteria	43.9	0.00295	NR	GAA8750823.1	210	g103069	i0	34.7	1.93589743589744	75	49	96.2	0	233	9	17	91	GAA8750823.1 hypothetical protein Kyoto147A_3290 [Helicobacter pylori]	diamond	453	43.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27382984	27382984	PRJNA1041773_P_NODE_71483_length_260_cov_0.823529_g71150_i0	PRJNA1041773	71483	260	0.823529	2.1411754	Helicobacter pylori	210	Bacteria	Bacteria	62.8	2.48e-10	NR	GAA6899797.1	210	g71150	i0	44	0.865384615384615	75	42	86.5	0	226	2	2	76	GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori]	diamond	225	62.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28511522	28511522	PRJNA1041773_P_NODE_49607_length_303_cov_3.347826_g49274_i0	PRJNA1041773	49607	303	3.347826	10.14391278	Pseudomonadati	3379134	Bacteria	Bacteria	68.6	2.51e-12	NR	GAA6955717.1	210	g49274	i0	100	3	30	0	29.7	0	303	214	77	106	GAA6955717.1 hypothetical protein Kyoto211A_1670 [Helicobacter pylori]	diamond	909	68.9	0.995645863570392	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28638037	28638037	PRJNA1041773_P_NODE_1547_length_1684_cov_1.626319_g1402_i0	PRJNA1041773	1547	1684	1.626319	27.38721196	Campylobacter	194	Bacteria	Bacteria	90.1	1.19e-14	NR	WP_270873904.1	2983821	g1402	i0	71.4	0.448931116389549	63	18	11.2	0	1435	1247	722	784	WP_270873904.1 reverse transcriptase domain-containing protein [Campylobacter sp. JMF_08 NE1]	diamond	756	90.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. JMF_08 NE1
30667114	30667114	PRJNA1041773_P_NODE_56593_length_286_cov_3.568075_g56260_i0	PRJNA1041773	56593	286	3.568075	10.2046945	Helicobacter pylori	210	Bacteria	Bacteria	46.2	3.32e-4	NR	GAA9062234.1	210	g56260	i0	51.9	1.1013986013986	52	25	54.5	0	126	281	7	58	GAA9062234.1 hypothetical protein Kyoto184A_05230 [Helicobacter pylori]	diamond	315	46.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31038537	31038537	PRJNA1041773_P_NODE_59455_length_281_cov_1.110577_g59122_i0	PRJNA1041773	59455	281	1.110577	3.12072137	Campylobacter	194	Bacteria	Bacteria	48.9	4.06e-4	NR	WP_270873904.1	2983821	g59122	i0	64.7	1.81494661921708	34	11	35.2	1	34	132	555	588	WP_270873904.1 reverse transcriptase domain-containing protein [Campylobacter sp. JMF_08 NE1]	diamond	510	48.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. JMF_08 NE1

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