metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA662254" 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
3179290	3179290	PRJNA662254_P_NODE_61463_length_243_cov_0.905882_g60812_i0	PRJNA662254	61463	243	0.905882	2.20129326	Pendulispora brunnea	2905690	Bacteria	Bacteria	259	1.2e-64	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g60812	i0	86.008	3.97942386831276	243	32	99	2	2	243	1024673	1024432	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	967	259	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
4456270	4456270	PRJNA662254_P_NODE_53104_length_247_cov_0.885057_g52453_i0	PRJNA662254	53104	247	0.885057	2.18609079	Sorangium cellulosum	56	Bacteria	Bacteria	130	1e-25	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g52453	i0	85.039	2.1497975708502	127	19	51	0	18	144	5696948	5696822	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	531	130	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4456342	4456342	PRJNA662254_P_NODE_64724_length_241_cov_0.916667_g64073_i0	PRJNA662254	64724	241	0.916667	2.20916747	Minicystis rosea	888845	Bacteria	Bacteria	294	3.26e-75	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g64073	i0	89.076	69.6141078838174	238	24	98	2	3	239	382094	382330	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	16777	294	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
5731918	5731918	PRJNA662254_P_NODE_66025_length_240_cov_2.299401_g65374_i0	PRJNA662254	66025	240	2.299401	5.5185624	Labilithrix luteola	1391654	Bacteria	Bacteria	183	7.339999999999998e-42	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g65374	i0	83.092	0.8625	207	29	85	6	17	220	7013755	7013552	Labilithrix luteola strain DSM 27648, complete genome	blastn	207	183	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
8281585	8281585	PRJNA662254_P_NODE_59887_length_244_cov_0.900585_g59236_i0	PRJNA662254	59887	244	0.900585	2.1974274	Sorangium cellulosum	56	Bacteria	Bacteria	211	3.43e-50	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g59236	i0	82.979	5.81967213114754	235	39	96	1	2	236	3498750	3498517	Sorangium cellulosum 'So ce 56' complete genome	blastn	1420	211	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
13382404	13382404	PRJNA662254_P_NODE_50791_length_248_cov_0.880000_g50140_i0	PRJNA662254	50791	248	0.88	2.1824	Polyangium aurulentum	2567896	Bacteria	Bacteria	204	5.849999999999999e-48	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g50140	i0	81.673	2.58467741935484	251	40	100	6	1	248	3616897	3616650	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	641	204	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
13382474	13382474	PRJNA662254_P_NODE_62971_length_242_cov_0.911243_g62320_i0	PRJNA662254	62971	242	0.911243	2.20520806	Chondromyces crocatus	52	Bacteria	Bacteria	182	2.66e-41	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g62320	i0	82.547	0.87603305785124	212	31	86	4	9	217	5177425	5177217	Chondromyces crocatus strain Cm c5, complete genome	blastn	212	182	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
14657276	14657276	PRJNA662254_P_NODE_51092_length_248_cov_0.880000_g50441_i0	PRJNA662254	51092	248	0.88	2.1824	Myxococcus sp. MxC21-1	3041439	Bacteria	Bacteria	220	5.81e-53	NTclustered	gi\|2592002496\|gb\|CP123278.1\|	3041439	g50441	i0	82.869	85.4072580645161	251	37	100	4	1	248	5326934	5326687	Myxococcus sp. MxC21-1 chromosome, complete genome	blastn	21181	220	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MxC21-1
15190514	15190514	PRJNA662254_P_NODE_55512_length_246_cov_0.890173_g54861_i0	PRJNA662254	55512	246	0.890173	2.18982558	Sorangium	39643	Bacteria	Bacteria	145	3.56e-30	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g54861	i0	80.097	1.67479674796748	206	32	82	7	2	203	3406506	3406706	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	412	145	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15931264	15931264	PRJNA662254_P_NODE_57493_length_245_cov_0.895349_g56842_i0	PRJNA662254	57493	245	0.895349	2.19360505	Nannocystis punicea	2995304	Bacteria	Bacteria	167	7.57e-37	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g56842	i0	79.487	1.09795918367347	234	48	96	0	1	234	12947578	12947345	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	269	167	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
18480744	18480744	PRJNA662254_P_NODE_55955_length_246_cov_0.890173_g55304_i0	PRJNA662254	55955	246	0.890173	2.18982558	Labilithrix luteola	1391654	Bacteria	Bacteria	327	3.3e-85	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g55304	i0	90.65	62.7479674796748	246	23	100	0	1	246	9982472	9982227	Labilithrix luteola strain DSM 27648, complete genome	blastn	15436	327	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
19013545	19013545	PRJNA662254_P_NODE_63695_length_242_cov_0.911243_g63044_i0	PRJNA662254	63695	242	0.911243	2.20520806	Sorangium	39643	Bacteria	Bacteria	180	9.58e-41	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g63044	i0	83.251	22.8595041322314	203	26	82	8	3	201	9515602	9515800	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	5532	180	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19755286	19755286	PRJNA662254_P_NODE_53616_length_247_cov_0.885057_g52965_i0	PRJNA662254	53616	247	0.885057	2.18609079	Sorangium cellulosum	56	Bacteria	Bacteria	89.8	1.7e-13	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g52965	i0	98.039	2.44939271255061	51	1	21	0	35	85	5962337	5962287	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	605	89.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21030882	21030882	PRJNA662254_P_NODE_51177_length_248_cov_0.880000_g50526_i0	PRJNA662254	51177	248	0.88	2.1824	Labilithrix luteola	1391654	Bacteria	Bacteria	182	2.74e-41	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g50526	i0	80.417	5.18548387096774	240	45	96	2	1	239	11254548	11254310	Labilithrix luteola strain DSM 27648, complete genome	blastn	1286	182	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21030883	21030883	PRJNA662254_P_NODE_51197_length_248_cov_0.880000_g50546_i0	PRJNA662254	51197	248	0.88	2.1824	Labilithrix luteola	1391654	Bacteria	Bacteria	183	7.62e-42	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g50546	i0	83.59	9.20161290322581	195	32	79	0	36	230	4812511	4812317	Labilithrix luteola strain DSM 27648, complete genome	blastn	2282	183	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22305610	22305610	PRJNA662254_P_NODE_48278_length_250_cov_0.870056_g47627_i0	PRJNA662254	48278	250	0.870056	2.17514	Sorangium cellulosum	56	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g47627	i0	100	0.112	28	0	11	0	51	78	8989664	8989637	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24854692	24854692	PRJNA662254_P_NODE_65000_length_241_cov_0.916667_g64349_i0	PRJNA662254	65000	241	0.916667	2.20916747	Labilithrix luteola	1391654	Bacteria	Bacteria	270	5.499999999999999e-68	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g64349	i0	87.448	100.319502074689	239	24	98	5	6	241	9080639	9080404	Labilithrix luteola strain DSM 27648, complete genome	blastn	24177	270	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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