metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA690592" 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
671981	671981	PRJNA690592_S_NODE_7401_length_1028_cov_189.964398_g6774_i0	PRJNA690592	7401	1028	189.964398	1952.83401144	Labilithrix luteola	1391654	Bacteria	Bacteria	1230	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g6774	i0	88.28	153.584630350195	1041	104	100	15	1	1028	3942800	3941765	Labilithrix luteola strain DSM 27648, complete genome	blastn	157885	1230	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
1179016	1179016	PRJNA690592_S_NODE_208001_length_243_cov_1.982353_g206987_i0	PRJNA690592	208001	243	1.982353	4.81711779	Pendulispora	3375062	Bacteria	Bacteria	60.2	1.31e-4	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g206987	i0	100	2.04115226337449	32	0	13	0	28	59	7292473	7292504	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	496	60.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
1947876	1947876	PRJNA690592_S_NODE_58842_length_410_cov_1.142433_g57828_i0	PRJNA690592	58842	410	1.142433	4.6839753	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g57828	i0	100	0.153658536585366	28	0	7	0	204	231	923688	923715	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	63	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
3222717	3222717	PRJNA690592_S_NODE_54763_length_422_cov_6.369628_g53749_i0	PRJNA690592	54763	422	6.369628	26.87983016	Myxococcus sp. SDU36	2831967	Bacteria	Bacteria	60.2	2.43e-4	NTclustered	gi\|2513984958\|gb\|CP077414.1\|	2831967	g53749	i0	100	0.241706161137441	32	0	8	0	265	296	3852032	3852001	Myxococcus sp. SDU36 chromosome, complete genome	blastn	102	60.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. SDU36
5775014	5775014	PRJNA690592_S_NODE_203705_length_245_cov_0.895349_g202691_i0	PRJNA690592	203705	245	0.895349	2.19360505	Myxococcota bacterium	2818507	Bacteria	Bacteria	60.2	1.32e-4	NTclustered	gi\|2907625649\|emb\|OZ223209.1\|	2818507	g202691	i0	100	0.130612244897959	32	0	13	0	64	95	3838797	3838828	MAG: Myxococcota bacterium isolate 6e5ad1d4-156e-4916-952c-8a0b14857fe9 genome assembly, chromosome: 1	blastn	32	60.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
7556815	7556815	PRJNA690592_S_NODE_117086_length_307_cov_1.974359_g116072_i0	PRJNA690592	117086	307	1.974359	6.06128213	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g116072	i0	96.774	0.192182410423453	31	1	10	0	176	206	1109487	1109517	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	59	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
8323917	8323917	PRJNA690592_S_NODE_115007_length_310_cov_0.915612_g113993_i0	PRJNA690592	115007	310	0.915612	2.8383972	Archangium gephyra	48	Bacteria	Bacteria	281	3.39e-71	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g113993	i0	84.333	80.2870967741935	300	33	93	7	24	310	7608652	7608950	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	24889	281	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
10107769	10107769	PRJNA690592_S_NODE_73368_length_373_cov_0.826667_g72354_i0	PRJNA690592	73368	373	0.826667	3.08346791	Myxococcus	32	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g72354	i0	100	1.05093833780161	28	0	8	0	179	206	5348157	5348184	Myxococcus xanthus strain DK1050 chromosome	blastn	392	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
10875156	10875156	PRJNA690592_S_NODE_160429_length_269_cov_1.153061_g159415_i0	PRJNA690592	160429	269	1.153061	3.10173409	Labilithrix luteola	1391654	Bacteria	Bacteria	58.4	5.3e-4	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g159415	i0	100	0.226765799256506	31	0	12	0	28	58	8005080	8005050	Labilithrix luteola strain DSM 27648, complete genome	blastn	61	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
13425188	13425188	PRJNA690592_S_NODE_19491_length_676_cov_1.834163_g18541_i0	PRJNA690592	19491	676	1.834163	12.39894188	Myxococcales bacterium	2026763	Bacteria	Bacteria	593	8.93e-165	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g18541	i0	83.008	156.721893491124	665	103	97	8	1	659	1313594	1312934	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	105944	593	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
14699914	14699914	PRJNA690592_S_NODE_14152_length_780_cov_21.531825_g13281_i0	PRJNA690592	14152	780	21.531825	167.948235	Labilithrix luteola	1391654	Bacteria	Bacteria	1024	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g13281	i0	90.343	115.532051282051	787	66	100	7	1	780	7089921	7090704	Labilithrix luteola strain DSM 27648, complete genome	blastn	90115	1024	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
14700933	14700933	PRJNA690592_S_NODE_7132_length_1043_cov_24.808247_g6515_i0	PRJNA690592	7132	1043	24.808247	258.75001621	Pendulispora rubella	2741070	Bacteria	Bacteria	1375	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g6515	i0	90.595	162.351869606903	1042	91	100	6	4	1043	7290012	7288976	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	169333	1375	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
19798662	19798662	PRJNA690592_S_NODE_41076_length_479_cov_1.423645_g40062_i0	PRJNA690592	41076	479	1.423645	6.81925955	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	634	3.639999999999999e-177	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g40062	i0	90.586	124.296450939457	478	45	99	0	2	479	8616391	8615914	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	59538	634	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
21073342	21073342	PRJNA690592_S_NODE_136877_length_288_cov_1.423256_g135863_i0	PRJNA690592	136877	288	1.423256	4.09897728	Pendulispora albinea	2741071	Bacteria	Bacteria	267	8.74e-67	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g135863	i0	83.803	0.986111111111111	284	42	98	4	6	287	1512921	1513202	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	284	267	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
22348057	22348057	PRJNA690592_S_NODE_10398_length_893_cov_1.884146_g9631_i0	PRJNA690592	10398	893	1.884146	16.82542378	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	54.7	0.025	NTclustered	gi\|2108117163\|gb\|CP070734.1\|	2026735	g9631	i0	100	0.032474804031355	29	0	3	0	698	726	2969383	2969411	MAG: Deltaproteobacteria bacterium isolate bin407 chromosome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
24897164	24897164	PRJNA690592_S_NODE_134260_length_290_cov_1.953917_g133246_i0	PRJNA690592	134260	290	1.953917	5.6663593	Labilithrix luteola	1391654	Bacteria	Bacteria	492	1.3399999999999996e-134	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g133246	i0	97.241	133.075862068966	290	8	100	0	1	290	7090369	7090080	Labilithrix luteola strain DSM 27648, complete genome	blastn	38592	492	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);;