metadata: contig_metadata: 7 rows where bioproject = "PRJNA1111082" and tax_clade = "Cyanobacteriota/Melainabacteria group"

7 rows where bioproject = "PRJNA1111082" 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
18067072	18067072	PRJNA1111082_P_NODE_6955_length_305_cov_2.883621_g6910_i0	PRJNA1111082	6955	305	2.883621	8.79504405	unclassified Microcoleus	2642155	Bacteria	Bacteria	141	2.0599999999999998e-38	NR	WP_333195622.1	2642155	g6910	i0	97.2	0.708196721311475	72	2	70.8	0	300	85	45	116	WP_333195622.1 MULTISPECIES: hemerythrin domain-containing protein [unclassified Microcoleus]	diamond	216	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus
26783121	26783121	PRJNA1111082_P_NODE_10601_length_252_cov_0.871508_g10556_i0	PRJNA1111082	10601	252	0.871508	2.19620016	Microcystis sp. M	1127	Bacteria	Bacteria	99	7.07e-22	NR	WP_287873656.1	2771111	g10556	i0	63.1	0.773809523809524	65	24	77.4	0	1	195	188	252	WP_287873656.1 hypothetical protein [Microcystis sp. M034S1]	diamond	195	99	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M034S1
28417220	28417220	PRJNA1111082_P_NODE_2806_length_455_cov_1.219895_g2761_i0	PRJNA1111082	2806	455	1.219895	5.55052225	Cyanophyceae	3028117	Bacteria	Bacteria	133	6.82e-33	NR	WP_002765650.1	1126	g2761	i0	50	27.1318681318681	154	69	99.6	3	1	453	659	807	WP_002765650.1 phosphatase PAP2 family protein [Microcystis aeruginosa]	diamond	12345	134	0.992537313432836	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
28457519	28457519	PRJNA1111082_P_NODE_9446_length_264_cov_3.219895_g9401_i0	PRJNA1111082	9446	264	3.219895	8.5005228	Candidatus Gastranaerophilaceae bacterium	3022870	Bacteria	Bacteria	43.5	0.0252	NR	MFA6988711.1	3022870	g9401	i0	42.2	0.511363636363636	45	26	51.1	0	88	222	334	378	MFA6988711.1 glycosyltransferase [Candidatus Gastranaerophilaceae bacterium]	diamond	135	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales	Candidatus Gastranaerophilaceae		Candidatus Gastranaerophilaceae bacterium
30384144	30384144	PRJNA1111082_P_NODE_12253_length_244_cov_0.912281_g12208_i0	PRJNA1111082	12253	244	0.912281	2.22596564	Crocosphaera sp.	2729996	Bacteria	Bacteria	42.4	0.0175	NR	WP_300511446.1	2729996	g12208	i0	30.6	0.885245901639344	72	35	84.8	2	209	3	29	88	WP_300511446.1 IS200/IS605 family transposase [Crocosphaera sp.]	diamond	216	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera sp.
32154238	32154238	PRJNA1111082_P_NODE_11578_length_247_cov_0.896552_g11533_i0	PRJNA1111082	11578	247	0.896552	2.21448344	Microcystis sp. M31BS1	2771186	Bacteria	Bacteria	67	6.8e-11	NR	WP_287716660.1	2771186	g11533	i0	46.8	0.959514170040486	79	24	93.5	2	237	7	57	119	WP_287716660.1 ATP-grasp domain-containing protein [Microcystis sp. M31BS1]	diamond	237	67	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M31BS1
32588505	32588505	PRJNA1111082_P_NODE_12439_length_243_cov_0.917647_g12394_i0	PRJNA1111082	12439	243	0.917647	2.22988221	Cyanophyceae	3028117	Bacteria	Bacteria	53.9	4.31e-6	NR	MFO0039574.1	2588875	g12394	i0	47.8	5.20987654320988	69	31	85.2	1	242	36	328	391	MFO0039574.1 S8 family serine peptidase [Synechococcaceae cyanobacterium]	diamond	1266	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae cyanobacterium

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