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

7 rows where analysis = "blastn", bioproject = "PRJNA690124" 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
2453836	2453836	PRJNA690124_P_NODE_39942_length_263_cov_1.300000_g39576_i0	PRJNA690124	39942	263	1.3	3.419	Stigmatella	40	Bacteria	Bacteria	425	1.2299999999999999e-114	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g39576	i0	95.817	261.965779467681	263	11	100	0	1	263	936	1198	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	68897	425	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
9598080	9598080	PRJNA690124_P_NODE_46668_length_250_cov_0.881356_g46302_i0	PRJNA690124	46668	250	0.881356	2.20339	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	198	2.75e-46	NTclustered	gi\|2108117163\|gb\|CP070734.1\|	2026735	g46302	i0	84.236	2.344	203	32	81	0	15	217	1373473	1373675	MAG: Deltaproteobacteria bacterium isolate bin407 chromosome	blastn	586	198	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
10873281	10873281	PRJNA690124_P_NODE_33169_length_288_cov_1.353488_g32803_i0	PRJNA690124	33169	288	1.353488	3.89804544	Pendulispora brunnea	2905690	Bacteria	Bacteria	427	3.7899999999999997e-115	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g32803	i0	93.403	137.357638888889	288	19	100	0	1	288	7408588	7408875	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	39559	427	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
10873613	10873613	PRJNA690124_P_NODE_48469_length_248_cov_1.371429_g48103_i0	PRJNA690124	48469	248	1.371429	3.40114392	Chondromyces crocatus	52	Bacteria	Bacteria	259	1.23e-64	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g48103	i0	85.6	255.657258064516	250	33	100	3	1	248	2882	3130	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	63403	259	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
19030435	19030435	PRJNA690124_P_NODE_54235_length_243_cov_1.576471_g53869_i0	PRJNA690124	54235	243	1.576471	3.83082453	Archangium	47	Bacteria	Bacteria	67.6	7.82e-7	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g53869	i0	93.333	1.64197530864198	45	3	19	0	23	67	1462311	1462267	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	399	67.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
21071728	21071728	PRJNA690124_P_NODE_3417_length_839_cov_3.924282_g3120_i0	PRJNA690124	3417	839	3.924282	32.92472598	Chondromyces crocatus	52	Bacteria	Bacteria	952	0	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g3120	i0	87.146	111.027413587604	848	97	99	12	1	838	1446	2291	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	93152	952	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
23622555	23622555	PRJNA690124_P_NODE_5279_length_691_cov_2.048544_g4932_i0	PRJNA690124	5279	691	2.048544	14.15543904	Minicystis rosea	888845	Bacteria	Bacteria	669	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g4932	i0	84.97	218.534008683068	672	87	96	12	1	663	769653	768987	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	151007	669	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea

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