metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1166865" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1166865" 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
312318	312318	PRJNA1166865_P_NODE_19761_length_483_cov_1.617073_g19520_i0	PRJNA1166865	19761	483	1.617073	7.81046259	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	52.8	0.047	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g19520	i0	100	0.0579710144927536	28	0	6	0	314	341	6750558	6750531	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
312517	312517	PRJNA1166865_P_NODE_27341_length_411_cov_1.822485_g27100_i0	PRJNA1166865	27341	411	1.822485	7.49041335	Labilithrix luteola	1391654	Bacteria	Bacteria	392	2.05e-104	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g27100	i0	84.223	268.549878345499	412	56	99	9	5	411	3942197	3941790	Labilithrix luteola strain DSM 27648, complete genome	blastn	110374	392	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
313876	313876	PRJNA1166865_P_NODE_82881_length_247_cov_0.885057_g82640_i0	PRJNA1166865	82881	247	0.885057	2.18609079	Sorangium cellulosum	56	Bacteria	Bacteria	58.4	4.8e-4	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g82640	i0	97.059	0.137651821862348	34	1	14	0	73	106	483366	483333	Sorangium cellulosum 'So ce 56' complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4140665	4140665	PRJNA1166865_P_NODE_81064_length_248_cov_0.880000_g80823_i0	PRJNA1166865	81064	248	0.88	2.1824	Myxococcus xanthus	34	Bacteria	Bacteria	193	1.27e-44	NTclustered	gi\|1691485482\|gb\|CP017169.1\|	34	g80823	i0	84.264	3.97177419354839	197	31	79	0	49	245	2875712	2875908	Myxococcus xanthus strain GH3.5.6c2 chromosome, complete genome	blastn	985	193	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
6142504	6142504	PRJNA1166865_P_NODE_75665_length_251_cov_0.865169_g75424_i0	PRJNA1166865	75665	251	0.865169	2.17157419	Myxococcaceae	31	Bacteria	Bacteria	206	1.65e-48	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g75424	i0	89.571	63.6414342629482	163	15	65	2	1	162	7897698	7897537	Myxococcus xanthus strain DK1050 chromosome	blastn	15974	206	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
9241611	9241611	PRJNA1166865_P_NODE_73888_length_253_cov_1.711111_g73647_i0	PRJNA1166865	73888	253	1.711111	4.32911083	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	154	6.12e-33	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g73647	i0	86.014	41.2134387351779	143	20	57	0	1	143	304933	305075	Anaeromyxobacter paludicola DNA, complete genome	blastn	10427	154	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
10516587	10516587	PRJNA1166865_P_NODE_44669_length_328_cov_1.615686_g44428_i0	PRJNA1166865	44669	328	1.615686	5.29945008	Pendulispora albinea	2741071	Bacteria	Bacteria	206	2.24e-48	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g44428	i0	78.931	35.3384146341463	318	55	95	11	17	328	1599287	1598976	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	11591	206	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
11791213	11791213	PRJNA1166865_P_NODE_31470_length_384_cov_2.360129_g31229_i0	PRJNA1166865	31470	384	2.360129	9.06289536	Minicystis rosea	888845	Bacteria	Bacteria	67.6	1.31e-6	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g31229	i0	93.333	0.1171875	45	3	12	0	304	348	1826865	1826821	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	45	67.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
11791392	11791392	PRJNA1166865_P_NODE_38650_length_350_cov_1.111913_g38409_i0	PRJNA1166865	38650	350	1.111913	3.8916955	Nannocystis punicea	2995304	Bacteria	Bacteria	307	6.390000000000001e-79	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g38409	i0	85.911	70.3685714285714	291	38	83	3	16	305	5377565	5377277	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	24629	307	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
14342709	14342709	PRJNA1166865_P_NODE_78392_length_250_cov_0.870056_g78151_i0	PRJNA1166865	78392	250	0.870056	2.17514	Sorangium cellulosum	56	Bacteria	Bacteria	198	2.75e-46	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g78151	i0	81.028	1.012	253	45	100	1	1	250	8905302	8905050	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	253	198	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15616777	15616777	PRJNA1166865_P_NODE_88613_length_244_cov_0.900585_g88372_i0	PRJNA1166865	88613	244	0.900585	2.1974274	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	255	1.5600000000000001e-63	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g88372	i0	89.552	6.49180327868852	201	21	82	0	38	238	2013419	2013619	Anaeromyxobacter paludicola DNA, complete genome	blastn	1584	255	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
17617289	17617289	PRJNA1166865_P_NODE_20894_length_470_cov_1.163728_g20653_i0	PRJNA1166865	20894	470	1.163728	5.4695216	Bacteria	2	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g20653	i0	96.774	0.125531914893617	31	1	7	0	277	307	10446644	10446674	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	59	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
21990124	21990124	PRJNA1166865_P_NODE_64378_length_276_cov_1.137931_g64137_i0	PRJNA1166865	64378	276	1.137931	3.14068956	Nannocystis punicea	2995304	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g64137	i0	100	0.108695652173913	30	0	11	0	120	149	5628446	5628417	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea

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