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

10 rows where analysis = "diamond", bioproject = "PRJNA643700" 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
26860102	26860102	PRJNA643700_P_NODE_282301_length_219_cov_2.411765_g280745_i0	PRJNA643700	282301	219	2.411765	5.28176535	Brasilonema angustatum	1249745	Bacteria	Bacteria	42.7	0.0275	NR	MBW4594700.1	1049008	g280745	i0	36.2	0.643835616438356	47	29	64.4	1	218	78	734	779	MBW4594700.1 EF-hand domain-containing protein [Brasilonema angustatum HA4187-MV1]	diamond	141	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema angustatum
27650064	27650064	PRJNA643700_P_NODE_295904_length_212_cov_1.276074_g294348_i0	PRJNA643700	295904	212	1.276074	2.70527688	candidate division WOR-1 bacterium RIFCSPHIGHO2_	2575572	Bacteria	Bacteria	42	0.041	NR	OGB86846.1	1802565	g294348	i0	33.9	0.834905660377358	59	37	80.7	1	200	30	105	163	OGB86846.1 MAG: hypothetical protein A3J44_02620 [candidate division WOR-1 bacterium RIFCSPHIGHO2_02_FULL_45_12]	diamond	177	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati						candidate division WOR-1 bacterium RIFCSPHIGHO2_02_FULL_45_12
27776405	27776405	PRJNA643700_P_NODE_79964_length_468_cov_2.384248_g78420_i0	PRJNA643700	79964	468	2.384248	11.15828064	Cyanobacteria bacterium J06629_18	3023183	Bacteria	Bacteria	50.1	9.95e-4	NR	MEO1764179.1	3023183	g78420	i0	58.3	0.717948717948718	36	15	23.1	0	212	105	250	285	MEO1764179.1 reverse transcriptase family protein [Cyanobacteria bacterium J06629_18]	diamond	336	50.4	0.994047619047619	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06629_18
29323229	29323229	PRJNA643700_P_NODE_352169_length_184_cov_1.866667_g350613_i0	PRJNA643700	352169	184	1.866667	3.43466728	Leptolyngbyaceae cyanobacterium HOT.MB2.61	2855467	Bacteria	Bacteria	44.7	0.0035	NR	MCL6433063.1	2855467	g350613	i0	40	2.05434782608696	50	28	81.5	1	184	35	201	248	MCL6433063.1 hypothetical protein [Leptolyngbyaceae cyanobacterium HOT.MB2.61]	diamond	378	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium HOT.MB2.61
30523571	30523571	PRJNA643700_P_NODE_264553_length_230_cov_1.436464_g262997_i0	PRJNA643700	264553	230	1.436464	3.3038672	Okeania sp. SIO3I5	2607805	Bacteria	Bacteria	42.7	0.0321	NR	WP_293137040.1	2607805	g262997	i0	41.7	0.626086956521739	48	28	62.6	0	196	53	828	875	WP_293137040.1 ATP-binding protein [Okeania sp. SIO3I5]	diamond	144	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO3I5
31250294	31250294	PRJNA643700_P_NODE_130855_length_360_cov_2.051447_g129300_i0	PRJNA643700	130855	360	2.051447	7.3852092	Prochlorococcus	1218	Bacteria	Bacteria	43.9	0.017	NR	WP_032516405.1	1218	g129300	i0	53.8	0.325	39	18	32.5	0	91	207	51	89	WP_032516405.1 MULTISPECIES: SxtJ family membrane protein [Prochlorococcus]	diamond	117	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus
31345313	31345313	PRJNA643700_P_NODE_237616_length_248_cov_1.653266_g236060_i0	PRJNA643700	237616	248	1.653266	4.10009968	Fischerella	1190	Bacteria	Bacteria	40.4	0.0409	NR	WP_071588902.1	1190	g236060	i0	38.1	0.508064516129032	42	22	46	1	90	203	26	67	WP_071588902.1 MULTISPECIES: hypothetical protein [Fischerella]	diamond	126	40.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella
31819577	31819577	PRJNA643700_P_NODE_207717_length_271_cov_4.049550_g206161_i0	PRJNA643700	207717	271	4.04955	10.9742805	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	41.2	0.0287	NR	MFM1811114.1	2847862	g206161	i0	39.6	0.531365313653137	48	29	53.1	0	89	232	18	65	MFM1811114.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	144	41.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32357829	32357829	PRJNA643700_P_NODE_327159_length_196_cov_1.414966_g325603_i0	PRJNA643700	327159	196	1.414966	2.77333336	Crocosphaera subtropica	2546360	Bacteria	Bacteria	42	0.0341	NR	WP_009546430.1	2546360	g325603	i0	34.9	0.658163265306122	43	28	65.8	0	22	150	108	150	WP_009546430.1 PEP-CTERM sorting domain-containing protein [Crocosphaera subtropica]	diamond	129	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera subtropica
32420907	32420907	PRJNA643700_P_NODE_196919_length_281_cov_2.198276_g195363_i0	PRJNA643700	196919	281	2.198276	6.17715556	Drouetiella sp.	3088174	Bacteria	Bacteria	42	0.03	NR	HEY9679855.1	3088174	g195363	i0	52.2	0.245551601423488	23	11	24.6	0	57	125	9	31	HEY9679855.1 hypothetical protein [Drouetiella sp.]	diamond	69	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella 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);;