metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1034995" and tax_clade = "Cyanobacteriota/Melainabacteria group"

10 rows where analysis = "diamond", bioproject = "PRJNA1034995" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
5271329	5271329	PRJNA1034995_S_NODE_33665_length_242_cov_7.035176_g33509_i0	PRJNA1034995	33665	242	7.035176	17.02512592	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	120	2.1099999999999998e-31	NR	WP_009631240.1	927677	g33509	i0	90.8	0.805785123966942	65	6	80.6	0	226	32	223	287	WP_009631240.1 ABC transporter permease [Synechocystis sp. PCC 7509]	diamond	195	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
19294312	19294312	PRJNA1034995_S_NODE_40156_length_204_cov_3.428571_g40000_i0	PRJNA1034995	40156	204	3.428571	6.99428484	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	107	2.02e-28	NR	WP_106369300.1	2107693	g40000	i0	81.8	0.970588235294118	66	12	97.1	0	6	203	23	88	WP_106369300.1 WGxxGxxG family protein [Chlorogloea sp. CCALA 695]	diamond	198	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
27540803	27540803	PRJNA1034995_S_NODE_26464_length_302_cov_10.250965_g26308_i0	PRJNA1034995	26464	302	10.250965	30.9579143	Aliterella atlantica	1827278	Bacteria	Bacteria	131	4.53e-33	NR	WP_052672568.1	1827278	g26308	i0	91.4	0.695364238410596	70	6	69.5	0	212	3	7	76	WP_052672568.1 CHASE2 domain-containing protein [Aliterella atlantica]	diamond	210	131	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
27785546	27785546	PRJNA1034995_S_NODE_24744_length_320_cov_7.552347_g24588_i0	PRJNA1034995	24744	320	7.552347	24.1675104	Bacillati	1783272	Bacteria	Bacteria	163	1.8e-46	NR	HEY9874653.1	2364082	g24588	i0	78.7	10.70625	94	20	88.1	0	14	295	1	94	HEY9874653.1 transposase [Candidatus Obscuribacterales bacterium]	diamond	3426	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27825021	27825021	PRJNA1034995_S_NODE_26884_length_298_cov_10.564706_g26728_i0	PRJNA1034995	26884	298	10.564706	31.48282388	Cyanophyceae cyanobacterium	3088179	Bacteria	Bacteria	90.9	8.76e-19	NR	HEY9597779.1	3088179	g26728	i0	44.8	0.966442953020134	96	53	96.6	0	292	5	315	410	HEY9597779.1 hypothetical protein [Cyanophyceae cyanobacterium]	diamond	288	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae				Cyanophyceae cyanobacterium
28898232	28898232	PRJNA1034995_S_NODE_12108_length_680_cov_21.492936_g12014_i0	PRJNA1034995	12108	680	21.492936	146.1519648	Chroococcus sp. CMT-3BRIN-NPC107	2499659	Bacteria	Bacteria	333	3.1299999999999995e-112	NR	MBW4665159.1	2499659	g12014	i0	97.2	0.776470588235294	176	5	77.6	0	530	3	1	176	MBW4665159.1 STAS domain-containing protein [Chroococcus sp. CMT-3BRIN-NPC107]	diamond	528	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. CMT-3BRIN-NPC107
29813920	29813920	PRJNA1034995_S_NODE_38311_length_214_cov_3.029240_g38155_i0	PRJNA1034995	38311	214	3.02924	6.4825736	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	41.2	0.0158	NR	MEN9871684.1	2847862	g38155	i0	39.1	0.644859813084112	46	26	64.5	1	191	54	1	44	MEN9871684.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	138	41.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30943584	30943584	PRJNA1034995_S_NODE_13614_length_546_cov_18.017893_g13472_i0	PRJNA1034995	13614	546	18.017893	98.37769578	Cyanophyceae	3028117	Bacteria	Bacteria	218	4.06e-66	NR	WP_051482663.1	927677	g13472	i0	86.1	2.00549450549451	122	17	67	0	2	367	287	408	WP_051482663.1 hypothetical protein [Synechocystis sp. PCC 7509]	diamond	1095	218	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
31710271	31710271	PRJNA1034995_S_NODE_46877_length_175_cov_2.378788_g46721_i0	PRJNA1034995	46877	175	2.378788	4.162879	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	76.6	1.99e-15	NR	WP_009632783.1	927677	g46721	i0	97.4	1.33714285714286	39	1	66.9	0	117	1	1	39	WP_009632783.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Synechocystis sp. PCC 7509]	diamond	234	76.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
32177009	32177009	PRJNA1034995_S_NODE_37738_length_217_cov_5.022989_g37582_i0	PRJNA1034995	37738	217	5.022989	10.89988613	Cyanophyceae	3028117	Bacteria	Bacteria	79.3	6.42e-18	NR	WP_072044930.1	1827278	g37582	i0	89.7	1.07834101382488	39	4	53.9	0	38	154	1	39	WP_072044930.1 photosystem II reaction center protein J [Aliterella atlantica]	diamond	234	80.1	0.990012484394507	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica

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