metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA763718" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA763718" and tax_phylum = "Pseudomonadota"

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
26609787	26609787	PRJNA763718_S_NODE_7901_length_157_cov_0.966667_g7693_i0	PRJNA763718	7901	157	0.966667	1.51766719	unclassified Pseudoalteromonas	194690	Bacteria	Bacteria	111	5.940000000000001e-27	NR	WP_024597516.1	194690	g7693	i0	98.1	0.993630573248408	52	1	99.4	0	1	156	181	232	WP_024597516.1 MULTISPECIES: UvrD-helicase domain-containing protein [unclassified Pseudoalteromonas]	diamond	156	111	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Pseudoalteromonadaceae	Pseudoalteromonas
27558532	27558532	PRJNA763718_S_NODE_4624_length_204_cov_1.574850_g4416_i0	PRJNA763718	4624	204	1.57485	3.212694	Aeromonas	642	Bacteria	Bacteria	126	1.05e-35	NR	WP_019444963.1	642	g4416	i0	100	0.985294117647059	67	0	98.5	0	203	3	23	89	WP_019444963.1 MULTISPECIES: helix-turn-helix domain-containing protein [Aeromonas]	diamond	201	126	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas
27748411	27748411	PRJNA763718_S_NODE_7124_length_164_cov_3.039370_g6916_i0	PRJNA763718	7124	164	3.03937	4.9845668	Aeromonas	642	Bacteria	Bacteria	105	9.13e-27	NR	WP_019444962.1	642	g6916	i0	100	0.896341463414634	49	0	89.6	0	162	16	137	185	WP_019444962.1 MULTISPECIES: ImmA/IrrE family metallo-endopeptidase [Aeromonas]	diamond	147	105	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas
28537739	28537739	PRJNA763718_S_NODE_5207_length_192_cov_1.787097_g4999_i0	PRJNA763718	5207	192	1.787097	3.43122624	Pseudomonas sp.	306	Bacteria	Bacteria	41.6	0.0399	NR	HLT04349.1	306	g4999	i0	36.2	0.734375	47	26	73.4	1	14	154	152	194	HLT04349.1 class I SAM-dependent methyltransferase [Pseudomonas sp.]	diamond	141	41.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp.
28705122	28705122	PRJNA763718_S_NODE_7567_length_160_cov_1.341463_g7359_i0	PRJNA763718	7567	160	1.341463	2.1463408	Comamonadaceae	80864	Bacteria	Bacteria	87.8	1.37e-18	NR	WP_010104906.1	1110389	g7359	i0	78.4	5.6625	51	11	95.6	0	155	3	422	472	WP_010104906.1 adenosylhomocysteinase [Verminephrobacter aporrectodeae]	diamond	906	88.2	0.99546485260771	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Verminephrobacter	Verminephrobacter aporrectodeae
28916164	28916164	PRJNA763718_S_NODE_928_length_556_cov_38.500963_g733_i0	PRJNA763718	928	556	38.500963	214.06535428	Enterobacter hormaechei	158836	Bacteria	Bacteria	131	8.099999999999999e-36	NR	WP_096179768.1	158836	g733	i0	94.6	0.60431654676259	112	6	60.4	0	338	3	1	112	WP_096179768.1 hypothetical protein, partial [Enterobacter hormaechei]	diamond	336	131	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
29863638	29863638	PRJNA763718_S_NODE_6671_length_169_cov_6.121212_g6463_i0	PRJNA763718	6671	169	6.121212	10.34484828	Neoroseomonas marina	1232220	Bacteria	Bacteria	42.4	0.0175	NR	WP_170056679.1	1232220	g6463	i0	81.8	5.50295857988166	22	4	39.1	0	97	162	151	172	WP_170056679.1 RNA-directed DNA polymerase, partial [Neoroseomonas marina]	diamond	930	42.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Acetobacteraceae	Neoroseomonas	Neoroseomonas marina
29999797	29999797	PRJNA763718_S_NODE_5711_length_183_cov_1.232877_g5503_i0	PRJNA763718	5711	183	1.232877	2.25616491	Pseudomonadota	1224	Bacteria	Bacteria	51.2	1.63e-5	NR	WP_235184783.1	29487	g5503	i0	48.3	4.85245901639344	58	27	95.1	1	1	174	244	298	WP_235184783.1 MULTISPECIES: phage tail protein [Photorhabdus]	diamond	888	51.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Morganellaceae	Photorhabdus
31190265	31190265	PRJNA763718_S_NODE_7255_length_163_cov_1.539683_g7047_i0	PRJNA763718	7255	163	1.539683	2.50968329	Aeromonas	642	Bacteria	Bacteria	107	1.09e-27	NR	WP_019444962.1	642	g7047	i0	100	0.975460122699387	53	0	97.5	0	3	161	49	101	WP_019444962.1 MULTISPECIES: ImmA/IrrE family metallo-endopeptidase [Aeromonas]	diamond	159	107	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas
31601967	31601967	PRJNA763718_S_NODE_6696_length_169_cov_2.303030_g6488_i0	PRJNA763718	6696	169	2.30303	3.8921207	Aeromonas	642	Bacteria	Bacteria	52.4	2.64e-6	NR	WP_019444962.1	642	g6488	i0	96.3	0.479289940828402	27	1	47.9	0	89	169	1	27	WP_019444962.1 MULTISPECIES: ImmA/IrrE family metallo-endopeptidase [Aeromonas]	diamond	81	52.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas

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