metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA799842" 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
6323266	6323266	PRJNA799842_P_NODE_38365_length_462_cov_1.562982_g36794_i0	PRJNA799842	38365	462	1.562982	7.22097684	Stigmatella	40	Bacteria	Bacteria	544	6.07e-150	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g36794	i0	88.889	247.393939393939	450	39	97	10	1	446	712	270	S.aurantiaca 23S rRNA gene	blastn	114296	544	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
8445946	8445946	PRJNA799842_P_NODE_110507_length_278_cov_1.502439_g108934_i0	PRJNA799842	110507	278	1.502439	4.17678042	Chondromyces crocatus	52	Bacteria	Bacteria	492	1.27e-134	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g108934	i0	98.561	155.870503597122	278	4	100	0	1	278	2566	2289	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	43332	492	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
8872929	8872929	PRJNA799842_P_NODE_91467_length_303_cov_1.339130_g89894_i0	PRJNA799842	91467	303	1.33913	4.0575639	Anaeromyxobacter	161492	Bacteria	Bacteria	198	3.4299999999999998e-46	NTclustered	gi\|470484038\|ref\|NR_076626.1\|	161493	g89894	i0	83.256	319.986798679868	215	36	71	0	61	275	1254	1468	Anaeromyxobacter dehalogenans strain 2CP-1 23S ribosomal RNA gene, complete sequence	blastn	96956	198	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
8872952	8872952	PRJNA799842_P_NODE_94167_length_299_cov_1.362832_g92594_i0	PRJNA799842	94167	299	1.362832	4.07486768	Sorangium	39643	Bacteria	Bacteria	322	1.92e-83	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g92594	i0	90.323	178.33779264214	248	20	82	4	46	291	3690009	3689764	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	53323	322	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12273267	12273267	PRJNA799842_P_NODE_165070_length_245_cov_1.500000_g163497_i0	PRJNA799842	165070	245	1.5	3.675	Sorangium cellulosum	56	Bacteria	Bacteria	217	7.41e-52	NTclustered	gi\|28395343\|gb\|AY190668.1\|	56	g163497	i0	83.333	69.7918367346939	240	34	96	6	1	236	544	781	Polyangium cellulosum strain So9733-1 clone 3 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	17099	217	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12273462	12273462	PRJNA799842_P_NODE_174490_length_244_cov_0.900585_g172917_i0	PRJNA799842	174490	244	0.900585	2.1974274	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	263	9.34e-66	NTclustered	gi\|2107977474\|gb\|CP070783.1\|	2026735	g172917	i0	86.122	2.02049180327869	245	32	100	2	1	244	594899	595142	MAG: Deltaproteobacteria bacterium isolate bin162 chromosome	blastn	493	263	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
19070479	19070479	PRJNA799842_P_NODE_144615_length_249_cov_1.312500_g143042_i0	PRJNA799842	144615	249	1.3125	3.268125	Myxococcaceae	31	Bacteria	Bacteria	372	1.52e-98	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g143042	i0	93.574	233.923694779116	249	16	100	0	1	249	2161138	2160890	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	58247	372	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
20346238	20346238	PRJNA799842_P_NODE_98756_length_292_cov_1.963470_g97183_i0	PRJNA799842	98756	292	1.96347	5.7333324	Stigmatella	40	Bacteria	Bacteria	438	1.7799999999999999e-118	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g97183	i0	93.814	248.869863013699	291	18	99	0	2	292	1115	825	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	72670	438	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca

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