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

7 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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
2292110	2292110	PRJNA1078753_P_NODE_10582_length_348_cov_2.410909_g10386_i0	PRJNA1078753	10582	348	2.410909	8.38996332	Polyangiaceae	49	Bacteria	Bacteria	313	1.37e-80	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g10386	i0	88.213	226.816091954023	263	30	75	1	83	344	4849685	4849947	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	78932	313	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4019025	4019025	PRJNA1078753_P_NODE_17724_length_288_cov_1.325581_g17528_i0	PRJNA1078753	17724	288	1.325581	3.81767328	Sorangium cellulosum	56	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g17528	i0	79.268	0.284722222222222	82	15	28	2	60	140	4763165	4763085	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	82	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
11220307	11220307	PRJNA1078753_P_NODE_1809_length_723_cov_1.166154_g1633_i0	PRJNA1078753	1809	723	1.166154	8.43129342	Sorangium	39643	Bacteria	Bacteria	749	0	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g1633	i0	85.577	118.409405255878	728	89	100	13	1	723	1030	1746	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	85610	749	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
11671301	11671301	PRJNA1078753_P_NODE_35270_length_246_cov_0.890173_g35074_i0	PRJNA1078753	35270	246	0.890173	2.18982558	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	156	1.65e-33	NTclustered	gi\|2108117163\|gb\|CP070734.1\|	2026735	g35074	i0	82.778	20.3943089430894	180	25	72	5	23	199	3669963	3669787	MAG: Deltaproteobacteria bacterium isolate bin407 chromosome	blastn	5017	156	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
14221195	14221195	PRJNA1078753_P_NODE_17212_length_290_cov_1.497696_g17016_i0	PRJNA1078753	17212	290	1.497696	4.3433184	Labilithrix luteola	1391654	Bacteria	Bacteria	494	3.71e-135	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g17016	i0	97.569	271.851724137931	288	7	99	0	1	288	3944369	3944656	Labilithrix luteola strain DSM 27648, complete genome	blastn	78837	494	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15044554	15044554	PRJNA1078753_P_NODE_23552_length_264_cov_1.523560_g23356_i0	PRJNA1078753	23552	264	1.52356	4.0221984	Haliangium	162027	Bacteria	Bacteria	409	1.2399999999999998e-109	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g23356	i0	94.697	252.780303030303	264	13	100	1	1	264	1403	1141	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	66734	409	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
23144683	23144683	PRJNA1078753_P_NODE_14419_length_311_cov_1.302521_g14223_i0	PRJNA1078753	14419	311	1.302521	4.05084031	Labilithrix luteola	1391654	Bacteria	Bacteria	422	1.92e-113	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g14223	i0	91.262	259.106109324759	309	27	99	0	3	311	3941930	3942238	Labilithrix luteola strain DSM 27648, complete genome	blastn	80582	422	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);;