metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJEB12237" and tax

6 rows where analysis = "blastn", bioproject = "PRJEB12237" and tax_phylum = "Acidobacteriota"

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
6398820	6398820	PRJEB12237_P_NODE_5686_length_248_cov_2.488263_g5490_i0	PRJEB12237	5686	248	2.488263	6.17089224	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	281	2.63e-71	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g5490	i0	87.097	81.6008064516129	248	32	100	0	1	248	318951	318704	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	20237	281	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
8947697	8947697	PRJEB12237_P_NODE_8408_length_189_cov_1.051948_g8212_i0	PRJEB12237	8408	189	1.051948	1.98818172	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	283	5.28e-72	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g8212	i0	93.651	102.666666666667	189	12	100	0	1	189	671	859	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	19404	283	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11498720	11498720	PRJEB12237_P_NODE_6150_length_235_cov_2.310000_g5954_i0	PRJEB12237	6150	235	2.31	5.4285	Paludibaculum fermentans	1473598	Bacteria	Bacteria	324	4.04e-84	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g5954	i0	91.525	58.8	236	19	100	1	1	235	4786173	4785938	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	13818	324	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
11498731	11498731	PRJEB12237_P_NODE_7330_length_207_cov_2.029070_g7134_i0	PRJEB12237	7330	207	2.02907	4.2001749	Paludibaculum fermentans	1473598	Bacteria	Bacteria	265	2.1399999999999997e-66	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g7134	i0	90.64	240.811594202899	203	13	98	5	1	202	4785874	4785677	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	49848	265	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
19146150	19146150	PRJEB12237_P_NODE_10496_length_163_cov_3.078125_g10300_i0	PRJEB12237	10496	163	3.078125	5.01734375	Paludibaculum fermentans	1473598	Bacteria	Bacteria	257	2.68e-64	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g10300	i0	95.092	108.41717791411	163	8	100	0	1	163	4784767	4784929	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	17672	257	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
20421366	20421366	PRJEB12237_P_NODE_8517_length_187_cov_2.078947_g8321_i0	PRJEB12237	8517	187	2.078947	3.88763089	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	202	1.4999999999999996e-47	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g8321	i0	86.316	12.7593582887701	190	21	100	4	1	187	3298172	3298359	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	2386	202	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota 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);;