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

16 rows where analysis = "blastn", bioproject = "PRJNA289590" 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
1059475	1059475	PRJNA289590_P_NODE_3521_length_557_cov_12.826772_g3305_i0	PRJNA289590	3521	557	12.826772	71.44512004	Pendulispora	3375062	Bacteria	Bacteria	893	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g3305	i0	95.833	151.125673249551	552	23	99	0	6	557	7289424	7288873	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	84177	893	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
1647103	1647103	PRJNA289590_P_NODE_14622_length_236_cov_2.502674_g14398_i0	PRJNA289590	14622	236	2.502674	5.90631064	Labilithrix luteola	1391654	Bacteria	Bacteria	233	7.039999999999999e-57	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g14398	i0	86.667	8.6228813559322	210	28	89	0	15	224	9544697	9544488	Labilithrix luteola strain DSM 27648, complete genome	blastn	2035	233	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2923097	2923097	PRJNA289590_P_NODE_17523_length_214_cov_10.993939_g17299_i0	PRJNA289590	17523	214	10.993939	23.52702946	Labilithrix luteola	1391654	Bacteria	Bacteria	239	1.35e-58	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g17299	i0	98.529	91.8785046728972	136	1	63	1	14	148	3945048	3944913	Labilithrix luteola strain DSM 27648, complete genome	blastn	19662	239	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5476169	5476169	PRJNA289590_P_NODE_31025_length_162_cov_0.920354_g30801_i0	PRJNA289590	31025	162	0.920354	1.49097348	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	110	7.89e-20	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g30801	i0	89.535	0.530864197530864	86	9	53	0	21	106	35764	35849	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	86	110	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
6162233	6162233	PRJNA289590_P_NODE_27865_length_167_cov_0.864407_g27641_i0	PRJNA289590	27865	167	0.864407	1.44355969	Sorangium	39643	Bacteria	Bacteria	134	4.86e-27	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g27641	i0	96.296	2.4251497005988	81	3	49	0	84	164	7703255	7703175	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	405	134	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7437382	7437382	PRJNA289590_P_NODE_6666_length_372_cov_1.386997_g6442_i0	PRJNA289590	6666	372	1.386997	5.15962884	Pendulispora	3375062	Bacteria	Bacteria	219	3.3e-52	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g6442	i0	85.135	53.5698924731183	222	23	57	6	151	362	2910084	2909863	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	19928	220	0.995454545454545	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
8025854	8025854	PRJNA289590_P_NODE_24127_length_178_cov_0.868217_g23903_i0	PRJNA289590	24127	178	0.868217	1.54542626	Polyangium aurulentum	2567896	Bacteria	Bacteria	169	1.4299999999999998e-37	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g23903	i0	84.483	2.56741573033708	174	23	97	4	5	176	8370530	8370359	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	457	169	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
8025917	8025917	PRJNA289590_P_NODE_26727_length_168_cov_0.873950_g26503_i0	PRJNA289590	26727	168	0.87395	1.468236	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	209	7.9100000000000005e-50	NTclustered	gi\|1958031866\|gb\|CP064976.1\|	2026735	g26503	i0	89.222	332.154761904762	167	18	99	0	2	168	2384963	2384797	MAG: Deltaproteobacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.279_cln chromosome, complete genome	blastn	55802	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
8712153	8712153	PRJNA289590_P_NODE_5587_length_414_cov_4.487671_g5363_i0	PRJNA289590	5587	414	4.487671	18.57895794	Polyangiaceae	49	Bacteria	Bacteria	387	9.61e-103	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g5363	i0	84.314	122.495169082126	408	50	96	11	16	412	1870	1466	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	50713	387	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
9300531	9300531	PRJNA289590_P_NODE_18348_length_209_cov_1.300000_g18124_i0	PRJNA289590	18348	209	1.3	2.717	Pendulispora rubella	2741070	Bacteria	Bacteria	154	4.88e-33	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g18124	i0	97.778	52.2631578947368	90	1	43	1	40	128	4257012	4256923	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	10923	154	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
14401629	14401629	PRJNA289590_P_NODE_29132_length_165_cov_0.896552_g28908_i0	PRJNA289590	29132	165	0.896552	1.4793108	Haliangium ochraceum	80816	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g28908	i0	94.286	0.212121212121212	35	1	21	1	79	112	7816061	7816027	Haliangium ochraceum DSM 14365, complete genome	blastn	35	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
16950061	16950061	PRJNA289590_P_NODE_30514_length_163_cov_0.912281_g30290_i0	PRJNA289590	30514	163	0.912281	1.48701803	Minicystis rosea	888845	Bacteria	Bacteria	233	4.52e-57	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g30290	i0	93.59	89.6564417177914	156	10	96	0	8	163	8033971	8033816	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	14614	233	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
20774185	20774185	PRJNA289590_P_NODE_30557_length_163_cov_0.912281_g30333_i0	PRJNA289590	30557	163	0.912281	1.48701803	uncultured Sorangium sp.	491148	Bacteria	Bacteria	161	2.16e-35	NTclustered	gi\|219812134\|gb\|FJ552348.1\|	491148	g30333	i0	92.857	105.337423312883	112	6	69	2	1	112	622	731	Uncultured Sorangium sp. clone LTSP_BACT_P6A23 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17170	161	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	uncultured Sorangium sp.
20774244	20774244	PRJNA289590_P_NODE_4777_length_457_cov_57.343137_g4555_i0	PRJNA289590	4777	457	57.343137	262.05813609	Labilithrix luteola	1391654	Bacteria	Bacteria	551	3.5899999999999986e-152	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4555	i0	88.962	113.019693654267	453	40	98	7	5	450	3943493	3943044	Labilithrix luteola strain DSM 27648, complete genome	blastn	51650	551	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
20774368	20774368	PRJNA289590_P_NODE_9937_length_294_cov_1.191837_g9713_i0	PRJNA289590	9937	294	1.191837	3.50400078	Pendulispora albinea	2741071	Bacteria	Bacteria	309	1.4700000000000002e-79	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g9713	i0	89.388	11.4489795918367	245	26	83	0	48	292	9215333	9215577	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	3366	309	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
22048907	22048907	PRJNA289590_P_NODE_1858_length_896_cov_32.639906_g1666_i0	PRJNA289590	1858	896	32.639906	292.45355776	Labilithrix luteola	1391654	Bacteria	Bacteria	763	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1666	i0	88.136	93.6082589285714	649	68	72	9	1	644	3942377	3941733	Labilithrix luteola strain DSM 27648, complete genome	blastn	83873	763	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);;