metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1195374" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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
5424387	5424387	PRJNA1195374_P_NODE_21965_length_484_cov_2.248175_g21621_i0	PRJNA1195374	21965	484	2.248175	10.881167	Phaselicystis flava	525924	Bacteria	Bacteria	52.8	0.047	NTclustered	gi\|1493633220\|gb\|MH908922.1\|	525924	g21621	i0	100	0.0578512396694215	28	0	6	0	188	215	76647	76620	Phaselicystis flava strain MSr9315 t3pks biosynthetic gene cluster, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Phaselicystidaceae	Phaselicystis	Phaselicystis flava
13074795	13074795	PRJNA1195374_P_NODE_21291_length_492_cov_1.183771_g20948_i0	PRJNA1195374	21291	492	1.183771	5.82415332	Archangium violaceum	83451	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g20948	i0	100	0.0609756097560976	30	0	6	0	364	393	8219129	8219100	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
16898442	16898442	PRJNA1195374_P_NODE_28434_length_425_cov_1.664773_g28090_i0	PRJNA1195374	28434	425	1.664773	7.07528525	Stigmatella aurantiaca	41	Bacteria	Bacteria	272	2.89e-68	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g28090	i0	80.526	105.682352941176	380	52	87	20	7	375	6224142	6223774	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	44915	272	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
17620401	17620401	PRJNA1195374_P_NODE_2854_length_1140_cov_1.544517_g2650_i0	PRJNA1195374	2854	1140	1.544517	17.6074938	Sorangium	39643	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g2650	i0	100	0.0543859649122807	31	0	3	0	973	1003	481512	481482	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	62	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19447183	19447183	PRJNA1195374_P_NODE_19876_length_508_cov_4.806897_g19533_i0	PRJNA1195374	19876	508	4.806897	24.41903676	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	117	1.7400000000000003e-21	NTclustered	gi\|219952977\|gb\|CP001359.1\|	455488	g19533	i0	80	11.990157480315	170	24	33	6	9	176	2572578	2572417	Anaeromyxobacter dehalogenans 2CP-1 chromosome, complete genome	blastn	6091	117	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
19448139	19448139	PRJNA1195374_P_NODE_67676_length_259_cov_1.650538_g67332_i0	PRJNA1195374	67676	259	1.650538	4.27489342	Sorangium cellulosum	56	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g67332	i0	96.875	0.123552123552124	32	1	12	0	112	143	5780255	5780224	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21998093	21998093	PRJNA1195374_P_NODE_28878_length_422_cov_1.263610_g28534_i0	PRJNA1195374	28878	422	1.26361	5.3324342	Nannocystis punicea	2995304	Bacteria	Bacteria	333	1.3e-86	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g28534	i0	83.289	79.1303317535545	377	47	89	11	43	416	5377565	5377202	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	33393	333	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
23273249	23273249	PRJNA1195374_P_NODE_14259_length_597_cov_1.162214_g13921_i0	PRJNA1195374	14259	597	1.162214	6.93841758	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	370	1.44e-97	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g13921	i0	81.116	77.4154103852596	466	84	78	4	134	597	2077310	2077773	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	46217	370	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
23274538	23274538	PRJNA1195374_P_NODE_78239_length_246_cov_0.890173_g77895_i0	PRJNA1195374	78239	246	0.890173	2.18982558	Sorangium cellulosum	56	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g77895	i0	96.774	0.126016260162602	31	1	13	0	33	63	1906053	1906023	Sorangium cellulosum 'So ce 56' complete genome	blastn	31	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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