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

24 rows where analysis = "diamond", bioproject = "PRJNA557436" 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
27236822	27236822	PRJNA557436_S_NODE_1843_length_274_cov_3.104603_g1795_i0	PRJNA557436	1843	274	3.104603	8.50661222	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	58.5	1.38e-7	NR	HEY9745493.1	3088181	g1795	i0	45.9	0.667883211678832	61	32	65.7	1	221	42	2	62	HEY9745493.1 RNA ligase [Oculatellaceae cyanobacterium]	diamond	183	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
27236833	27236833	PRJNA557436_S_NODE_5803_length_175_cov_1.178571_g5755_i0	PRJNA557436	5803	175	1.178571	2.06249925	Limnospira platensis	118562	Bacteria	Bacteria	75.1	2.5e-15	NR	MDV7395081.1	3080829	g5755	i0	58.6	0.994285714285714	58	23	97.7	1	1	171	19	76	MDV7395081.1 hypothetical protein [Arthrospira platensis SPKY1]	diamond	174	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
27363591	27363591	PRJNA557436_S_NODE_3003_length_223_cov_1.627660_g2955_i0	PRJNA557436	3003	223	1.62766	3.6296818	Limnospira platensis	118562	Bacteria	Bacteria	51.6	3.41e-6	NR	MDV7396614.1	3080829	g2955	i0	45.5	1.80269058295964	66	33	88.8	1	21	218	39	101	MDV7396614.1 hypothetical protein [Arthrospira platensis SPKY1]	diamond	402	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
27679402	27679402	PRJNA557436_S_NODE_7804_length_159_cov_1.274194_g7756_i0	PRJNA557436	7804	159	1.274194	2.02596846	Microcoleus sp. herbarium19	3055440	Bacteria	Bacteria	67.4	5.58e-12	NR	WP_333272797.1	3055440	g7756	i0	64.7	1.92452830188679	51	17	96.2	1	2	154	31	80	WP_333272797.1 hypothetical protein [Microcoleus sp. herbarium19]	diamond	306	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium19
27773964	27773964	PRJNA557436_S_NODE_1824_length_275_cov_2.816667_g1776_i0	PRJNA557436	1824	275	2.816667	7.74583425	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	58.2	1.57e-7	NR	MFN5119220.1	2847862	g1776	i0	67.9	0.610909090909091	56	17	61.1	1	4	171	171	225	MFN5119220.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	168	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27899892	27899892	PRJNA557436_S_NODE_2485_length_241_cov_1.694175_g2437_i0	PRJNA557436	2485	241	1.694175	4.08296175	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	47	1.09e-4	NR	MFM1842232.1	2847862	g2437	i0	73.1	0.323651452282158	26	7	32.4	0	163	240	13	38	MFM1842232.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	78	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28310655	28310655	PRJNA557436_S_NODE_5846_length_174_cov_1.899281_g5798_i0	PRJNA557436	5846	174	1.899281	3.30474894	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	120	6.0099999999999994e-30	NR	MBK7841898.1	2711154	g5798	i0	98.2	0.982758620689655	57	1	98.3	0	173	3	150	206	MBK7841898.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	171	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28563246	28563246	PRJNA557436_S_NODE_5867_length_174_cov_1.561151_g5819_i0	PRJNA557436	5867	174	1.561151	2.71640274	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	112	4.4199999999999995e-30	NR	MBK7841901.1	2711154	g5819	i0	100	1	58	0	100	0	1	174	26	83	MBK7841901.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	174	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28721095	28721095	PRJNA557436_S_NODE_4047_length_199_cov_1.432927_g3999_i0	PRJNA557436	4047	199	1.432927	2.85152473	Aphanizomenon flos-aquae WA1	1176	Bacteria	Bacteria	102	9.329999999999999e-24	NR	OBQ43526.1	1710896	g3999	i0	72.7	1.98994974874372	66	18	99.5	0	199	2	208	273	OBQ43526.1 MAG: hypothetical protein AN484_11950 [Aphanizomenon flos-aquae WA102]	diamond	396	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
29068484	29068484	PRJNA557436_S_NODE_5028_length_184_cov_1.590604_g4980_i0	PRJNA557436	5028	184	1.590604	2.92671136	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	89.4	1.84e-20	NR	MBK8191433.1	2692181	g4980	i0	65.6	1.98913043478261	61	21	99.5	0	183	1	103	163	MBK8191433.1 endonuclease VII domain-containing protein [Vampirovibrionales bacterium]	diamond	366	89.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales			Vampirovibrionales bacterium
29068494	29068494	PRJNA557436_S_NODE_8588_length_154_cov_2.016807_g8540_i0	PRJNA557436	8588	154	2.016807	3.10588278	Cyanobacteria bacterium K_DeepCast_35m_m2_023	2775549	Bacteria	Bacteria	64.7	6.96e-11	NR	MBM5800586.1	2775549	g8540	i0	69	0.818181818181818	42	13	81.8	0	130	5	61	102	MBM5800586.1 hypothetical protein [Cyanobacteria bacterium K_DeepCast_35m_m2_023]	diamond	126	64.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K_DeepCast_35m_m2_023
29699403	29699403	PRJNA557436_S_NODE_7930_length_158_cov_1.447154_g7882_i0	PRJNA557436	7930	158	1.447154	2.28650332	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	103	5.529999999999999e-24	NR	MBK7841898.1	2711154	g7882	i0	100	0.987341772151899	52	0	98.7	0	2	157	431	482	MBK7841898.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	156	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
29857630	29857630	PRJNA557436_S_NODE_1171_length_337_cov_2.132450_g1123_i0	PRJNA557436	1171	337	2.13245	7.1863565	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	67	3.44e-10	NR	MBK7842060.1	2711154	g1123	i0	65.4	0.979228486646884	52	18	46.3	0	291	136	15	66	MBK7842060.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	330	67	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
29921038	29921038	PRJNA557436_S_NODE_1931_length_269_cov_1.722222_g1883_i0	PRJNA557436	1931	269	1.722222	4.63277718	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	155	8.049999999999999e-46	NR	MBK7841900.1	2711154	g1883	i0	95.5	0.992565055762082	89	4	99.3	0	267	1	40	128	MBK7841900.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	267	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
30124312	30124312	PRJNA557436_S_NODE_8132_length_157_cov_1.188525_g8084_i0	PRJNA557436	8132	157	1.188525	1.86598425	Candidatus Obscuribacter	1906156	Bacteria	Bacteria	114	6.57e-28	NR	MBX3137679.1	2364082	g8084	i0	100	2.98089171974522	52	0	99.4	0	2	157	216	267	MBX3137679.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	468	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30332100	30332100	PRJNA557436_S_NODE_592_length_458_cov_1.886525_g544_i0	PRJNA557436	592	458	1.886525	8.6402845	Microcystis sp. M	1127	Bacteria	Bacteria	89.4	3.93e-20	NR	WP_287873660.1	2771111	g544	i0	54	0.569868995633188	87	37	57	2	107	367	2	85	WP_287873660.1 hypothetical protein [Microcystis sp. M034S1]	diamond	261	89.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M034S1
30963625	30963625	PRJNA557436_S_NODE_1634_length_290_cov_2.925490_g1586_i0	PRJNA557436	1634	290	2.92549	8.483921	Pseudanabaena sp.	1153	Bacteria	Bacteria	124	2.2799999999999998e-32	NR	MFN9051406.1	1153	g1586	i0	68.1	0.941379310344828	91	29	94.1	0	288	16	31	121	MFN9051406.1 hypothetical protein [Pseudanabaena sp.]	diamond	273	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
31374560	31374560	PRJNA557436_S_NODE_6916_length_165_cov_1.407692_g6868_i0	PRJNA557436	6916	165	1.407692	2.3226918	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	116	9.33e-29	NR	MBK7841898.1	2711154	g6868	i0	100	0.963636363636364	53	0	96.4	0	163	5	274	326	MBK7841898.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	159	116	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
31532756	31532756	PRJNA557436_S_NODE_1196_length_334_cov_1.779264_g1148_i0	PRJNA557436	1196	334	1.779264	5.94274176	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	62.8	4.81e-9	NR	ARV61587.1	1940762	g1148	i0	46.8	2.12874251497006	77	36	69.2	1	329	99	167	238	ARV61587.1 hypothetical protein BZZ01_25810 [Nostocales cyanobacterium HT-58-2]	diamond	711	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
32007101	32007101	PRJNA557436_S_NODE_6818_length_166_cov_1.160305_g6770_i0	PRJNA557436	6818	166	1.160305	1.9261063	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	72.8	7.88e-14	NR	MFA6213521.1	2364082	g6770	i0	58.2	0.993975903614458	55	23	99.4	0	2	166	99	153	MFA6213521.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	165	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32323832	32323832	PRJNA557436_S_NODE_2279_length_251_cov_1.736111_g2231_i0	PRJNA557436	2279	251	1.736111	4.35763861	Leptolyngbya sp. PCC 7375	102129	Bacteria	Bacteria	40.8	0.0275	NR	EKU97980.1	102129	g2231	i0	30.2	0.752988047808765	63	44	75.3	0	195	7	1	63	EKU97980.1 hypothetical protein Lepto7375DRAFT_7239 [Leptolyngbya sp. PCC 7375]	diamond	189	40.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PCC 7375
32639251	32639251	PRJNA557436_S_NODE_580_length_463_cov_2.546729_g532_i0	PRJNA557436	580	463	2.546729	11.79135527	Lyngbya sp. HA4199-MV5	2835090	Bacteria	Bacteria	65.9	2.55e-9	NR	MBW4694177.1	2835090	g532	i0	78.4	0.239740820734341	37	8	24	0	349	459	2	38	MBW4694177.1 macro domain-containing protein [Lyngbya sp. HA4199-MV5]	diamond	111	65.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Lyngbya	Lyngbya sp. HA4199-MV5
32734143	32734143	PRJNA557436_S_NODE_9260_length_151_cov_2.077586_g9212_i0	PRJNA557436	9260	151	2.077586	3.13715486	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	88.6	7.890000000000001e-21	NR	MBK7841899.1	2711154	g9212	i0	94	0.993377483443709	50	3	99.3	0	150	1	78	127	MBK7841899.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	150	88.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
32859926	32859926	PRJNA557436_S_NODE_8240_length_156_cov_1.636364_g8192_i0	PRJNA557436	8240	156	1.636364	2.55272784	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	66.2	2.04e-11	NR	MFA6213521.1	2364082	g8192	i0	68.6	0.980769230769231	51	16	98.1	0	3	155	5	55	MFA6213521.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	153	66.2	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);;