metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA768450" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA768450" and tax_superkingdom = "Bacteria"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27147628	27147628	PRJNA768450_S_NODE_14622_length_192_cov_0.636364_g14573_i0	PRJNA768450	14622	192	0.636364	1.22181888	Gordonia amicalis	89053	Bacteria	Bacteria	41.2	0.0117	NR	MDV6311098.1	89053	g14573	i0	38.2	0.859375	55	32	85.9	2	10	174	7	59	MDV6311098.1 hypothetical protein [Gordonia amicalis]	diamond	165	41.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia amicalis
27242827	27242827	PRJNA768450_S_NODE_16583_length_183_cov_0.977612_g16534_i0	PRJNA768450	16583	183	0.977612	1.78902996	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	43.5	0.00551	NR	MDP7743837.1	2053569	g16534	i0	42.5	0.655737704918033	40	23	65.6	0	6	125	40	79	MDP7743837.1 hypothetical protein [Lentisphaeria bacterium]	diamond	120	43.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27495679	27495679	PRJNA768450_S_NODE_6383_length_262_cov_2.061033_g6334_i0	PRJNA768450	6383	262	2.061033	5.39990646	Helicobacter pylori	210	Bacteria	Bacteria	54.3	1.84e-7	NR	GAA9176533.1	210	g6334	i0	57.1	0.641221374045801	56	23	64.1	1	260	93	1	55	GAA9176533.1 hypothetical protein Kyoto193A_0850 [Helicobacter pylori]	diamond	168	54.3	1	Bacteria		Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27653658	27653658	PRJNA768450_S_NODE_12264_length_204_cov_4.187097_g12215_i0	PRJNA768450	12264	204	4.187097	8.54167788	Helicobacter pylori	210	Bacteria	Bacteria	63.2	1.45e-11	NR	GAA8838853.1	210	g12215	i0	93.3	0.441176470588235	30	2	44.1	0	3	92	14	43	GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori]	diamond	90	63.2	1	Bacteria		Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28474444	28474444	PRJNA768450_S_NODE_2826_length_362_cov_12.015974_g2777_i0	PRJNA768450	2826	362	12.015974	43.49782588	Enterobacter hormaechei	158836	Bacteria	Bacteria	124	6.2099999999999985e-34	NR	WP_096179768.1	158836	g2777	i0	96.4	0.92817679558011	112	4	92.8	0	338	3	1	112	WP_096179768.1 hypothetical protein, partial [Enterobacter hormaechei]	diamond	336	124	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
28727015	28727015	PRJNA768450_S_NODE_12707_length_202_cov_1.202614_g12658_i0	PRJNA768450	12707	202	1.202614	2.42928028	Sediminibacterium goheungense	1086393	Bacteria	Bacteria	103	7.79e-27	NR	TDO25478.1	1086393	g12658	i0	98.1	1.57425742574257	53	1	78.7	0	4	162	56	108	TDO25478.1 ribosomal protein L29 [Sediminibacterium goheungense]	diamond	318	103	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium goheungense
29895365	29895365	PRJNA768450_S_NODE_6031_length_268_cov_2.068493_g5982_i0	PRJNA768450	6031	268	2.068493	5.54356124	Roseovarius sp. C7	3398643	Bacteria	Bacteria	45.4	0.00514	NR	WP_416005436.1	3398643	g5982	i0	32.8	0.75	67	38	68.3	2	45	227	209	274	WP_416005436.1 glycosyltransferase family 2 protein [Roseovarius sp. C7]	diamond	201	45.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Roseobacteraceae	Roseovarius	Roseovarius sp. C7
29990070	29990070	PRJNA768450_S_NODE_22711_length_164_cov_0.878261_g22662_i0	PRJNA768450	22711	164	0.878261	1.44034804	uncultured Pseudomonas sp.	114707	Bacteria	Bacteria	110	2.69e-28	NR	WP_288522084.1	114707	g22662	i0	98.1	1.97560975609756	54	1	98.8	0	3	164	157	210	WP_288522084.1 RelA/SpoT domain-containing protein [uncultured Pseudomonas sp.]	diamond	324	110	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	uncultured Pseudomonas sp.
30590273	30590273	PRJNA768450_P_NODE_753_length_374_cov_6.994203_g683_i0	PRJNA768450	753	374	6.994203	26.15831922	Salmonella sp. ZJHZ21_	599	Bacteria	Bacteria	42.7	0.0238	NR	WP_395236951.1	3160111	g683	i0	42.9	0.336898395721925	42	24	33.7	0	195	320	15	56	WP_395236951.1 glycoside hydrolase family 3 N-terminal domain-containing protein, partial [Salmonella sp. ZJHZ21_0184]	diamond	126	42.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella sp. ZJHZ21_0184
31602004	31602004	PRJNA768450_S_NODE_10496_length_217_cov_0.666667_g10447_i0	PRJNA768450	10496	217	0.666667	1.44666739	Arsenicicoccus sp. oral taxon 19	1872639	Bacteria	Bacteria	42.7	0.0268	NR	WP_156188129.1	1658671	g10447	i0	32.2	0.815668202764977	59	37	81.6	1	211	35	376	431	WP_156188129.1 lipopolysaccharide biosynthesis protein [Arsenicicoccus sp. oral taxon 190]	diamond	177	42.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Arsenicicoccus	Arsenicicoccus sp. oral taxon 190
32298211	32298211	PRJNA768450_S_NODE_7959_length_241_cov_1.796875_g7910_i0	PRJNA768450	7959	241	1.796875	4.33046875	Prevotella sp. P3-12	59823	Bacteria	Bacteria	71.6	1.57e-14	NR	WP_216822835.1	2024220	g7910	i0	91.4	0.435684647302905	35	3	43.6	0	139	35	3	37	WP_216822835.1 hypothetical protein, partial [Prevotella sp. P3-120]	diamond	105	71.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. P3-120

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