metadata: contig_metadata: 19 rows where bioproject = "PRJNA1093380", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

19 rows where bioproject = "PRJNA1093380", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Cyanobacteriota"

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
2294642	2294642	PRJNA1093380_P_NODE_3502_length_328_cov_1.886275_g3396_i0	PRJNA1093380	3502	328	1.886275	6.186982	Nostocales	1161	Bacteria	Bacteria	479	1.1899999999999996e-130	NTclustered	gi\|78217335\|gb\|DQ234823.1\|	1166	g3396	i0	100	93.8932926829268	259	0	79	0	1	259	259	1	Anabaena flos-aquae strain UTEX LB2338 16S ribosomal RNA gene, partial sequence	blastn	30797	481	0.995841995841996	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum flos-aquae
4025766	4025766	PRJNA1093380_P_NODE_16004_length_243_cov_0.905882_g15898_i0	PRJNA1093380	16004	243	0.905882	2.20129326	Tolypothrix sp. PCC 7910	2099387	Bacteria	Bacteria	193	1.24e-44	NTclustered	gi\|1826566097\|gb\|CP050440.1\|	2099387	g15898	i0	88.679	8.56378600823045	159	16	65	2	8	165	5011083	5010926	Tolypothrix sp. PCC 7910 chromosome, complete genome	blastn	2081	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. PCC 7910
5302057	5302057	PRJNA1093380_P_NODE_5805_length_286_cov_1.807512_g5699_i0	PRJNA1093380	5805	286	1.807512	5.16948432	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	490	4.729999999999998e-134	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g5699	i0	97.552	177.545454545455	286	7	100	0	1	286	1244678	1244393	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	50778	490	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
6577099	6577099	PRJNA1093380_P_NODE_2906_length_351_cov_1.615108_g2800_i0	PRJNA1093380	2906	351	1.615108	5.66902908	uncultured Pleurocapsales cyanobacterium	183215	Bacteria	Bacteria	580	3.419999999999999e-161	NTclustered	gi\|745734118\|gb\|KM458372.1\|	183215	g2800	i0	100	127.501424501424	314	0	89	0	38	351	1	314	Uncultured Pleurocapsales cyanobacterium isolate OTU 00115 23S ribosomal RNA gene, partial sequence	blastn	44753	580	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			uncultured Pleurocapsales cyanobacterium
11677839	11677839	PRJNA1093380_P_NODE_8070_length_273_cov_1.155000_g7964_i0	PRJNA1093380	8070	273	1.155	3.15315	Nostoc punctiforme	272131	Bacteria	Bacteria	451	2.11e-122	NTclustered	gi\|1345606787\|gb\|MG968521.1\|	2081948	g7964	i0	96.958	254.395604395604	263	7	96	1	1	262	516	778	Nostoc punctiforme UTEX B 1629 23S ribosomal RNA gene, partial sequence	blastn	69450	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
13772622	13772622	PRJNA1093380_P_NODE_9551_length_264_cov_3.183246_g9445_i0	PRJNA1093380	9551	264	3.183246	8.40376944	Limnospira	2596745	Bacteria	Bacteria	488	1.5499999999999999e-133	NTclustered	gi\|1527124232\|emb\|LR025155.1\|	118562	g9445	i0	100	8.60227272727273	264	0	100	0	1	264	4409	4146	Arthrospira platensis mRNA for Ferredoxin-dependent glutamate synthase (A-glsF gene)	blastn	2271	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
20600127	20600127	PRJNA1093380_P_NODE_12877_length_249_cov_1.312500_g12771_i0	PRJNA1093380	12877	249	1.3125	3.268125	Leptolyngbya sp. HK-04	1137094	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|803375594\|dbj\|AB694933.1\|	1137094	g12771	i0	96.787	109.228915662651	249	8	100	0	1	249	294	46	Leptolyngbya sp. HK-04 gene for 16S ribosomal RNA, partial sequence	blastn	27198	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. HK-04
21421331	21421331	PRJNA1093380_P_NODE_697_length_666_cov_1.741990_g596_i0	PRJNA1093380	697	666	1.74199	11.6016534	Nostoc	1177	Bacteria	Bacteria	1096	0	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g596	i0	96.274	278.864864864865	671	19	100	5	1	666	6474845	6474176	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	185724	1105	0.99185520361991	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
26655854	26655854	PRJNA1093380_P_NODE_6401_length_283_cov_1.280952_g6295_i0	PRJNA1093380	6401	283	1.280952	3.62509416	Cyanobacteria bacterium PR.023	2067979	Bacteria	Bacteria	134	3.58e-36	NR	MBA4074325.1	2067979	g6295	i0	63.8	0.996466431095406	94	34	99.6	0	283	2	221	314	MBA4074325.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	282	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
27004219	27004219	PRJNA1093380_P_NODE_5242_length_290_cov_1.244240_g5136_i0	PRJNA1093380	5242	290	1.24424	3.608296	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	44.7	0.0137	NR	MDQ5938067.1	3070899	g5136	i0	50	1.0551724137931	44	21	45.5	1	139	8	691	733	MDQ5938067.1 protein O-mannosyl-transferase [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	306	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
27121861	27121861	PRJNA1093380_P_NODE_10862_length_257_cov_1.255435_g10756_i0	PRJNA1093380	10862	257	1.255435	3.22646795	Bacillati	1783272	Bacteria	Bacteria	113	5.7600000000000005e-27	NR	MBA4050008.1	2067976	g10756	i0	71.4	6.88715953307393	84	24	98.1	0	6	257	128	211	MBA4050008.1 hypothetical protein [Cyanobacteria bacterium DS2.008]	diamond	1770	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium DS2.008
27699753	27699753	PRJNA1093380_P_NODE_12024_length_251_cov_0.865169_g11918_i0	PRJNA1093380	12024	251	0.865169	2.17157419	Trichormus sp.	3088172	Bacteria	Bacteria	63.2	1.55e-9	NR	HEY9717315.1	3088172	g11918	i0	59.6	0.621513944223108	52	21	62.2	0	164	9	5	56	HEY9717315.1 DUF6088 family protein [Trichormus sp.]	diamond	156	63.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus sp.
28141693	28141693	PRJNA1093380_P_NODE_16585_length_242_cov_0.911243_g16479_i0	PRJNA1093380	16585	242	0.911243	2.20520806	Cyanobacteria bacterium REEB67	2800110	Bacteria	Bacteria	128	1.25e-33	NR	MBU6453638.1	2800110	g16479	i0	78.8	0.991735537190083	80	17	99.2	0	241	2	202	281	MBU6453638.1 electron transfer flavoprotein subunit alpha/FixB family protein [Cyanobacteria bacterium REEB67]	diamond	240	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium REEB67
29719898	29719898	PRJNA1093380_P_NODE_9930_length_262_cov_1.857143_g9824_i0	PRJNA1093380	9930	262	1.857143	4.86571466	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	85.1	2.16e-17	NR	MBX9694561.1	2847862	g9824	i0	57.3	1.01908396946565	89	32	97.3	3	3	257	104	190	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	267	85.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29742866	29742866	PRJNA1093380_P_NODE_11710_length_251_cov_2.595506_g11604_i0	PRJNA1093380	11710	251	2.595506	6.51472006	Cyanophyceae	3028117	Bacteria	Bacteria	84.7	1.62e-17	NR	MBU6450293.1	2800110	g11604	i0	85.4	3.44223107569721	48	7	57.4	0	105	248	1	48	MBU6450293.1 hypothetical protein [Cyanobacteria bacterium REEB67]	diamond	864	85.1	0.995299647473561	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium REEB67
29814793	29814793	PRJNA1093380_P_NODE_13011_length_249_cov_0.875000_g12905_i0	PRJNA1093380	13011	249	0.875	2.17875	Cyanobacteria bacterium REEB67	2800110	Bacteria	Bacteria	82.8	5.42e-17	NR	MBU6450576.1	2800110	g12905	i0	74.5	1.30120481927711	55	14	66.3	0	1	165	188	242	MBU6450576.1 MBL fold metallo-hydrolase [Cyanobacteria bacterium REEB67]	diamond	324	82.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium REEB67
30912209	30912209	PRJNA1093380_P_NODE_5594_length_287_cov_3.102804_g5488_i0	PRJNA1093380	5594	287	3.102804	8.90504748	Oscillatoriales	1150	Bacteria	Bacteria	43.1	0.0467	NR	WP_224413378.1	331517	g5488	i0	47.1	1.06620209059233	51	25	53.3	1	104	256	23	71	WP_224413378.1 chloride channel protein [Oscillatoria salina]	diamond	306	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria salina
31489945	31489945	PRJNA1093380_P_NODE_14116_length_247_cov_0.885057_g14010_i0	PRJNA1093380	14116	247	0.885057	2.18609079	Planktothrix sp.	3088171	Bacteria	Bacteria	103	3.4e-24	NR	HEY9777800.1	3088171	g14010	i0	56.8	0.983805668016194	81	35	98.4	0	3	245	239	319	HEY9777800.1 DUF3253 domain-containing protein [Planktothrix sp.]	diamond	243	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp.
31797137	31797137	PRJNA1093380_P_NODE_13117_length_249_cov_0.875000_g13011_i0	PRJNA1093380	13117	249	0.875	2.17875	Bacillati	1783272	Bacteria	Bacteria	104	2.4e-26	NR	MBA4079317.1	2067979	g13011	i0	67.5	2	83	26	98.8	1	3	248	57	139	MBA4079317.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	498	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023

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