metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1198392" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1198392" 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
324461	324461	PRJNA1198392_P_NODE_12921_length_268_cov_1.256410_g12780_i0	PRJNA1198392	12921	268	1.25641	3.3671788	Minicystis rosea	888845	Bacteria	Bacteria	110	1.44e-19	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g12780	i0	91.25	2.67910447761194	80	7	30	0	186	265	3013390	3013311	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	718	110	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
6702501	6702501	PRJNA1198392_P_NODE_2246_length_495_cov_1.459716_g2105_i0	PRJNA1198392	2246	495	1.459716	7.2255942	Pendulispora albinea	2741071	Bacteria	Bacteria	636	1.0499999999999998e-177	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g2105	i0	90.141	137.442424242424	497	38	99	9	5	495	3589271	3588780	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	68034	636	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
7978141	7978141	PRJNA1198392_P_NODE_7227_length_305_cov_1.336207_g7086_i0	PRJNA1198392	7227	305	1.336207	4.07543135	Pendulispora rubella	2741070	Bacteria	Bacteria	433	8.69e-117	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g7086	i0	92.208	126.986885245902	308	20	100	4	1	305	7289706	7289400	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	38731	433	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
9252594	9252594	PRJNA1198392_P_NODE_21168_length_241_cov_0.916667_g21027_i0	PRJNA1198392	21168	241	0.916667	2.20916747	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	115	2.73e-21	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g21027	i0	93.506	8.90041493775934	77	5	32	0	2	78	1383634	1383558	Anaeromyxobacter paludicola DNA, complete genome	blastn	2145	115	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
9252773	9252773	PRJNA1198392_P_NODE_9448_length_285_cov_1.363208_g9307_i0	PRJNA1198392	9448	285	1.363208	3.8851428	Labilithrix luteola	1391654	Bacteria	Bacteria	366	8.28e-97	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9307	i0	90.614	0.971929824561404	277	24	97	2	2	277	5311062	5311337	Labilithrix luteola strain DSM 27648, complete genome	blastn	277	366	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11247084	11247084	PRJNA1198392_P_NODE_8429_length_289_cov_1.884259_g8288_i0	PRJNA1198392	8429	289	1.884259	5.44550851	Corallococcus	83461	Bacteria	Bacteria	252	2.46e-62	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g8288	i0	82.534	99.7923875432526	292	45	100	6	1	289	8994959	8994671	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	28840	252	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
20725833	20725833	PRJNA1198392_P_NODE_13397_length_265_cov_1.604167_g13256_i0	PRJNA1198392	13397	265	1.604167	4.25104255	Labilithrix luteola	1391654	Bacteria	Bacteria	150	8.349999999999998e-32	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g13256	i0	83.974	54.8264150943396	156	25	59	0	108	263	2661291	2661136	Labilithrix luteola strain DSM 27648, complete genome	blastn	14529	150	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);;