metadata: contig_metadata: 7 rows where bioproject = "PRJNA509429", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA509429", 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
1760512	1760512	PRJNA509429_P_NODE_43602_length_170_cov_1.429630_g42774_i0	PRJNA509429	43602	170	1.42963	2.430371	Labilithrix luteola	1391654	Bacteria	Bacteria	294	2.14e-75	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g42774	i0	97.674	70.9529411764706	172	2	100	1	1	170	3943918	3944089	Labilithrix luteola strain DSM 27648, complete genome	blastn	12062	294	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10688966	10688966	PRJNA509429_P_NODE_26169_length_248_cov_5.206573_g25341_i0	PRJNA509429	26169	248	5.206573	12.91230104	Labilithrix luteola	1391654	Bacteria	Bacteria	403	5.38e-108	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g25341	i0	95.968	207.004032258065	248	10	100	0	1	248	3944332	3944085	Labilithrix luteola strain DSM 27648, complete genome	blastn	51337	403	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10688998	10688998	PRJNA509429_P_NODE_34569_length_202_cov_1.023952_g33741_i0	PRJNA509429	34569	202	1.023952	2.06838304	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	158	3.6199999999999997e-34	NTclustered	gi\|1958031866\|gb\|CP064976.1\|	2026735	g33741	i0	81.407	98.9158415841584	199	31	99	5	4	202	2385077	2384885	MAG: Deltaproteobacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.279_cln chromosome, complete genome	blastn	19981	158	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
10689083	10689083	PRJNA509429_P_NODE_50229_length_153_cov_2.033898_g49401_i0	PRJNA509429	50229	153	2.033898	3.11186394	Chondromyces crocatus	52	Bacteria	Bacteria	158	2.58e-34	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g49401	i0	85.161	68.9346405228758	155	21	100	2	1	153	420	266	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	10547	158	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
17062513	17062513	PRJNA509429_P_NODE_2374_length_911_cov_17.006849_g1919_i0	PRJNA509429	2374	911	17.006849	154.93239439	Labilithrix luteola	1391654	Bacteria	Bacteria	1351	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1919	i0	93.435	136.89462129528	914	55	100	4	1	911	7089615	7090526	Labilithrix luteola strain DSM 27648, complete genome	blastn	124711	1351	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
19611210	19611210	PRJNA509429_P_NODE_17396_length_331_cov_1.783784_g16568_i0	PRJNA509429	17396	331	1.783784	5.90432504	Melittangium boletus	83453	Bacteria	Bacteria	313	1.3e-80	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g16568	i0	86.102	221.383685800604	295	35	89	6	39	331	3598447	3598737	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	73278	313	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
25337196	25337196	PRJNA509429_P_NODE_42520_length_173_cov_1.739130_g41692_i0	PRJNA509429	42520	173	1.73913	3.0086949	Pendulispora	3375062	Bacteria	Bacteria	182	1.78e-41	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g41692	i0	88.235	14.3121387283237	153	16	88	2	1	152	3589466	3589315	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	2476	182	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea

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