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

5 rows where analysis = "blastn", bioproject = "PRJNA784979" 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_order	tax_family	tax_genus	tax_species
2488860	2488860	PRJNA784979_S_NODE_12282_length_163_cov_0.894737_g12240_i0	PRJNA784979	12282	163	0.894737	1.45842131	Sorangium	39643	Bacteria	Bacteria	152	1.3e-32	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g12240	i0	91.071	3.31288343558282	112	10	69	0	42	153	1962734	1962623	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	540	152	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9693948	9693948	PRJNA784979_S_NODE_9608_length_170_cov_2.165289_g9566_i0	PRJNA784979	9608	170	2.165289	3.6809913	Minicystis rosea	888845	Bacteria	Bacteria	189	1.04e-43	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g9566	i0	95.763	122.088235294118	118	4	69	1	5	121	770755	770638	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	20755	189	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
17343778	17343778	PRJNA784979_S_NODE_2054_length_323_cov_5.164234_g2012_i0	PRJNA784979	2054	323	5.164234	16.68047582	Sorangium cellulosum	56	Bacteria	Bacteria	372	2.05e-98	NTclustered	gi\|28395339\|gb\|AY190664.1\|	56	g2012	i0	87.975	165.006191950464	316	37	98	1	1	315	602	917	Polyangium cellulosum strain So9881 clone 3 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	53297	372	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19065057	19065057	PRJNA784979_S_NODE_1795_length_353_cov_3.207237_g1753_i0	PRJNA784979	1795	353	3.207237	11.32154661	Sorangium	39643	Bacteria	Bacteria	494	4.61e-135	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g1753	i0	92.464	135.373937677054	345	26	98	0	9	353	3690186	3690530	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	47787	494	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21615582	21615582	PRJNA784979_S_NODE_2497_length_290_cov_5.195021_g2455_i0	PRJNA784979	2497	290	5.195021	15.0655609	Sorangium	39643	Bacteria	Bacteria	316	8.62e-82	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g2455	i0	87.279	125.251724137931	283	29	96	7	9	286	2994552	2994272	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	36323	318	0.993710691823899	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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