metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA206070" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA206070" 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
2331044	2331044	PRJNA206070_S_NODE_4342_length_883_cov_20.773050_g2660_i0	PRJNA206070	4342	883	20.77305	183.4260315	Pendulispora	3375062	Bacteria	Bacteria	1243	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g2660	i0	92.09	166.309173272933	885	67	100	3	1	883	7288953	7289836	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	146851	1243	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
11259041	11259041	PRJNA206070_S_NODE_9329_length_406_cov_13.989160_g7456_i0	PRJNA206070	9329	406	13.98916	56.7959896	Pendulispora	3375062	Bacteria	Bacteria	448	4.249999999999998e-121	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g7456	i0	86.732	140.992610837438	407	48	99	6	3	406	7288681	7288278	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	57243	451	0.993348115299335	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
11844663	11844663	PRJNA206070_S_NODE_12630_length_309_cov_30.591912_g10754_i0	PRJNA206070	12630	309	30.591912	94.52900808	Chondromyces crocatus	52	Bacteria	Bacteria	488	1.86e-133	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g10754	i0	95.146	159.838187702265	309	15	100	0	1	309	1748	2056	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	49390	488	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
13808958	13808958	PRJNA206070_S_NODE_12831_length_305_cov_32.712687_g10955_i0	PRJNA206070	12831	305	32.712687	99.77369535	Myxococcia	32015	Bacteria	Bacteria	427	4.0399999999999997e-115	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10955	i0	91.857	139.822950819672	307	23	100	2	1	305	3943167	3942861	Labilithrix luteola strain DSM 27648, complete genome	blastn	42646	427	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15669462	15669462	PRJNA206070_S_NODE_7173_length_514_cov_21.419287_g5309_i0	PRJNA206070	7173	514	21.419287	110.09513518	Polyangium aurulentum	2567896	Bacteria	Bacteria	795	0	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g5309	i0	94.912	149.239299610895	511	21	99	5	7	514	443675	444183	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	76709	795	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
15669479	15669479	PRJNA206070_S_NODE_7813_length_475_cov_19.641553_g5944_i0	PRJNA206070	7813	475	19.641553	93.29737675	Pendulispora albinea	2741071	Bacteria	Bacteria	739	0	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g5944	i0	94.737	162.585263157895	475	25	100	0	1	475	3590255	3589781	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	77228	739	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
15669532	15669532	PRJNA206070_S_NODE_9393_length_403_cov_18.005464_g7520_i0	PRJNA206070	9393	403	18.005464	72.56201992	Polyangium aurulentum	2567896	Bacteria	Bacteria	588	2.3799999999999993e-163	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g7520	i0	92.91	131.652605459057	409	21	100	7	1	403	443402	442996	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	53056	588	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
16943990	16943990	PRJNA206070_S_NODE_9394_length_403_cov_10.327869_g7521_i0	PRJNA206070	9394	403	10.327869	41.62131207	Pendulispora albinea	2741071	Bacteria	Bacteria	483	1.16e-131	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g7521	i0	88.586	130.230769230769	403	38	99	6	3	401	3589077	3589475	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	52483	483	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
17633166	17633166	PRJNA206070_S_NODE_11474_length_337_cov_9.170000_g9598_i0	PRJNA206070	11474	337	9.17	30.9029	Sorangium	39643	Bacteria	Bacteria	438	2.0899999999999998e-118	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g9598	i0	90.476	113.887240356083	336	26	99	6	4	335	3904905	3904572	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	38380	438	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
22043095	22043095	PRJNA206070_S_NODE_28798_length_158_cov_1.289256_g26922_i0	PRJNA206070	28798	158	1.289256	2.03702448	Archangium gephyra	48	Bacteria	Bacteria	126	7.59e-25	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g26922	i0	82.353	1.93670886075949	153	19	94	8	1	148	10974714	10974863	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	306	126	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
22732512	22732512	PRJNA206070_S_NODE_4558_length_827_cov_22.727848_g2660_i1	PRJNA206070	4558	827	22.727848	187.95930296	Pendulispora	3375062	Bacteria	Bacteria	1153	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g2660	i1	91.807	151.431680773882	830	64	100	4	1	827	7289781	7288953	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	125234	1153	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
24592299	24592299	PRJNA206070_S_NODE_10700_length_359_cov_31.543478_g8825_i0	PRJNA206070	10700	359	31.543478	113.24108602	Labilithrix luteola	1391654	Bacteria	Bacteria	466	1.0199999999999999e-126	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g8825	i0	91.228	211.824512534819	342	30	95	0	1	342	3944397	3944738	Labilithrix luteola strain DSM 27648, complete genome	blastn	76045	466	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);;