metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA683902" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA683902" 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
1175506	1175506	PRJNA683902_S_NODE_29241_length_181_cov_2.722222_g28797_i0	PRJNA683902	29241	181	2.722222	4.92722182	Sorangium	39643	Bacteria	Bacteria	285	1.39e-72	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g28797	i0	95.028	153.39226519337	181	9	100	0	1	181	2994958	2994778	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	27764	285	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
5003939	5003939	PRJNA683902_S_NODE_30384_length_177_cov_1.578571_g29940_i0	PRJNA683902	30384	177	1.578571	2.79407067	Haliangium	162027	Bacteria	Bacteria	185	1.4099999999999999e-42	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g29940	i0	86.747	136.64406779661	166	22	94	0	3	168	1776	1611	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	24186	185	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
7043800	7043800	PRJNA683902_S_NODE_10606_length_430_cov_17.826972_g10164_i0	PRJNA683902	10606	430	17.826972	76.6559796	Labilithrix luteola	1391654	Bacteria	Bacteria	516	1.22e-141	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10164	i0	88.558	172.779069767442	437	35	100	15	1	430	7090066	7090494	Labilithrix luteola strain DSM 27648, complete genome	blastn	74295	516	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
9593792	9593792	PRJNA683902_S_NODE_13508_length_337_cov_3.356667_g13064_i0	PRJNA683902	13508	337	3.356667	11.31196779	Pendulispora albinea	2741071	Bacteria	Bacteria	405	2.12e-108	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g13064	i0	88.462	157.347181008902	338	36	100	3	1	337	3589909	3590244	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	53026	405	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
10869361	10869361	PRJNA683902_S_NODE_37229_length_156_cov_2.705882_g36785_i0	PRJNA683902	37229	156	2.705882	4.22117592	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	191	2.61e-44	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g36785	i0	89.032	101.673076923077	155	15	98	2	1	153	9679246	9679092	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	15861	191	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15204029	15204029	PRJNA683902_S_NODE_22972_length_215_cov_2.584270_g22528_i0	PRJNA683902	22972	215	2.58427	5.5561805	Sorangium	39643	Bacteria	Bacteria	381	2.1299999999999996e-101	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g22528	i0	98.605	145.227906976744	215	3	100	0	1	215	3690327	3690541	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	31224	381	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
17243341	17243341	PRJNA683902_S_NODE_40014_length_150_cov_1.495575_g39570_i0	PRJNA683902	40014	150	1.495575	2.2433625	Minicystis rosea	888845	Bacteria	Bacteria	172	8.99e-39	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g39570	i0	88.276	20.3733333333333	145	15	96	2	5	148	770557	770414	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	3056	172	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
23618242	23618242	PRJNA683902_S_NODE_35339_length_161_cov_1.540323_g34895_i0	PRJNA683902	35339	161	1.540323	2.47992003	Polyangium aurulentum	2567896	Bacteria	Bacteria	171	3.54e-38	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g34895	i0	85.802	61.6273291925466	162	21	100	2	1	161	443160	443000	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	9922	171	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum

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