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

16 rows where analysis = "blastn", bioproject = "PRJNA724011" 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
710982	710982	PRJNA724011_P_NODE_98321_length_248_cov_0.880000_g97298_i0	PRJNA724011	98321	248	0.88	2.1824	Sorangium cellulosum	56	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g97298	i0	100	0.116935483870968	29	0	12	0	123	151	14316068	14316040	Sorangium cellulosum So0157-2, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7089118	7089118	PRJNA724011_P_NODE_101306_length_246_cov_0.890173_g100283_i0	PRJNA724011	101306	246	0.890173	2.18982558	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g100283	i0	100	0.117886178861789	29	0	12	0	134	162	4964505	4964533	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
8363847	8363847	PRJNA724011_P_NODE_30927_length_496_cov_1.423168_g29908_i0	PRJNA724011	30927	496	1.423168	7.05891328	Corallococcus sp. NCRR	2996782	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|2415015785\|gb\|CP114039.1\|	2996782	g29908	i0	94.444	0.0725806451612903	36	1	7	1	142	176	8097474	8097509	Corallococcus sp. NCRR chromosome, complete genome	blastn	36	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. NCRR
10122363	10122363	PRJNA724011_P_NODE_26288_length_549_cov_2.441176_g25272_i0	PRJNA724011	26288	549	2.441176	13.40205624	Sorangium	39643	Bacteria	Bacteria	555	3.379999999999999e-153	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g25272	i0	85.045	120.577413479053	555	71	99	11	4	549	1135	1686	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	66197	555	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
10914959	10914959	PRJNA724011_P_NODE_82769_length_271_cov_2.333333_g81746_i0	PRJNA724011	82769	271	2.333333	6.32333243	Polyangium aurulentum	2567896	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g81746	i0	100	0.103321033210332	28	0	10	0	242	269	3752336	3752309	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
13464609	13464609	PRJNA724011_P_NODE_73011_length_293_cov_1.395455_g71988_i0	PRJNA724011	73011	293	1.395455	4.08868315	Pendulispora rubella	2741070	Bacteria	Bacteria	335	2.409999999999999e-87	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g71988	i0	87.458	444.491467576792	295	32	99	5	1	292	7289711	7290003	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	130236	335	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
13464731	13464731	PRJNA724011_P_NODE_90371_length_257_cov_1.255435_g89348_i0	PRJNA724011	90371	257	1.255435	3.22646795	Minicystis rosea	888845	Bacteria	Bacteria	420	5.56e-113	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g89348	i0	96.109	170.186770428016	257	10	100	0	1	257	15982273	15982017	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	43738	420	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
14739853	14739853	PRJNA724011_P_NODE_68172_length_305_cov_2.189655_g67149_i0	PRJNA724011	68172	305	2.189655	6.67844775	Labilithrix luteola	1391654	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g67149	i0	100	0.0918032786885246	28	0	9	0	23	50	3572114	3572087	Labilithrix luteola strain DSM 27648, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17288486	17288486	PRJNA724011_P_NODE_15034_length_785_cov_2.132022_g14081_i0	PRJNA724011	15034	785	2.132022	16.7363727	Myxococcales bacterium	2026763	Bacteria	Bacteria	65.8	1.01e-5	NTclustered	gi\|2108369872\|gb\|CP070650.1\|	2026763	g14081	i0	91.489	0.110828025477707	47	4	6	0	530	576	1349515	1349469	MAG: Myxococcales bacterium isolate bin861 chromosome	blastn	87	65.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
21113450	21113450	PRJNA724011_P_NODE_78477_length_280_cov_2.753623_g77454_i0	PRJNA724011	78477	280	2.753623	7.7101444	Archangium gephyra	48	Bacteria	Bacteria	110	1.51e-19	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g77454	i0	90.361	6.35	83	8	30	0	80	162	3768038	3767956	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	1778	110	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
21595928	21595928	PRJNA724011_P_NODE_106777_length_243_cov_0.905882_g105754_i0	PRJNA724011	106777	243	0.905882	2.20129326	Sorangium	39643	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g105754	i0	100	0.230452674897119	28	0	12	0	145	172	11986878	11986851	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
22387829	22387829	PRJNA724011_P_NODE_109138_length_241_cov_1.505952_g108115_i0	PRJNA724011	109138	241	1.505952	3.62934432	Labilithrix luteola	1391654	Bacteria	Bacteria	412	8.64e-111	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g108115	i0	97.51	267.850622406639	241	6	100	0	1	241	3944644	3944404	Labilithrix luteola strain DSM 27648, complete genome	blastn	64552	412	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22871547	22871547	PRJNA724011_P_NODE_85838_length_265_cov_3.041667_g84815_i0	PRJNA724011	85838	265	3.041667	8.06041755	Sorangium	39643	Bacteria	Bacteria	311	3.62e-80	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g84815	i0	87.636	78.988679245283	275	24	100	6	1	265	2995731	2995457	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	20932	311	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
23663732	23663732	PRJNA724011_P_NODE_51819_length_359_cov_1.076923_g50796_i0	PRJNA724011	51819	359	1.076923	3.86615357	Nannocystis punicea	2995304	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g50796	i0	100	0.0779944289693593	28	0	8	0	67	94	13134384	13134357	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
23664066	23664066	PRJNA724011_P_NODE_99059_length_248_cov_0.880000_g98036_i0	PRJNA724011	99059	248	0.88	2.1824	Archangium gephyra	48	Bacteria	Bacteria	219	2.0899999999999994e-52	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g98036	i0	83.913	79.8064516129032	230	35	92	2	20	248	8321998	8321770	Archangium gephyra strain DSM 2261, complete genome	blastn	19792	219	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
24937197	24937197	PRJNA724011_P_NODE_49460_length_369_cov_1.543919_g48437_i0	PRJNA724011	49460	369	1.543919	5.69706111	Labilithrix luteola	1391654	Bacteria	Bacteria	433	1.0699999999999999e-116	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g48437	i0	87.903	117.184281842818	372	39	99	5	2	369	7915786	7915417	Labilithrix luteola strain DSM 27648, complete genome	blastn	43241	433	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);;