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

11 rows where bioproject = "PRJNA861969", 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
3397232	3397232	PRJNA861969_P_NODE_34283_length_248_cov_0.880000_g34052_i0	PRJNA861969	34283	248	0.88	2.1824	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	363	9.119999999999997e-96	NTclustered	gi\|225696178\|gb\|FJ805845.1\|	259957	g34052	i0	93.802	174.713709677419	242	14	98	1	3	244	1581	1821	Uncultured Chroococcidiopsis sp. clone AU1_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43329	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11050400	11050400	PRJNA861969_P_NODE_9049_length_429_cov_1.780899_g8818_i0	PRJNA861969	9049	429	1.780899	7.64005671	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	551	3.349999999999999e-152	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g8818	i0	90.118	166.030303030303	425	40	99	2	1	423	2277	1853	Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	71227	551	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11440207	11440207	PRJNA861969_P_NODE_23049_length_284_cov_1.459716_g22818_i0	PRJNA861969	23049	284	1.459716	4.14559344	Chroococcidiopsis	54298	Bacteria	Bacteria	503	6.02e-138	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g22818	i0	98.592	2	284	4	100	0	1	284	2365786	2366069	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	568	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
14874621	14874621	PRJNA861969_P_NODE_41712_length_241_cov_0.916667_g41481_i0	PRJNA861969	41712	241	0.916667	2.20916747	Phormidium nigroviride	482564	Bacteria	Bacteria	329	8.95e-86	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g41481	i0	91.322	3.90871369294606	242	20	100	1	1	241	6425198	6424957	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	942	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
25072375	25072375	PRJNA861969_P_NODE_21220_length_294_cov_1.393665_g20989_i0	PRJNA861969	21220	294	1.393665	4.0973751	Nostoc sp. PCC 7524	28072	Bacteria	Bacteria	538	1.7199999999999995e-148	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g20989	i0	99.66	5.00680272108844	294	1	100	0	1	294	6008757	6009050	Nostoc sp. PCC 7524, complete genome	blastn	1472	538	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
28097345	28097345	PRJNA861969_P_NODE_5545_length_546_cov_2.114165_g5315_i0	PRJNA861969	5545	546	2.114165	11.5433409	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	46.2	0.0324	NR	MEW5820732.1	2847862	g5315	i0	35.1	0.423076923076923	77	50	42.3	0	440	210	144	220	MEW5820732.1 SGNH/GDSL hydrolase family protein [Cyanobacteriota bacterium]	diamond	231	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28831635	28831635	PRJNA861969_P_NODE_35588_length_247_cov_0.885057_g35357_i0	PRJNA861969	35588	247	0.885057	2.18609079	Spirulina	1154	Bacteria	Bacteria	94.4	2.69e-20	NR	NEO87136.1	2607816	g35357	i0	57.3	3.95951417004049	82	34	99.6	1	2	247	472	552	NEO87136.1 GHKL domain-containing protein [Spirulina sp. SIO3F2]	diamond	978	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina sp. SIO3F2
29644118	29644118	PRJNA861969_P_NODE_25510_length_273_cov_1.540000_g25279_i0	PRJNA861969	25510	273	1.54	4.2042	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	182	5.11e-51	NR	MDQ5937995.1	3070899	g25279	i0	98.9	1	91	1	100	0	273	1	371	461	MDQ5937995.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	273	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
30023694	30023694	PRJNA861969_P_NODE_26831_length_267_cov_1.484536_g26600_i0	PRJNA861969	26831	267	1.484536	3.96371112	Iningainema tapete	2806730	Bacteria	Bacteria	51.6	4.04e-5	NR	WP_190835607.1	2806730	g26600	i0	88.5	0.292134831460674	26	3	29.2	0	73	150	2085	2110	WP_190835607.1 type I polyketide synthase [Iningainema tapete]	diamond	78	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Iningainema	Iningainema tapete
30189556	30189556	PRJNA861969_P_NODE_31792_length_250_cov_0.870056_g31561_i0	PRJNA861969	31792	250	0.870056	2.17514	Cyanophyceae	3028117	Bacteria	Bacteria	71.2	3.54e-12	NR	WP_190595277.1	1162	g31561	i0	58.8	2.304	68	28	81.6	0	1	204	364	431	WP_190595277.1 MULTISPECIES: glycosyltransferase [Nostocaceae]	diamond	576	71.6	0.994413407821229	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae
32521515	32521515	PRJNA861969_P_NODE_28799_length_258_cov_1.664865_g28568_i0	PRJNA861969	28799	258	1.664865	4.2953517	Nostoc ellipsosporum	45916	Bacteria	Bacteria	102	6.5e-23	NR	MDF2385032.1	2804519	g28568	i0	100	1	86	0	100	0	1	258	755	840	MDF2385032.1 RHS repeat protein [Nostoc ellipsosporum NOK]	diamond	258	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc ellipsosporum

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