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

9 rows where analysis = "diamond", bioproject = "PRJNA414036" 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
24645184	24645184	PRJNA414036_P_NODE_46300_length_231_cov_2.959184_g44561_i0	PRJNA414036	46300	231	2.959184	6.83571504	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	75.9	6.74e-14	NR	MBW4637958.1	2839657	g44561	i0	56.9	47.7662337662338	72	14	93.5	1	221	6	235	289	MBW4637958.1 TIGR03960 family B12-binding radical SAM protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	11034	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
27012214	27012214	PRJNA414036_P_NODE_47322_length_231_cov_2.734694_g45583_i0	PRJNA414036	47322	231	2.734694	6.31714314	Oscillatoriales cyanobacterium	1151	Bacteria	Bacteria	64.3	7.31e-10	NR	TAF53804.1	1151	g45583	i0	52	3.49350649350649	75	33	93.5	2	8	223	147	221	TAF53804.1 MAG: ferrochelatase [Oscillatoriales cyanobacterium]	diamond	807	64.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium
27092195	27092195	PRJNA414036_P_NODE_50622_length_231_cov_2.107143_g48883_i0	PRJNA414036	50622	231	2.107143	4.86750033	Cyanophyceae	3028117	Bacteria	Bacteria	43.1	0.0207	NR	WP_190814844.1	2692783	g48883	i0	77.3	0.571428571428571	22	5	28.6	0	9	74	64	85	WP_190814844.1 winged helix-turn-helix domain-containing protein [Coleofasciculus sp. FACHB-1120]	diamond	132	43.5	0.990804597701149	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. FACHB-1120
27250223	27250223	PRJNA414036_P_NODE_44243_length_231_cov_3.520408_g42504_i0	PRJNA414036	44243	231	3.520408	8.13214248	Cyanophyceae	3028117	Bacteria	Bacteria	46.2	0.00143	NR	WP_015152683.1	54298	g42504	i0	95.5	7.71428571428571	22	1	28.6	0	158	223	177	198	WP_015152683.1 MULTISPECIES: response regulator transcription factor [Chroococcidiopsis]	diamond	1782	46.6	0.991416309012876	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis
28465279	28465279	PRJNA414036_P_NODE_85046_length_155_cov_3.191667_g83307_i0	PRJNA414036	85046	155	3.191667	4.94708385	Leptolyngbya sp. PL-A3	2933911	Bacteria	Bacteria	53.5	2.82e-7	NR	MCE7967796.1	2933911	g83307	i0	66.7	0.812903225806452	42	14	81.3	0	152	27	22	63	MCE7967796.1 hypothetical protein [Leptolyngbya sp. PL-A3]	diamond	126	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PL-A3
29050242	29050242	PRJNA414036_P_NODE_41768_length_231_cov_4.704082_g40029_i0	PRJNA414036	41768	231	4.704082	10.86642942	Cyanophyceae	3028117	Bacteria	Bacteria	43.9	0.00935	NR	WP_009634325.1	927677	g40029	i0	86.4	0.571428571428571	22	3	28.6	0	73	8	143	164	WP_009634325.1 DUF3038 domain-containing protein [Synechocystis sp. PCC 7509]	diamond	132	44.3	0.99097065462754	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
29949243	29949243	PRJNA414036_P_NODE_61271_length_211_cov_4.880682_g59532_i0	PRJNA414036	61271	211	4.880682	10.29823902	Microcystis aeruginosa FACHB-9	1126	Bacteria	Bacteria	45.1	8.18e-4	NR	ELS47047.1	267865	g59532	i0	54.8	1.27962085308057	42	13	59.7	1	202	77	23	58	ELS47047.1 hypothetical protein C789_3192 [Microcystis aeruginosa FACHB-905 = DIANCHI905]	diamond	270	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
30265428	30265428	PRJNA414036_P_NODE_50912_length_231_cov_2.051020_g49173_i0	PRJNA414036	50912	231	2.05102	4.7378562	Aliterella atlantica	1827278	Bacteria	Bacteria	67.4	5.47e-11	NR	WP_045055828.1	1827278	g49173	i0	52	3.8961038961039	75	32	92.2	1	10	222	194	268	WP_045055828.1 hemerythrin domain-containing protein [Aliterella atlantica]	diamond	900	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
30486364	30486364	PRJNA414036_P_NODE_71093_length_180_cov_19.496552_g69354_i0	PRJNA414036	71093	180	19.496552	35.0937936	Nostoc linckia z15	1628750	Bacteria	Bacteria	99.4	1.85e-25	NR	PHK25600.1	1628750	g69354	i0	75	1	60	15	100	0	1	180	8	67	PHK25600.1 hypothetical protein VF12_36795 [Nostoc linckia z15]	diamond	180	99.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc linckia

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