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

7 rows where analysis = "blastn", bioproject = "PRJNA315399" 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
4212129	4212129	PRJNA315399_S_NODE_192684_length_151_cov_2.850877_g192483_i0	PRJNA315399	192684	151	2.850877	4.30482427	Myxococcus fulvus	33	Bacteria	Bacteria	87.9	3.38e-13	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g192483	i0	96.226	1.05298013245033	53	2	35	0	3	55	5107183	5107131	Myxococcus fulvus 124B02, complete genome	blastn	159	87.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
8036624	8036624	PRJNA315399_P_NODE_467527_length_154_cov_4.658120_g467079_i0	PRJNA315399	467527	154	4.65812	7.1735048	Sorangium cellulosum	56	Bacteria	Bacteria	100	4.45e-17	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g467079	i0	88.889	0.525974025974026	81	9	53	0	46	126	5752607	5752527	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	81	100	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9994309	9994309	PRJNA315399_P_NODE_458868_length_155_cov_4.237288_g458420_i0	PRJNA315399	458868	155	4.237288	6.5677964	Corallococcus	83461	Bacteria	Bacteria	135	1.23e-27	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g458420	i0	98.684	38.9354838709677	76	1	49	0	5	80	2485426	2485351	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	6035	135	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
13139349	13139349	PRJNA315399_S_NODE_73291_length_194_cov_1.464968_g73090_i0	PRJNA315399	73291	194	1.464968	2.84203792	Myxococcus stipitatus	83455	Bacteria	Bacteria	244	2.57e-60	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g73090	i0	89.637	88.360824742268	193	18	99	2	3	194	5319160	5319351	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	17142	244	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
15685769	15685769	PRJNA315399_P_NODE_414793_length_160_cov_3.138211_g414345_i0	PRJNA315399	414793	160	3.138211	5.0211376	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	58.4	2.85e-4	NTclustered	gi\|2108133206\|gb\|CP070843.1\|	2026735	g414345	i0	100	0.19375	31	0	19	0	107	137	2310784	2310814	MAG: Deltaproteobacteria bacterium isolate bin435 chromosome	blastn	31	58.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
16962464	16962464	PRJNA315399_S_NODE_30214_length_247_cov_11.176190_g30013_i0	PRJNA315399	30214	247	11.17619	27.6051893	Labilithrix luteola	1391654	Bacteria	Bacteria	239	1.6e-58	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g30013	i0	85.776	443.931174089069	232	25	93	6	16	245	3941757	3941982	Labilithrix luteola strain DSM 27648, complete genome	blastn	109651	239	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
19507686	19507686	PRJNA315399_P_NODE_186956_length_185_cov_25.081081_g186508_i0	PRJNA315399	186956	185	25.081081	46.39999985	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2108117163\|gb\|CP070734.1\|	2026735	g186508	i0	100	0.162162162162162	30	0	16	0	40	69	2436894	2436923	MAG: Deltaproteobacteria bacterium isolate bin407 chromosome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium

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