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

11 rows where analysis = "diamond", bioproject = "PRJNA1025141" 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
3989438	3989438	PRJNA1025141_P_NODE_8804_length_262_cov_0.783069_g8743_i0	PRJNA1025141	8804	262	0.783069	2.05164078	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	128	2.0899999999999997e-35	NR	MBL8086383.1	2711154	g8743	i0	77.5	0.916030534351145	80	18	91.6	0	261	22	65	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	240	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
10366041	10366041	PRJNA1025141_P_NODE_4949_length_364_cov_1.412371_g4888_i0	PRJNA1025141	4949	364	1.412371	5.14103044	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	143	3.82e-39	NR	MBX9694561.1	2847862	g4888	i0	62.5	0.989010989010989	120	44	98.1	1	360	4	63	182	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	360	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
19288486	19288486	PRJNA1025141_P_NODE_2776_length_491_cov_3.093301_g2715_i0	PRJNA1025141	2776	491	3.093301	15.18810791	Cyanobium sp. ARS6	2024869	Bacteria	Bacteria	219	6.59e-70	NR	CAI8350359.1	2024869	g2715	i0	70.3	2.71283095723014	148	44	90.4	0	465	22	46	193	CAI8350359.1 MAG: Nucleoside diphosphate kinase [Cyanobium sp. ARS6]	diamond	1332	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ARS6
20563877	20563877	PRJNA1025141_P_NODE_10297_length_249_cov_0.875000_g10236_i0	PRJNA1025141	10297	249	0.875	2.17875	Picosynechococcus sp. PCC 7	32049	Bacteria	Bacteria	138	1.7e-37	NR	WP_217833161.1	32049	g10236	i0	73.2	0.987951807228916	82	22	98.8	0	3	248	102	183	WP_217833161.1 integrase, partial [Picosynechococcus sp. PCC 7002]	diamond	246	138	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7002
28701082	28701082	PRJNA1025141_P_NODE_4087_length_402_cov_1.224924_g4026_i0	PRJNA1025141	4087	402	1.224924	4.92419448	Cyanophyceae	3028117	Bacteria	Bacteria	124	8.089999999999998e-30	NR	WP_017718509.1	1173028	g4026	i0	48.5	4.02985074626866	134	62	98.5	2	5	400	249	377	WP_017718509.1 pyridoxal-dependent decarboxylase [Oscillatoria sp. PCC 10802]	diamond	1620	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. PCC 10802
28827017	28827017	PRJNA1025141_P_NODE_6268_length_319_cov_1.536585_g6207_i0	PRJNA1025141	6268	319	1.536585	4.90170615	Microcystis	1125	Bacteria	Bacteria	45.1	0.0138	NR	WP_348529896.1	1126	g6207	i0	35.8	1.99373040752351	109	62	99.7	2	2	319	448	551	WP_348529896.1 Calx-beta domain-containing protein, partial [Microcystis aeruginosa]	diamond	636	45.4	0.993392070484582	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
29687273	29687273	PRJNA1025141_P_NODE_4310_length_392_cov_0.893417_g4249_i0	PRJNA1025141	4310	392	0.893417	3.50219464	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	62.4	2.72e-8	NR	MFQ3634381.1	2847862	g4249	i0	35.3	1.82142857142857	119	71	91.1	2	362	6	338	450	MFQ3634381.1 Calx-beta domain-containing protein [Cyanobacteriota bacterium]	diamond	714	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30445931	30445931	PRJNA1025141_P_NODE_4833_length_369_cov_1.523649_g4772_i0	PRJNA1025141	4833	369	1.523649	5.62226481	Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11	1801609	Bacteria	Bacteria	63.9	4.18e-9	NR	OGI09100.1	1801609	g4772	i0	33	1.26829268292683	112	59	82.1	3	349	47	108	214	OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11]	diamond	468	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11
31393995	31393995	PRJNA1025141_P_NODE_5476_length_344_cov_0.852399_g5415_i0	PRJNA1025141	5476	344	0.852399	2.93225256	Nodularia sp. LEGE	2047085	Bacteria	Bacteria	47.8	0.00212	NR	WP_227789408.1	1828639	g5415	i0	37	0.47093023255814	54	33	47.1	1	1	162	1112	1164	WP_227789408.1 tetratricopeptide repeat protein [Nodularia sp. LEGE 04288]	diamond	162	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia sp. LEGE 04288
31583806	31583806	PRJNA1025141_P_NODE_1956_length_588_cov_1.423301_g1896_i0	PRJNA1025141	1956	588	1.423301	8.36900988	Coleofasciculus sp. G2-EDA-02	3069529	Bacteria	Bacteria	104	1.1099999999999999e-23	NR	MEQ9669851.1	3069529	g1896	i0	39.4	1.90816326530612	188	98	93.4	7	552	4	34	210	MEQ9669851.1 carbonic anhydrase family protein [Coleofasciculus sp. G2-EDA-02]	diamond	1122	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. G2-EDA-02
32406261	32406261	PRJNA1025141_P_NODE_7439_length_290_cov_1.115207_g7378_i0	PRJNA1025141	7439	290	1.115207	3.2341003	Trichodesmium sp. MAG_R01	2917417	Bacteria	Bacteria	47.4	0.00154	NR	MCL2927900.1	2917417	g7378	i0	46.2	0.537931034482759	52	18	43.4	1	2	127	414	465	MCL2927900.1 Cys-every-fifth RiPP peptide CefA [Trichodesmium sp. MAG_R01]	diamond	156	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Trichodesmium	Trichodesmium sp. MAG_R01

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