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

17 rows where analysis = "diamond", bioproject = "PRJNA473201" 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
26854917	26854917	PRJNA473201_P_NODE_67441_length_250_cov_1.502825_g66699_i0	PRJNA473201	67441	250	1.502825	3.7570625	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	156	3.5099999999999995e-46	NR	MBX9722793.1	2364082	g66699	i0	92.8	1.992	83	6	99.6	0	1	249	57	139	MBX9722793.1 oligopeptide:H+ symporter [Candidatus Obscuribacterales bacterium]	diamond	498	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27360845	27360845	PRJNA473201_P_NODE_85603_length_241_cov_0.916667_g84861_i0	PRJNA473201	85603	241	0.916667	2.20916747	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	63.2	1.22e-10	NR	MDR3615454.1	2364082	g84861	i0	77.5	0.49792531120332	40	9	49.8	0	121	240	2	41	MDR3615454.1 helix-turn-helix transcriptional regulator [Candidatus Obscuribacterales bacterium]	diamond	120	63.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28086757	28086757	PRJNA473201_P_NODE_66725_length_251_cov_0.865169_g65983_i0	PRJNA473201	66725	251	0.865169	2.17157419	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	57.8	2.06e-7	NR	MBX9722685.1	2364082	g65983	i0	52.5	0.729083665338645	61	27	72.9	2	186	4	18	76	MBX9722685.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	183	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28513514	28513514	PRJNA473201_P_NODE_81567_length_243_cov_0.905882_g80825_i0	PRJNA473201	81567	243	0.905882	2.20129326	Bacillati	1783272	Bacteria	Bacteria	123	3.3499999999999993e-34	NR	MBX9686888.1	2364082	g80825	i0	82.5	3.95061728395062	80	14	98.8	0	3	242	41	120	MBX9686888.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	960	123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29129056	29129056	PRJNA473201_P_NODE_75429_length_246_cov_0.890173_g74687_i0	PRJNA473201	75429	246	0.890173	2.18982558	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	90.9	1.86e-20	NR	MBX9570298.1	2364082	g74687	i0	57.3	1	82	35	100	0	1	246	86	167	MBX9570298.1 class I SAM-dependent methyltransferase [Candidatus Obscuribacterales bacterium]	diamond	246	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29160671	29160671	PRJNA473201_P_NODE_83609_length_242_cov_0.911243_g82867_i0	PRJNA473201	83609	242	0.911243	2.20520806	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	77.4	2.32e-14	NR	MBX9685885.1	2364082	g82867	i0	48.8	1.01652892561983	82	39	97.9	2	3	239	545	626	MBX9685885.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	246	77.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29949861	29949861	PRJNA473201_P_NODE_81231_length_243_cov_0.905882_g80489_i0	PRJNA473201	81231	243	0.905882	2.20129326	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	91.3	4.1e-20	NR	MBX9571606.1	2364082	g80489	i0	61.3	1.91358024691358	80	31	98.8	0	241	2	5	84	MBX9571606.1 rod shape-determining protein MreC [Candidatus Obscuribacterales bacterium]	diamond	465	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30044486	30044486	PRJNA473201_P_NODE_81031_length_243_cov_0.905882_g80289_i0	PRJNA473201	81031	243	0.905882	2.20129326	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	82.4	2.65e-16	NR	MEB3301815.1	2847862	g80289	i0	56	0.925925925925926	75	32	91.4	1	242	21	218	292	MEB3301815.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	225	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30676331	30676331	PRJNA473201_P_NODE_73353_length_247_cov_0.885057_g72611_i0	PRJNA473201	73353	247	0.885057	2.18609079	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	80.1	2.85e-16	NR	MBX9722793.1	2364082	g72611	i0	79.6	0.595141700404858	49	10	59.5	0	245	99	165	213	MBX9722793.1 oligopeptide:H+ symporter [Candidatus Obscuribacterales bacterium]	diamond	147	80.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30834451	30834451	PRJNA473201_P_NODE_32034_length_350_cov_1.079422_g31292_i0	PRJNA473201	32034	350	1.079422	3.777977	Kaiparowitsia implicata	2303525	Bacteria	Bacteria	79	2.67e-14	NR	MBW4655182.1	2057771	g31292	i0	43.4	1.90285714285714	113	61	96	3	1	336	352	462	MBW4655182.1 hypothetical protein [Kaiparowitsia implicata GSE-PSE-MK54-09C]	diamond	666	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Kaiparowitsia	Kaiparowitsia implicata
30897800	30897800	PRJNA473201_P_NODE_69834_length_249_cov_0.875000_g69092_i0	PRJNA473201	69834	249	0.875	2.17875	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	146	1.72e-41	NR	MBX9693802.1	2847862	g69092	i0	90.2	1.97590361445783	82	8	98.8	0	247	2	49	130	MBX9693802.1 mannose-1-phosphate guanylyltransferase [Cyanobacteriota bacterium]	diamond	492	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31782769	31782769	PRJNA473201_P_NODE_44757_length_305_cov_1.176724_g44015_i0	PRJNA473201	44757	305	1.176724	3.5890082	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	99.8	1.35e-23	NR	MBY0356572.1	2364082	g44015	i0	52	1.00327868852459	102	48	99.3	1	305	3	13	114	MBY0356572.1 LPS export ABC transporter periplasmic protein LptC [Candidatus Obscuribacterales bacterium]	diamond	306	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31814584	31814584	PRJNA473201_P_NODE_82377_length_242_cov_1.804734_g81635_i0	PRJNA473201	82377	242	1.804734	4.36745628	Leptolyngbya ectocarpi	1202	Bacteria	Bacteria	50.1	9.37e-5	NR	WP_193993377.1	1202	g81635	i0	38.2	1.40082644628099	55	24	68.2	1	7	171	405	449	WP_193993377.1 hypothetical protein [Leptolyngbya ectocarpi]	diamond	339	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya ectocarpi
31846102	31846102	PRJNA473201_P_NODE_79077_length_244_cov_0.900585_g78335_i0	PRJNA473201	79077	244	0.900585	2.1974274	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	57.4	2.6e-7	NR	MBX9687176.1	2364082	g78335	i0	55	0.737704918032787	60	25	73.8	1	65	244	1	58	MBX9687176.1 argininosuccinate synthase [Candidatus Obscuribacterales bacterium]	diamond	180	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32115641	32115641	PRJNA473201_P_NODE_22978_length_411_cov_1.366864_g22236_i0	PRJNA473201	22978	411	1.366864	5.61781104	Bacteria	2	Bacteria	Bacteria	67.8	9.33e-12	NR	WP_106290132.1	292586	g22236	i0	54.8	0.883211678832117	62	28	45.3	0	188	3	37	98	WP_106290132.1 hypothetical protein [Merismopedia glauca]	diamond	363	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Merismopedia	Merismopedia glauca
32605434	32605434	PRJNA473201_P_NODE_86040_length_241_cov_0.910714_g85298_i0	PRJNA473201	86040	241	0.910714	2.19482074	Drouetiella sp.	3088174	Bacteria	Bacteria	137	2.5599999999999996e-35	NR	HEY9677651.1	3088174	g85298	i0	77.5	1.99170124481328	80	18	99.6	0	241	2	500	579	HEY9677651.1 hypothetical protein [Drouetiella sp.]	diamond	480	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
32636638	32636638	PRJNA473201_P_NODE_85260_length_241_cov_0.916667_g84518_i0	PRJNA473201	85260	241	0.916667	2.20916747	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	57.4	2.5e-7	NR	MBX9723093.1	2364082	g84518	i0	43.5	0.771784232365145	62	31	72.2	1	29	202	2	63	MBX9723093.1 HAMP domain-containing histidine kinase [Candidatus Obscuribacterales bacterium]	diamond	186	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium

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