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

10 rows where analysis = "diamond", bioproject = "PRJNA1115053" 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
8677431	8677431	PRJNA1115053_S_NODE_11687_length_557_cov_4.108949_g10003_i0	PRJNA1115053	11687	557	4.108949	22.88684593	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	305	7.01e-104	NR	MBX9724270.1	2364082	g10003	i0	88.1	0.904847396768402	168	20	90.5	0	540	37	3	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	504	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
20151129	20151129	PRJNA1115053_S_NODE_54216_length_327_cov_1.982394_g52399_i0	PRJNA1115053	54216	327	1.982394	6.48242838	Nostocales cyanobacterium ELA608	3064516	Bacteria	Bacteria	175	1.98e-53	NR	MEI6371987.1	3064516	g52399	i0	72.2	2.96330275229358	108	30	99.1	0	325	2	73	180	MEI6371987.1 NADH-quinone oxidoreductase subunit C [Nostocales cyanobacterium ELA608]	diamond	969	175	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium ELA608
27194305	27194305	PRJNA1115053_S_NODE_141842_length_225_cov_0.994505_g140025_i0	PRJNA1115053	141842	225	0.994505	2.23763625	Spirulina sp. SIO3F2	2607816	Bacteria	Bacteria	43.1	0.0226	NR	NEO83078.1	2607816	g140025	i0	37.5	1.49333333333333	56	28	72	2	49	210	161	211	NEO83078.1 glycosyltransferase [Spirulina sp. SIO3F2]	diamond	336	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina sp. SIO3F2
27384190	27384190	PRJNA1115053_S_NODE_247083_length_176_cov_3.255639_g245266_i0	PRJNA1115053	247083	176	3.255639	5.72992464	Leptolyngbya sp. SIO1E4	2607768	Bacteria	Bacteria	42.7	0.00621	NR	MBE7379966.1	2607768	g245266	i0	45.5	0.5625	33	18	56.3	0	173	75	36	68	MBE7379966.1 DUF1257 domain-containing protein [Leptolyngbya sp. SIO1E4]	diamond	99	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. SIO1E4
28110151	28110151	PRJNA1115053_S_NODE_199345_length_194_cov_1.642384_g197528_i0	PRJNA1115053	199345	194	1.642384	3.18622496	Leptolyngbya sp. GB1-A1	2933908	Bacteria	Bacteria	41.2	0.0132	NR	WP_348247410.1	2933908	g197528	i0	45.5	0.680412371134021	44	19	60.3	1	73	189	36	79	WP_348247410.1 hypothetical protein [Leptolyngbya sp. GB1-A1]	diamond	132	41.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. GB1-A1
28204799	28204799	PRJNA1115053_S_NODE_192026_length_197_cov_2.181818_g190209_i0	PRJNA1115053	192026	197	2.181818	4.29818146	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	41.6	0.0473	NR	MEY3870482.1	2847862	g190209	i0	37.7	0.807106598984772	53	27	79.2	2	197	42	111	158	MEY3870482.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	159	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28552480	28552480	PRJNA1115053_S_NODE_181387_length_202_cov_2.037736_g179570_i0	PRJNA1115053	181387	202	2.037736	4.11622672	Leptolyngbya sp.	47254	Bacteria	Bacteria	42	0.0414	NR	MBC6953554.1	47254	g179570	i0	36.8	0.846534653465347	57	31	77.2	1	174	19	165	221	MBC6953554.1 prepilin peptidase [Leptolyngbya sp.]	diamond	171	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp.
28678768	28678768	PRJNA1115053_S_NODE_151907_length_218_cov_2.194286_g150090_i0	PRJNA1115053	151907	218	2.194286	4.78354348	Synechococcus sp. A18-25c	1866938	Bacteria	Bacteria	42.7	0.0108	NR	WP_255478475.1	1866938	g150090	i0	40.3	0.853211009174312	62	33	81.2	2	201	25	26	86	WP_255478475.1 thermonuclease family protein [Synechococcus sp. A18-25c]	diamond	186	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. A18-25c
29246887	29246887	PRJNA1115053_S_NODE_291229_length_163_cov_3.600000_g289412_i0	PRJNA1115053	291229	163	3.6	5.868	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	115	3.73e-29	NR	MBN9393787.1	2052166	g289412	i0	100	0.975460122699387	53	0	97.5	0	161	3	229	281	MBN9393787.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	159	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30889550	30889550	PRJNA1115053_S_NODE_116234_length_244_cov_1.616915_g114417_i0	PRJNA1115053	116234	244	1.616915	3.9452726	Crocosphaera sp.	2729996	Bacteria	Bacteria	44.3	0.0111	NR	WP_300505136.1	2729996	g114417	i0	44.4	0.663934426229508	54	30	66.4	0	47	208	883	936	WP_300505136.1 CHAT domain-containing protein [Crocosphaera sp.]	diamond	162	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera sp.

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