metadata: contig_metadata: 11 rows where bioproject = "PRJNA909412" and tax_clade = "Cyanobacteriota/Melainabacteria group"

11 rows where bioproject = "PRJNA909412" 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
17468917	17468917	PRJNA909412_P_NODE_1354_length_474_cov_3.135632_g1215_i0	PRJNA909412	1354	474	3.135632	14.86289568	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	617	3.63e-172	NTclustered	gi\|485099151\|ref\|NR_102546.1\|	1170562	g1215	i0	90.208	162.721518987342	480	38	100	6	1	474	1744	1268	Calothrix sp. PCC 6303 strain PCC 6303 23S ribosomal RNA, complete sequence	blastn	77130	617	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
17469009	17469009	PRJNA909412_P_NODE_894_length_591_cov_5.266304_g773_i0	PRJNA909412	894	591	5.266304	31.12385664	Macrochaete lichenoides	1844961	Bacteria	Bacteria	1014	0	NTclustered	gi\|1026355709\|gb\|KU559618.1\|	1521517	g773	i0	97.635	285.622673434856	592	13	100	1	1	591	2128	1537	Macrochaete lichenoides SAG 32.92 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	168803	1014	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete lichenoides
21292623	21292623	PRJNA909412_P_NODE_7837_length_189_cov_2.386667_g7696_i0	PRJNA909412	7837	189	2.386667	4.51080063	Chamaesiphon minutus	1173032	Bacteria	Bacteria	139	1.21e-28	NTclustered	gi\|428015215\|gb\|CP003600.1\|	1173020	g7696	i0	88.696	71.0740740740741	115	12	61	1	2	116	4001242	4001129	Chamaesiphon minutus PCC 6605, complete genome	blastn	13433	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
25116732	25116732	PRJNA909412_P_NODE_1860_length_399_cov_3.094444_g1720_i0	PRJNA909412	1860	399	3.094444	12.34683156	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	544	5.17e-150	NTclustered	gi\|225696248\|gb\|FJ805915.1\|	259957	g1720	i0	91.272	201.238095238095	401	31	99	4	2	399	2622	2223	Uncultured Chroococcidiopsis sp. clone A1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	80294	544	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25475816	25475816	PRJNA909412_P_NODE_7540_length_192_cov_3.849673_g7399_i0	PRJNA909412	7540	192	3.849673	7.39137216	root	1	Root_unresolved	Root_unresolved	355	1.13e-93	NTclustered	gi\|588284496\|gb\|KF951520.1\|	1211	g7399	i0	100	100.75	192	0	100	0	1	192	204	13	Uncultured cyanobacterium clone PS41 16S ribosomal RNA gene, partial sequence	blastn	19344	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
27624865	27624865	PRJNA909412_P_NODE_1404_length_465_cov_3.636150_g1265_i0	PRJNA909412	1404	465	3.63615	16.9080975	Leptolyngbya sp. FACHB-261	2692806	Bacteria	Bacteria	69.3	1.94e-10	NR	WP_190800488.1	2692806	g1265	i0	43.8	1.24516129032258	89	50	57.4	0	310	44	304	392	WP_190800488.1 N-acetylmuramoyl-L-alanine amidase [Leptolyngbya sp. FACHB-261]	diamond	579	69.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-261
27727292	27727292	PRJNA909412_P_NODE_6484_length_206_cov_1.958084_g6343_i0	PRJNA909412	6484	206	1.958084	4.03365304	root	1	Root_unresolved	Root_unresolved	60.1	1.18e-8	NR	WP_225895220.1	1552121	g6343	i0	64.4	1.38349514563107	45	16	65.5	0	140	6	128	172	WP_225895220.1 CAP domain-containing protein [Leptolyngbya sp. NIES-2104]	diamond	285	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-2104
28382486	28382486	PRJNA909412_P_NODE_13546_length_160_cov_2.066116_g13405_i0	PRJNA909412	13546	160	2.066116	3.3057856	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	57	1.12e-7	NR	MBC7542495.1	2762020	g13405	i0	65.1	0.80625	43	15	80.6	0	132	4	247	289	MBC7542495.1 DUF2252 family protein [Candidatus Sericytochromatia bacterium]	diamond	129	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
28389881	28389881	PRJNA909412_P_NODE_12066_length_164_cov_1.664000_g11925_i0	PRJNA909412	12066	164	1.664	2.72896	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	70.1	1.6e-13	NR	WP_226578900.1	467598	g11925	i0	66.7	6.01829268292683	48	12	80.5	2	163	32	92	139	WP_226578900.1 CAP family protein [Microseira wollei]	diamond	987	70.5	0.994326241134752	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Microseira	Microseira wollei
30182378	30182378	PRJNA909412_P_NODE_14912_length_155_cov_3.405172_g14771_i0	PRJNA909412	14912	155	3.405172	5.2780166	Cyanobacteria bacterium TGS_CYA1	2835643	Bacteria	Bacteria	41.2	0.0396	NR	MCW5824826.1	2835643	g14771	i0	70.4	0.52258064516129	27	8	52.3	0	2	82	409	435	MCW5824826.1 L-serine ammonia-lyase [Cyanobacteria bacterium TGS_CYA1]	diamond	81	41.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium TGS_CYA1
31762745	31762745	PRJNA909412_P_NODE_14957_length_155_cov_2.922414_g14816_i0	PRJNA909412	14957	155	2.922414	4.5297417	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	41.6	0.0288	NR	HEY9878470.1	3088178	g14816	i0	83.3	0.464516129032258	24	4	46.5	0	80	9	55	78	HEY9878470.1 aldo/keto reductase [Leptolyngbyaceae cyanobacterium]	diamond	72	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium

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