metadata: contig_metadata: 5 rows where bioproject = "PRJEB14664", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJEB14664", tax_kingdom = "Bacillati" and tax_phylum = "Cyanobacteriota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
21228	21228	PRJEB14664_P_NODE_18061_length_161_cov_1.269841_g17931_i0	PRJEB14664	18061	161	1.269841	2.04444401	Prochlorothrix hollandica	1223	Bacteria	Bacteria	287	3.37e-73	NTclustered	gi\|146740638\|emb\|AM709625.1\|	317619	g17931	i0	98.758	137.987577639752	161	2	100	0	1	161	3133	2973	Prochlorothrix hollandica SAG 10.89 partial ribosomal RNA operon, strain SAG 10.89	blastn	22216	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Prochlorotrichales	Prochlorotrichaceae	Prochlorothrix	Prochlorothrix hollandica
20421966	20421966	PRJEB14664_P_NODE_6217_length_331_cov_2.141892_g6087_i0	PRJEB14664	6217	331	2.141892	7.08966252	Scytonema sp. PMC 1069.18	2684455	Bacteria	Bacteria	73.2	1.25e-12	NR	MEC4813485.1	2684455	g6087	i0	49.4	0.770392749244713	85	33	77	2	66	320	35	109	MEC4813485.1 choice-of-anchor A family protein [Scytonema sp. PMC 1069.18]	diamond	255	73.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PMC 1069.18
28738470	28738470	PRJEB14664_P_NODE_6447_length_324_cov_1.882353_g6317_i0	PRJEB14664	6447	324	1.882353	6.09882372	Dolichospermum sp.	2720786	Bacteria	Bacteria	123	3.0899999999999997e-32	NR	MFN7661193.1	2720786	g6317	i0	65.3	0.87962962962963	95	32	87	1	1	282	38	132	MFN7661193.1 hypothetical protein [Dolichospermum sp.]	diamond	285	123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp.
30222550	30222550	PRJEB14664_P_NODE_14472_length_188_cov_1.209150_g14342_i0	PRJEB14664	14472	188	1.20915	2.273202	Arthrospira platensis Ap-s	118562	Bacteria	Bacteria	122	1.2699999999999998e-32	NR	ABC46995.1	357682	g14342	i0	98.4	0.98936170212766	62	1	98.9	0	187	2	134	195	ABC46995.1 chemotaxis signal transduction protein, partial [Arthrospira platensis Ap-s]	diamond	186	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
32056102	32056102	PRJEB14664_P_NODE_10858_length_228_cov_1.554404_g10728_i0	PRJEB14664	10858	228	1.554404	3.54404112	Microcystis aeruginosa PCC 78	1126	Bacteria	Bacteria	53.5	2.63e-6	NR	ARI79959.1	1903187	g10728	i0	43.1	0.947368421052632	72	35	90.8	2	208	2	27	95	ARI79959.1 hypothetical protein BH695_0678 [Microcystis aeruginosa PCC 7806SL]	diamond	216	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa

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