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

9 rows where analysis = "diamond", bioproject = "PRJEB80557" 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
24365057	24365057	PRJEB80557_S_NODE_9540_length_295_cov_1.459350_g9144_i0	PRJEB80557	9540	295	1.45935	4.3050825	Cyanophyceae	3028117	Bacteria	Bacteria	153	7.94e-41	NR	MBV8884510.1	2801880	g9144	i0	80.2	1.85084745762712	91	18	92.5	0	294	22	307	397	MBV8884510.1 type I DNA topoisomerase [Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35]	diamond	546	154	0.993506493506494	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae		Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35
26907681	26907681	PRJEB80557_S_NODE_22842_length_200_cov_1.033113_g22446_i0	PRJEB80557	22842	200	1.033113	2.066226	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	89	1.14e-19	NR	MBI2995961.1	2052166	g22446	i0	80	1.65	55	11	82.5	0	36	200	79	133	MBI2995961.1 30S ribosomal protein S3 [Candidatus Melainabacteria bacterium]	diamond	330	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27160397	27160397	PRJEB80557_S_NODE_35942_length_164_cov_1.147826_g35546_i0	PRJEB80557	35942	164	1.147826	1.88243464	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	68.9	1.44e-12	NR	MBW4637947.1	2839657	g35546	i0	73.1	3.58536585365854	52	13	93.3	1	161	9	1	52	MBW4637947.1 hypothetical protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	588	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
27192148	27192148	PRJEB80557_S_NODE_18762_length_219_cov_0.917647_g18366_i0	PRJEB80557	18762	219	0.917647	2.00964693	Tolypothrix sp. Co-bin9	2768887	Bacteria	Bacteria	145	3.0299999999999996e-42	NR	MBD0265704.1	2768887	g18366	i0	100	1	73	0	100	0	1	219	54	126	MBD0265704.1 2'-5' RNA ligase family protein [Tolypothrix sp. Co-bin9]	diamond	219	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. Co-bin9
27287104	27287104	PRJEB80557_S_NODE_37163_length_162_cov_0.920354_g36767_i0	PRJEB80557	37163	162	0.920354	1.49097348	Allocoleopsis sp.	3088169	Bacteria	Bacteria	57.8	3.14e-8	NR	HEY9662798.1	3088169	g36767	i0	55.1	1.85185185185185	49	22	90.7	0	158	12	41	89	HEY9662798.1 DUF1906 domain-containing protein [Allocoleopsis sp.]	diamond	300	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis sp.
27792523	27792523	PRJEB80557_S_NODE_18444_length_220_cov_2.444444_g18048_i0	PRJEB80557	18444	220	2.444444	5.3777768	Scytonema sp. PMC 1070.18	2684456	Bacteria	Bacteria	68.2	3.1e-11	NR	MEC4880965.1	2684456	g18048	i0	54.8	3.42272727272727	62	28	84.5	0	13	198	977	1038	MEC4880965.1 putative molybdenum carrier protein [Scytonema sp. PMC 1070.18]	diamond	753	68.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PMC 1070.18
29276246	29276246	PRJEB80557_S_NODE_4829_length_389_cov_2.900000_g4433_i0	PRJEB80557	4829	389	2.9	11.281	Nostoc sp. CHAB 5834	2780403	Bacteria	Bacteria	71.2	1.92e-11	NR	MCC5609589.1	2780403	g4433	i0	76.1	0.354755784061697	46	11	35.5	0	66	203	471	516	MCC5609589.1 hypothetical protein [Nostoc sp. CHAB 5834]	diamond	138	71.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5834
29710763	29710763	PRJEB80557_S_NODE_28930_length_180_cov_1.145038_g28534_i0	PRJEB80557	28930	180	1.145038	2.0610684	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	99.4	3.0099999999999995e-23	NR	WP_164929529.1	33072	g28534	i0	73.7	5.7	57	15	95	0	3	173	20	76	WP_164929529.1 TerC family protein [Gloeobacter violaceus]	diamond	1026	99.8	0.995991983967936	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Gloeobacteraceae	Gloeobacter	Gloeobacter violaceus
30666101	30666101	PRJEB80557_S_NODE_8513_length_310_cov_1.195402_g8117_i0	PRJEB80557	8513	310	1.195402	3.7057462	Scytonema sp. PCC 1	1204	Bacteria	Bacteria	167	1.05e-49	NR	WP_414588873.1	1680591	g8117	i0	90.2	0.987096774193548	102	10	98.7	0	3	308	1	102	WP_414588873.1 SDR family NAD(P)-dependent oxidoreductase [Scytonema sp. PCC 10023]	diamond	306	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PCC 10023

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