metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA680334" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA680334" and tax_phylum = "Myxococcota"

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
27366703	27366703	PRJNA680334_S_NODE_19623_length_256_cov_2.260090_g19137_i0	PRJNA680334	19623	256	2.26009	5.7858304	Corallococcus exercitus	2316736	Bacteria	Bacteria	48.5	1.18e-4	NR	WP_171411814.1	2316736	g19137	i0	43.6	0.64453125	55	29	62.1	1	160	2	10	64	WP_171411814.1 four-helix bundle copper-binding protein [Corallococcus exercitus]	diamond	165	48.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
28408428	28408428	PRJNA680334_S_NODE_26566_length_233_cov_4.375000_g26080_i0	PRJNA680334	26566	233	4.375	10.19375	Archangium sp.	1872627	Bacteria	Bacteria	43.1	0.0228	NR	HYO69591.1	1872627	g26080	i0	48.8	2.0343347639485	41	21	52.8	0	106	228	217	257	HYO69591.1 tetratricopeptide repeat protein [Archangium sp.]	diamond	474	43.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
28534890	28534890	PRJNA680334_S_NODE_26867_length_232_cov_5.798995_g26381_i0	PRJNA680334	26867	232	5.798995	13.4536684	Myxococcales bacterium	2026763	Bacteria	Bacteria	44.3	0.00941	NR	MFN7130904.1	2026763	g26381	i0	44.9	0.633620689655172	49	27	63.4	0	25	171	357	405	MFN7130904.1 DPP IV N-terminal domain-containing protein [Myxococcales bacterium]	diamond	147	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28661074	28661074	PRJNA680334_S_NODE_53187_length_188_cov_3.251613_g52701_i0	PRJNA680334	53187	188	3.251613	6.11303244	Myxococcales bacterium	2026763	Bacteria	Bacteria	101	7.58e-25	NR	MBL9100014.1	2026763	g52701	i0	78.7	0.973404255319149	61	13	97.3	0	187	5	96	156	MBL9100014.1 glutathione S-transferase N-terminal domain-containing protein [Myxococcales bacterium]	diamond	183	101	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30461517	30461517	PRJNA680334_S_NODE_16653_length_269_cov_3.601695_g16167_i0	PRJNA680334	16653	269	3.601695	9.68855955	Myxococcales bacterium	2026763	Bacteria	Bacteria	44.3	0.015	NR	RYE95084.1	2026763	g16167	i0	48.9	0.50185873605948	45	23	50.2	0	197	63	977	1021	RYE95084.1 MAG: hypothetical protein EOO75_00210 [Myxococcales bacterium]	diamond	135	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales 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);;