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

13 rows where analysis = "blastn", bioproject = "PRJNA283169" 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
2334237	2334237	PRJNA283169_S_NODE_302_length_452_cov_0.223325_g288_i0	PRJNA283169	302	452	0.223325	1.009429	root	1	Root_unresolved	Root_unresolved	804	0	NTclustered	gi\|166164465\|gb\|EU240730.1\|	1211	g288	i0	99.546	103.389380530973	441	2	98	0	1	441	290	730	Uncultured cyanobacterium clone CYN-2-4 16S ribosomal RNA gene, partial sequence	blastn	46732	809	0.993819530284302	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5475202	5475202	PRJNA283169_P_NODE_6865_length_167_cov_0.864407_g6802_i0	PRJNA283169	6865	167	0.864407	1.44355969	Woronichinia naegeliana	283820	Bacteria	Bacteria	281	1.64e-71	NTclustered	gi\|2307062866\|gb\|CP073041.1\|	2824559	g6802	i0	97.006	1	167	5	100	0	1	167	5275967	5275801	MAG: Woronichinia naegeliana WA131 chromosome, complete genome	blastn	167	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
6749513	6749513	PRJNA283169_S_NODE_1266_length_241_cov_0.239583_g1252_i0	PRJNA283169	1266	241	0.239583	0.57739503	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	302	1.95e-77	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g1252	i0	89.344	129.240663900415	244	21	100	3	1	241	2505	2264	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31147	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
9299900	9299900	PRJNA283169_S_NODE_588_length_332_cov_0.159011_g574_i0	PRJNA283169	588	332	0.159011	0.52791652	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	603	6.889999999999997e-168	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g574	i0	99.398	121.192771084337	332	2	100	0	1	332	510	179	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	40236	603	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15086617	15086617	PRJNA283169_S_NODE_2972_length_169_cov_0.125000_g2958_i0	PRJNA283169	2972	169	0.125	0.21125	Bacteria	2	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|199584189\|gb\|FJ028681.1\|	1211	g2958	i0	100	99.9704142011834	169	0	100	0	1	169	617	449	Uncultured cyanobacterium clone SSB-11 16S ribosomal RNA gene, partial sequence	blastn	16895	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15674539	15674539	PRJNA283169_S_NODE_733_length_301_cov_0.174603_g719_i0	PRJNA283169	733	301	0.174603	0.52555503	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	366	8.81e-97	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g719	i0	89.655	168.65780730897	290	26	96	4	13	301	4389758	4390044	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	50766	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
16949139	16949139	PRJNA283169_P_NODE_3274_length_229_cov_1.388889_g3211_i0	PRJNA283169	3274	229	1.388889	3.18055581	Woronichinia naegeliana	283820	Bacteria	Bacteria	370	4.97e-98	NTclustered	gi\|2307062866\|gb\|CP073041.1\|	2824559	g3211	i0	97.248	48.0698689956332	218	6	97	0	12	229	41236	41019	MAG: Woronichinia naegeliana WA131 chromosome, complete genome	blastn	11008	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
17636618	17636618	PRJNA283169_P_NODE_1194_length_361_cov_3.391026_g1132_i0	PRJNA283169	1194	361	3.391026	12.24160386	Cyanophyceae	3028117	Bacteria	Bacteria	165	4.21e-36	NTclustered	gi\|1992526127\|gb\|CP070366.1\|	2811482	g1132	i0	85.625	90.8781163434903	160	19	44	4	204	361	4261257	4261100	Thermoleptolyngbya sp. PKUAC-SCTB121 chromosome, complete genome	blastn	32807	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya sp. PKUAC-SCTB121
20185045	20185045	PRJNA283169_P_NODE_2756_length_249_cov_2.155000_g2693_i0	PRJNA283169	2756	249	2.155	5.36595	Prochlorococcus	1218	Bacteria	Bacteria	180	9.91e-41	NTclustered	gi\|154949252\|gb\|CP000095.2\|	59920	g2693	i0	85.227	220.835341365462	176	24	70	2	57	231	374568	374742	Prochlorococcus marinus str. NATL2A, complete genome	blastn	54988	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
20773239	20773239	PRJNA283169_P_NODE_2037_length_286_cov_1.894515_g1975_i0	PRJNA283169	2037	286	1.894515	5.4183129	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	217	8.859999999999999e-52	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g1975	i0	83.065	35.9090909090909	248	32	85	10	9	251	4828971	4829213	Leptolyngbya sp. 7M chromosome	blastn	10270	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
20773318	20773318	PRJNA283169_S_NODE_1777_length_209_cov_0.062500_g1763_i0	PRJNA283169	1777	209	0.0625	0.130625	Woronichinia naegeliana	283820	Bacteria	Bacteria	375	9.57e-100	NTclustered	gi\|2307062866\|gb\|CP073041.1\|	2824559	g1763	i0	99.043	41.7751196172249	209	2	100	0	1	209	40898	41106	MAG: Woronichinia naegeliana WA131 chromosome, complete genome	blastn	8731	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
22048304	22048304	PRJNA283169_S_NODE_1078_length_256_cov_0.183575_g1064_i0	PRJNA283169	1078	256	0.183575	0.469952	Woronichinia naegeliana	283820	Bacteria	Bacteria	418	1.9899999999999994e-112	NTclustered	gi\|2307062866\|gb\|CP073041.1\|	2824559	g1064	i0	96.094	139.9375	256	10	100	0	1	256	3380992	3381247	MAG: Woronichinia naegeliana WA131 chromosome, complete genome	blastn	35824	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
24597856	24597856	PRJNA283169_P_NODE_1820_length_303_cov_1.192913_g1758_i0	PRJNA283169	1820	303	1.192913	3.61452639	Moorena producens	1155739	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1082408432\|gb\|CP017599.1\|	1458985	g1758	i0	100	0.0924092409240924	28	0	9	0	110	137	3756954	3756927	Moorena producens PAL-8-15-08-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens

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