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

16 rows where analysis = "blastn", bioproject = "PRJNA1047749" 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
174967	174967	PRJNA1047749_P_NODE_22961_length_301_cov_8.416667_g22694_i0	PRJNA1047749	22961	301	8.416667	25.33416767	Sorangium cellulosum	56	Bacteria	Bacteria	124	5.85e-24	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g22694	i0	84.8	39.3787375415282	125	17	41	2	177	300	649110	649233	Sorangium cellulosum So0157-2, complete genome	blastn	11853	124	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
175023	175023	PRJNA1047749_P_NODE_25661_length_300_cov_3.700441_g25394_i0	PRJNA1047749	25661	300	3.700441	11.101323	Cystobacter fuscus	43	Bacteria	Bacteria	187	7.33e-43	NTclustered	gi\|1243034522\|gb\|CP022098.1\|	43	g25394	i0	88.816	0.506666666666667	152	17	51	0	144	295	4942412	4942261	Cystobacter fuscus strain DSM 52655 chromosome, complete genome	blastn	152	187	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
175029	175029	PRJNA1047749_P_NODE_25961_length_300_cov_2.577093_g25694_i0	PRJNA1047749	25961	300	2.577093	7.731279	Polyangium aurulentum	2567896	Bacteria	Bacteria	139	2.08e-28	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g25694	i0	84.507	43.1566666666667	142	20	47	2	147	287	2826434	2826574	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	12947	139	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
4001376	4001376	PRJNA1047749_P_NODE_18424_length_312_cov_3.836820_g18157_i0	PRJNA1047749	18424	312	3.83682	11.9708784	Pendulispora rubella	2741070	Bacteria	Bacteria	209	1.64e-49	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g18157	i0	92.466	2.83012820512821	146	11	47	0	6	151	2348673	2348528	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	883	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
4001485	4001485	PRJNA1047749_P_NODE_24704_length_301_cov_2.986842_g24437_i0	PRJNA1047749	24704	301	2.986842	8.99039442	Sorangium cellulosum	56	Bacteria	Bacteria	152	2.6799999999999996e-32	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g24437	i0	85.616	3.48172757475083	146	19	48	2	7	151	7734240	7734384	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	1048	152	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6552793	6552793	PRJNA1047749_P_NODE_16306_length_312_cov_6.602510_g16039_i0	PRJNA1047749	16306	312	6.60251	20.5998312	Nannocystis punicea	2995304	Bacteria	Bacteria	147	1.3e-30	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g16039	i0	84.106	3.25320512820513	151	24	48	0	1	151	6342280	6342430	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	1015	147	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
6553191	6553191	PRJNA1047749_P_NODE_42306_length_244_cov_0.912281_g42039_i0	PRJNA1047749	42306	244	0.912281	2.22596564	Minicystis rosea	888845	Bacteria	Bacteria	154	5.87e-33	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g42039	i0	78.814	0.967213114754098	236	44	95	6	3	235	6893512	6893280	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	236	154	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
7827644	7827644	PRJNA1047749_P_NODE_28347_length_294_cov_1.904977_g28080_i0	PRJNA1047749	28347	294	1.904977	5.60063238	Sorangium cellulosum	56	Bacteria	Bacteria	84.2	9.67e-12	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g28080	i0	88.571	1.40136054421769	70	7	23	1	207	275	12741221	12741152	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	412	84.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9102636	9102636	PRJNA1047749_P_NODE_27148_length_297_cov_4.950893_g26881_i0	PRJNA1047749	27148	297	4.950893	14.70415221	Labilithrix luteola	1391654	Bacteria	Bacteria	198	3.3499999999999997e-46	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g26881	i0	91.667	6.75757575757576	144	10	48	2	8	150	9108032	9107890	Labilithrix luteola strain DSM 27648, complete genome	blastn	2007	198	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10378092	10378092	PRJNA1047749_P_NODE_15889_length_312_cov_8.451883_g15622_i0	PRJNA1047749	15889	312	8.451883	26.36987496	Myxococcus sp. MxC21-1	3041439	Bacteria	Bacteria	122	2.19e-23	NTclustered	gi\|2592002496\|gb\|CP123278.1\|	3041439	g15622	i0	81.757	7.91666666666667	148	25	47	2	1	147	5107721	5107867	Myxococcus sp. MxC21-1 chromosome, complete genome	blastn	2470	122	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MxC21-1
15037931	15037931	PRJNA1047749_P_NODE_31352_length_282_cov_1.363636_g31085_i0	PRJNA1047749	31352	282	1.363636	3.84545352	Sorangium	39643	Bacteria	Bacteria	209	1.46e-49	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g31085	i0	87.363	18.1489361702128	182	23	65	0	89	270	1021777	1021596	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	5118	209	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16752023	16752023	PRJNA1047749_P_NODE_30994_length_283_cov_3.676190_g30727_i0	PRJNA1047749	30994	283	3.67619	10.4036177	Melittangium boletus	83453	Bacteria	Bacteria	130	1.17e-25	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g30727	i0	83.333	16.2720848056537	144	20	50	4	124	265	6490145	6490004	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	4605	130	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
16752190	16752190	PRJNA1047749_P_NODE_42174_length_244_cov_2.421053_g41907_i0	PRJNA1047749	42174	244	2.421053	5.90736932	Minicystis rosea	888845	Bacteria	Bacteria	176	1.25e-39	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g41907	i0	80.769	6.68032786885246	234	37	94	8	15	244	9614237	9614008	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	1630	176	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
18026701	18026701	PRJNA1047749_P_NODE_19255_length_312_cov_3.280335_g18988_i0	PRJNA1047749	19255	312	3.280335	10.2346452	Polyangium aurulentum	2567896	Bacteria	Bacteria	167	9.98e-37	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g18988	i0	87.075	0.916666666666667	147	19	47	0	3	149	6597067	6596921	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	286	167	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
18027059	18027059	PRJNA1047749_P_NODE_41975_length_244_cov_7.274854_g41708_i0	PRJNA1047749	41975	244	7.274854	17.75064376	Nannocystis punicea	2995304	Bacteria	Bacteria	122	1.6499999999999995e-23	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g41708	i0	78.689	0.75	183	39	75	0	18	200	3565477	3565659	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	183	122	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
20575867	20575867	PRJNA1047749_P_NODE_12277_length_355_cov_7.106383_g12013_i0	PRJNA1047749	12277	355	7.106383	25.22765965	uncultured Myxococcales bacterium	253830	Bacteria	Bacteria	73.1	2.58e-8	NTclustered	gi\|219811770\|gb\|FJ551984.1\|	253830	g12013	i0	93.878	4.01971830985916	49	1	14	2	306	353	924	971	Uncultured Myxococcales bacterium clone LTSP_BACT_P4P17 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	1427	73.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			uncultured Myxococcales bacterium

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