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

12 rows where analysis = "diamond", bioproject = "PRJNA1046144" 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
5275659	5275659	PRJNA1046144_P_NODE_67005_length_228_cov_0.905660_g66710_i0	PRJNA1046144	67005	228	0.90566	2.0649048	Coleofasciculus sp. C3-bin4	2768885	Bacteria	Bacteria	133	1.73e-37	NR	MBD0362061.1	2768885	g66710	i0	93.8	0.855263157894737	65	4	85.5	0	1	195	127	191	MBD0362061.1 DUF924 domain-containing protein [Coleofasciculus sp. C3-bin4]	diamond	195	133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. C3-bin4
28077463	28077463	PRJNA1046144_P_NODE_71745_length_212_cov_2.601399_g71450_i0	PRJNA1046144	71745	212	2.601399	5.51496588	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	63.2	1.36e-9	NR	MBX9674102.1	2364082	g71450	i0	46.9	0.905660377358491	64	34	90.6	0	212	21	273	336	MBX9674102.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	192	63.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28322049	28322049	PRJNA1046144_P_NODE_51066_length_245_cov_1.869318_g50771_i0	PRJNA1046144	51066	245	1.869318	4.5798291	Bacillati	1783272	Bacteria	Bacteria	98.6	8.63e-22	NR	WP_073601648.1	1616834	g50771	i0	79.3	2.8530612244898	58	12	71	0	175	2	1	58	WP_073601648.1 site-specific DNA-methyltransferase [Hydrococcus rivularis]	diamond	699	99.4	0.991951710261569	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hydrococcaceae	Hydrococcus	Hydrococcus rivularis
28677585	28677585	PRJNA1046144_P_NODE_51487_length_244_cov_2.371429_g51192_i0	PRJNA1046144	51487	244	2.371429	5.78628676	Nostoc sp.	1180	Bacteria	Bacteria	105	2.37e-24	NR	WP_335118582.1	1180	g51192	i0	58.3	3.09836065573771	84	31	98.4	1	2	241	968	1051	WP_335118582.1 amino acid adenylation domain-containing protein [Nostoc sp.]	diamond	756	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
29687527	29687527	PRJNA1046144_P_NODE_60470_length_232_cov_0.883436_g60175_i0	PRJNA1046144	60470	232	0.883436	2.04957152	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	50.8	4.25e-5	NR	MDQ5937846.1	3070899	g60175	i0	72.4	0.375	29	8	37.5	0	144	230	1	29	MDQ5937846.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	87	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
30003757	30003757	PRJNA1046144_P_NODE_25111_length_330_cov_2.126437_g24816_i0	PRJNA1046144	25111	330	2.126437	7.0172421	Cyanobacteria bacterium PR.023	2067979	Bacteria	Bacteria	71.2	1.16e-12	NR	MBA4078367.1	2067979	g24816	i0	55.6	1.96363636363636	72	31	64.5	1	219	7	12	83	MBA4078367.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	648	71.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
30161406	30161406	PRJNA1046144_P_NODE_63752_length_230_cov_0.894410_g63457_i0	PRJNA1046144	63752	230	0.89441	2.057143	Cyanobacteria bacterium SZAS LIN-5	2807734	Bacteria	Bacteria	82	1.47e-17	NR	MBS2001894.1	2807734	g63457	i0	90.9	0.573913043478261	44	3	57.4	1	229	98	121	163	MBS2001894.1 DNA repair protein RadC [Cyanobacteria bacterium SZAS LIN-5]	diamond	132	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-5
30375199	30375199	PRJNA1046144_P_NODE_59872_length_232_cov_1.766871_g59577_i0	PRJNA1046144	59872	232	1.766871	4.09914072	Bacillati	1783272	Bacteria	Bacteria	57.8	1.32e-7	NR	MBA4078136.1	2067979	g59577	i0	42.2	2.48275862068966	64	37	82.8	0	41	232	73	136	MBA4078136.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	576	58.2	0.993127147766323	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
31868372	31868372	PRJNA1046144_P_NODE_45637_length_257_cov_2.707447_g45342_i0	PRJNA1046144	45637	257	2.707447	6.95813879	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	97.4	1.35e-21	NR	MDR3615585.1	2364082	g45342	i0	48.2	0.992217898832685	85	44	99.2	0	2	256	285	369	MDR3615585.1 HAMP domain-containing sensor histidine kinase [Candidatus Obscuribacterales bacterium]	diamond	255	97.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31995103	31995103	PRJNA1046144_P_NODE_67398_length_227_cov_1.784810_g67103_i0	PRJNA1046144	67398	227	1.78481	4.0515187	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	99.8	1.13e-22	NR	MBX9691839.1	2847862	g67103	i0	63.9	0.951541850220264	72	26	95.2	0	10	225	98	169	MBX9691839.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	216	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32311793	32311793	PRJNA1046144_P_NODE_51939_length_243_cov_2.258621_g51644_i0	PRJNA1046144	51939	243	2.258621	5.48844903	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	58.2	9.55e-8	NR	MFA6560206.1	2364082	g51644	i0	49.2	1.55555555555556	63	31	77.8	1	234	46	9	70	MFA6560206.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	378	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32879420	32879420	PRJNA1046144_P_NODE_55140_length_236_cov_2.419162_g54845_i0	PRJNA1046144	55140	236	2.419162	5.70922232	Drouetiella sp.	3088174	Bacteria	Bacteria	156	1.19e-44	NR	HEY9732185.1	3088174	g54845	i0	100	1.98305084745763	78	0	99.2	0	236	3	149	226	HEY9732185.1 SDR family NAD(P)-dependent oxidoreductase [Drouetiella sp.]	diamond	468	156	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);;