metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA473799" and tax_clade = "Cyanobacteriota/Melainabacteria group"

12 rows where analysis = "blastn", bioproject = "PRJNA473799" 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
2996221	2996221	PRJNA473799_P_NODE_2623_length_877_cov_1.860697_g2392_i0	PRJNA473799	2623	877	1.860697	16.31831269	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1279	0	NTclustered	gi\|225696246\|gb\|FJ805913.1\|	259957	g2392	i0	92.963	124.90992018244	881	56	100	6	1	877	2754	1876	Uncultured Chroococcidiopsis sp. clone AN1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	109546	1279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4272627	4272627	PRJNA473799_P_NODE_31484_length_256_cov_1.639344_g31210_i0	PRJNA473799	31484	256	1.639344	4.19672064	Crinalium epipsammum	241425	Bacteria	Bacteria	182	2.84e-41	NTclustered	gi\|428245228\|gb\|CP003620.1\|	1173022	g31210	i0	81.333	3.9140625	225	40	88	2	1	224	1105468	1105691	Crinalium epipsammum PCC 9333, complete genome	blastn	1002	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Crinalium	Crinalium epipsammum
4272776	4272776	PRJNA473799_P_NODE_41304_length_248_cov_0.880000_g41030_i0	PRJNA473799	41304	248	0.88	2.1824	Microcoleus vaginatus	119532	Bacteria	Bacteria	204	5.849999999999999e-48	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g41030	i0	88.372	2.08064516129032	172	16	68	2	80	248	3875293	3875123	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	516	204	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
4923788	4923788	PRJNA473799_P_NODE_22464_length_273_cov_1.685000_g22190_i0	PRJNA473799	22464	273	1.685	4.60005	Cyanophyceae	3028117	Bacteria	Bacteria	453	5.8800000000000006e-123	NTclustered	gi\|521763817\|gb\|KC463683.1\|	1211	g22190	i0	96.703	101.161172161172	273	8	100	1	1	273	495	766	Uncultured cyanobacterium clone BkfYyy_800 16S ribosomal RNA gene, partial sequence	blastn	27617	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6823343	6823343	PRJNA473799_P_NODE_34166_length_251_cov_2.292135_g33892_i0	PRJNA473799	34166	251	2.292135	5.75325885	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g33892	i0	99.203	2	251	2	100	0	1	251	5206801	5206551	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	502	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
9373792	9373792	PRJNA473799_P_NODE_6068_length_475_cov_4.467662_g5799_i0	PRJNA473799	6068	475	4.467662	21.2213945	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	734	0	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g5799	i0	94.526	120.149473684211	475	26	100	0	1	475	2454	2928	Uncultured Chroococcidiopsis sp. clone AR1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	57071	734	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18947071	18947071	PRJNA473799_P_NODE_17495_length_284_cov_0.995261_g17221_i0	PRJNA473799	17495	284	0.995261	2.82654124	Oscillatoriales	1150	Bacteria	Bacteria	481	2.82e-131	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g17221	i0	97.183	5.92253521126761	284	8	100	0	1	284	3070709	3070426	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1682	481	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
20847159	20847159	PRJNA473799_P_NODE_24997_length_268_cov_1.620513_g24723_i0	PRJNA473799	24997	268	1.620513	4.34297484	Microcoleus vaginatus	119532	Bacteria	Bacteria	451	2.07e-122	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g24723	i0	97.015	4	268	8	100	0	1	268	1165038	1165305	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	1072	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
22121977	22121977	PRJNA473799_P_NODE_20878_length_276_cov_2.655172_g20604_i0	PRJNA473799	20878	276	2.655172	7.32827472	Okeanomitos corallinicola	3231550	Bacteria	Bacteria	104	6.91e-18	NTclustered	gi\|2715117499\|gb\|CP150886.1\|	3133117	g20604	i0	91.026	53.0942028985507	78	6	28	1	200	276	475689	475766	Okeanomitos corallinicola TIOX110 chromosome, complete genome	blastn	14654	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Okeanomitos	Okeanomitos corallinicola
22772518	22772518	PRJNA473799_P_NODE_10698_length_322_cov_1.393574_g10424_i0	PRJNA473799	10698	322	1.393574	4.48730828	Cyanophyceae	3028117	Bacteria	Bacteria	285	2.7399999999999997e-72	NTclustered	gi\|1949996095\|gb\|CP046155.1\|	1115757	g10424	i0	90.698	102.767080745342	215	18	67	2	4	217	785623	785410	Leptolyngbya sp. BL0902 chromosome, complete genome	blastn	33091	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL0902
24671742	24671742	PRJNA473799_P_NODE_32740_length_254_cov_1.359116_g32466_i0	PRJNA473799	32740	254	1.359116	3.45215464	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	442	1.1699999999999995e-119	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g32466	i0	98.031	88.6889763779528	254	5	100	0	1	254	4955799	4956052	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	22527	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
24672131	24672131	PRJNA473799_P_NODE_6860_length_427_cov_4.087571_g6588_i0	PRJNA473799	6860	427	4.087571	17.45392817	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	641	1.92e-179	NTclustered	gi\|225696189\|gb\|FJ805856.1\|	259957	g6588	i0	93.735	133.480093676815	431	21	100	5	1	427	3107	3535	Uncultured Chroococcidiopsis sp. clone AR2_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	56996	641	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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