metadata: contig_metadata: 8 rows where bioproject = "PRJNA352850", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA352850", tax_kingdom = "Pseudomonadati" 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
395078	395078	PRJNA352850_P_NODE_22261_length_602_cov_1.875226_g19471_i0	PRJNA352850	22261	602	1.875226	11.28886052	Labilithrix luteola	1391654	Bacteria	Bacteria	863	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g19471	i0	92.574	118.187707641196	606	38	100	6	1	602	7090094	7090696	Labilithrix luteola strain DSM 27648, complete genome	blastn	71149	863	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2346593	2346593	PRJNA352850_P_NODE_3982_length_2142_cov_7.124224_g1_i264	PRJNA352850	3982	2142	7.124224	152.60087808	Pseudomonadati	3379134	Bacteria	Bacteria	3646	0	NTclustered	gi\|13959815\|gb\|AY033407.1\|	34	g1	i264	97.064	100.024276377218	2146	59	100	4	1	2142	1581	3726	Myxococcus xanthus USC7-1p and USC7-2p genes, complete cds	blastn	214252	3646	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
11874096	11874096	PRJNA352850_P_NODE_3730_length_2253_cov_207.582577_g1_i252	PRJNA352850	3730	2253	207.582577	4676.83545981	Myxococcus xanthus	34	Bacteria	Bacteria	2054	0	NTclustered	gi\|13959815\|gb\|AY033407.1\|	34	g1	i252	97.813	105.106524633822	1189	24	53	2	1	1187	2580	1392	Myxococcus xanthus USC7-1p and USC7-2p genes, complete cds	blastn	236805	2054	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
14423954	14423954	PRJNA352850_P_NODE_26252_length_536_cov_2.353183_g23429_i0	PRJNA352850	26252	536	2.353183	12.61306088	Labilithrix luteola	1391654	Bacteria	Bacteria	771	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g23429	i0	93.182	162.738805970149	528	31	98	4	1	525	3942690	3942165	Labilithrix luteola strain DSM 27648, complete genome	blastn	87228	771	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
26821820	26821820	PRJNA352850_P_NODE_56721_length_312_cov_2.121673_g53888_i0	PRJNA352850	56721	312	2.121673	6.61961976	Sorangium cellulosum	56	Bacteria	Bacteria	103	5.8e-24	NR	WP_275936215.1	56	g53888	i0	81.1	1.52884615384615	53	10	51	0	311	153	309	361	WP_275936215.1 RHS repeat-associated core domain-containing protein, partial [Sorangium cellulosum]	diamond	477	103	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
27643707	27643707	PRJNA352850_P_NODE_80724_length_248_cov_1.829146_g77891_i0	PRJNA352850	80724	248	1.829146	4.53628208	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	55.8	1.78e-7	NR	WP_232287436.1	161493	g77891	i0	43.3	1.62096774193548	67	34	81	3	246	46	75	137	WP_232287436.1 hypothetical protein [Anaeromyxobacter dehalogenans]	diamond	402	55.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
29600786	29600786	PRJNA352850_P_NODE_6250_length_1557_cov_2.805703_g4428_i0	PRJNA352850	6250	1557	2.805703	43.68479571	Nannocystis pusilla	889268	Bacteria	Bacteria	132	6.01e-29	NR	WP_224195048.1	889268	g4428	i0	33.3	0.919075144508671	237	150	45.5	4	1555	848	302	531	WP_224195048.1 hypothetical protein [Nannocystis pusilla]	diamond	1431	132	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis pusilla
31781420	31781420	PRJNA352850_P_NODE_15377_length_788_cov_5.648173_g12750_i0	PRJNA352850	15377	788	5.648173	44.50760324	Myxococcales bacterium	2026763	Bacteria	Bacteria	117	4.97e-28	NR	HBQ17276.1	2026763	g12750	i0	32.6	0.852791878172589	224	143	84.5	5	3	668	20	237	HBQ17276.1 N-formylglutamate amidohydrolase [Myxococcales bacterium]	diamond	672	117	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);;