metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA781196" 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
4587593	4587593	PRJNA781196_P_NODE_40904_length_280_cov_1.483092_g40527_i0	PRJNA781196	40904	280	1.483092	4.1526576	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	315	2.98e-81	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g40527	i0	87.41	219.760714285714	278	29	98	6	1	274	8615639	8615914	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	61533	315	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
13513654	13513654	PRJNA781196_P_NODE_9351_length_521_cov_0.962054_g8976_i0	PRJNA781196	9351	521	0.962054	5.01230134	Myxococcus stipitatus	83455	Bacteria	Bacteria	407	9.46e-109	NTclustered	gi\|2700865302\|gb\|CP147913.1\|	83455	g8976	i0	81.8	89.2130518234165	489	85	93	4	16	502	10163865	10164351	Myxococcus stipitatus strain KYC2006 chromosome, complete genome	blastn	46480	407	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
14787672	14787672	PRJNA781196_P_NODE_22052_length_363_cov_1.344828_g21675_i0	PRJNA781196	22052	363	1.344828	4.88172564	Archangium violaceum	83451	Bacteria	Bacteria	270	8.73e-68	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g21675	i0	80.501	103.396694214876	359	64	98	4	4	359	4318312	4317957	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	37533	270	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
15239793	15239793	PRJNA781196_P_NODE_56832_length_249_cov_0.886364_g56455_i0	PRJNA781196	56832	249	0.886364	2.20704636	Polyangiales	3031712	Bacteria	Bacteria	353	5.52e-93	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g56455	i0	92.4	197.236947791165	250	16	100	3	1	249	3490069	3489822	Sorangium cellulosum 'So ce 56' complete genome	blastn	49112	353	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
23712295	23712295	PRJNA781196_P_NODE_49339_length_254_cov_1.436464_g48962_i0	PRJNA781196	49339	254	1.436464	3.64861856	Archangium violaceum	83451	Bacteria	Bacteria	368	2.02e-97	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g48962	i0	92.913	228.834645669291	254	17	99	1	1	253	587298	587045	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	58124	368	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);;