metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1086823" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1086823" 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
193751	193751	PRJNA1086823_P_NODE_16361_length_246_cov_0.901734_g16244_i0	PRJNA1086823	16361	246	0.901734	2.21826564	Labilithrix luteola	1391654	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g16244	i0	98.78	218.585365853659	246	3	100	0	1	246	3944332	3944087	Labilithrix luteola strain DSM 27648, complete genome	blastn	53772	438	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10397173	10397173	PRJNA1086823_P_NODE_2889_length_449_cov_2.156915_g2772_i0	PRJNA1086823	2889	449	2.156915	9.68454835	Labilithrix luteola	1391654	Bacteria	Bacteria	566	1.2599999999999999e-156	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g2772	i0	89.556	118.712694877506	450	42	99	5	3	449	3943438	3942991	Labilithrix luteola strain DSM 27648, complete genome	blastn	53302	566	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12947333	12947333	PRJNA1086823_P_NODE_10311_length_269_cov_3.494898_g10194_i0	PRJNA1086823	10311	269	3.494898	9.40127562	Labilithrix luteola	1391654	Bacteria	Bacteria	396	9.88e-106	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10194	i0	93.284	198.657992565056	268	18	99	0	1	268	3942063	3942330	Labilithrix luteola strain DSM 27648, complete genome	blastn	53439	396	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12947373	12947373	PRJNA1086823_P_NODE_11971_length_253_cov_1.733333_g11854_i0	PRJNA1086823	11971	253	1.733333	4.38533249	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	424	4.22e-114	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g11854	i0	96.838	250.723320158103	253	8	100	0	1	253	2161051	2161303	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	63433	424	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
14222684	14222684	PRJNA1086823_P_NODE_9892_length_273_cov_3.340000_g9775_i0	PRJNA1086823	9892	273	3.34	9.1182	Labilithrix luteola	1391654	Bacteria	Bacteria	305	1.74e-78	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9775	i0	87.004	258.461538461538	277	29	100	7	1	273	3941765	3942038	Labilithrix luteola strain DSM 27648, complete genome	blastn	70560	305	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16770582	16770582	PRJNA1086823_P_NODE_11894_length_254_cov_1.508287_g11777_i0	PRJNA1086823	11894	254	1.508287	3.83104898	Archangium violaceum	83451	Bacteria	Bacteria	165	2.84e-36	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g11777	i0	78.682	11.1929133858268	258	47	100	7	1	254	4830307	4830054	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	2843	165	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
18869021	18869021	PRJNA1086823_P_NODE_16695_length_246_cov_0.901734_g16578_i0	PRJNA1086823	16695	246	0.901734	2.21826564	Polyangiales	3031712	Bacteria	Bacteria	233	7.39e-57	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g16578	i0	83.806	82.5406504065041	247	39	100	1	1	246	12645292	12645046	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	20305	233	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
20594781	20594781	PRJNA1086823_P_NODE_14897_length_249_cov_0.886364_g14780_i0	PRJNA1086823	14897	249	0.886364	2.20704636	Nannocystis punicea	2995304	Bacteria	Bacteria	86.1	2.22e-12	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g14780	i0	83	1.28915662650602	100	11	39	4	90	186	5635027	5634931	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	321	86.1	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
20594812	20594812	PRJNA1086823_P_NODE_1637_length_583_cov_2.315686_g1522_i0	PRJNA1086823	1637	583	2.315686	13.50044938	Labilithrix luteola	1391654	Bacteria	Bacteria	957	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1522	i0	96.392	157.68782161235	582	20	99	1	3	583	3942365	3942946	Labilithrix luteola strain DSM 27648, complete genome	blastn	91932	957	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
24419798	24419798	PRJNA1086823_P_NODE_8920_length_283_cov_1.485714_g8803_i0	PRJNA1086823	8920	283	1.485714	4.20457062	Archangium violaceum	83451	Bacteria	Bacteria	104	7.11e-18	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g8803	i0	87.097	10.4770318021201	93	10	33	2	142	233	3143950	3144041	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	2965	104	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum

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