metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA415636" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA415636" and tax_kingdom = "Bacillati"

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
27612797	27612797	PRJNA415636_S_NODE_5384_length_221_cov_2.086207_g5337_i0	PRJNA415636	5384	221	2.086207	4.61051747	Actinomycetota bacterium	2900548	Bacteria	Bacteria	53.5	1.91e-6	NR	MEY2477645.1	2900548	g5337	i0	42.3	1.91402714932127	71	41	96.4	0	214	2	78	148	MEY2477645.1 hypothetical protein [Actinomycetota bacterium]	diamond	423	53.5	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
27770744	27770744	PRJNA415636_S_NODE_2104_length_318_cov_2.719557_g2057_i0	PRJNA415636	2104	318	2.719557	8.64819126	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	93.6	4.22e-21	NR	HEX2906967.1	3069543	g2057	i0	43.6	0.952830188679245	101	56	95.3	1	303	1	95	194	HEX2906967.1 isoprenylcysteine carboxylmethyltransferase family protein [Phototrophicaceae bacterium]	diamond	303	93.6	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
29854485	29854485	PRJNA415636_S_NODE_4031_length_248_cov_2.273632_g3984_i0	PRJNA415636	4031	248	2.273632	5.63860736	Mycoplasma wenyonii	65123	Bacteria	Bacteria	94	1.84e-20	NR	WP_112665897.1	65123	g3984	i0	56.4	0.943548387096774	78	34	94.4	0	234	1	262	339	WP_112665897.1 restriction endonuclease subunit S [Mycoplasma wenyonii]	diamond	234	94	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
30265440	30265440	PRJNA415636_S_NODE_3832_length_253_cov_1.800971_g3785_i0	PRJNA415636	3832	253	1.800971	4.55645663	Neobacillus cucumis	1740721	Bacteria	Bacteria	111	1.81e-26	NR	WP_180960453.1	1740721	g3785	i0	59.5	1.99209486166008	84	34	99.6	0	2	253	103	186	WP_180960453.1 C39 family peptidase [Neobacillus cucumis]	diamond	504	111	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus cucumis
30517906	30517906	PRJNA415636_S_NODE_3613_length_259_cov_0.995283_g3566_i0	PRJNA415636	3613	259	0.995283	2.57778297	Mycoplasma wenyonii	65123	Bacteria	Bacteria	139	3.1500000000000004e-36	NR	WP_112664927.1	65123	g3566	i0	81.4	0.996138996138996	86	16	99.6	0	259	2	133	218	WP_112664927.1 DNA gyrase/topoisomerase IV subunit B [Mycoplasma wenyonii]	diamond	258	139	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
31055321	31055321	PRJNA415636_S_NODE_2755_length_287_cov_1.525000_g2708_i0	PRJNA415636	2755	287	1.525	4.37675	Mycoplasma wenyonii	65123	Bacteria	Bacteria	73.2	5.52e-13	NR	RAO95294.1	65123	g2708	i0	97.1	0.710801393728223	34	1	35.5	0	95	196	203	236	RAO95294.1 modification methylase HemK [Mycoplasma wenyonii]	diamond	204	73.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii

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