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

10 rows where analysis = "blastn", bioproject = "PRJNA1016321" 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
1002726	1002726	PRJNA1016321_P_NODE_16761_length_475_cov_4.527363_g16531_i0	PRJNA1016321	16761	475	4.527363	21.50497425	Oscillatoriales	1150	Bacteria	Bacteria	817	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g16531	i0	98.911	172.061052631579	459	1	96	3	19	473	812400	812858	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	81729	817	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
3553317	3553317	PRJNA1016321_P_NODE_46323_length_255_cov_4.714286_g46092_i0	PRJNA1016321	46323	255	4.714286	12.0214293	Planktothrix	54304	Bacteria	Bacteria	446	9.1e-121	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g46092	i0	100	156.294117647059	241	0	95	0	1	241	622252	622012	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	39855	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
8655915	8655915	PRJNA1016321_P_NODE_44607_length_262_cov_1.529101_g44376_i0	PRJNA1016321	44607	262	1.529101	4.00624462	root	1	Root_unresolved	Root_unresolved	472	1.55e-128	NTclustered	gi\|1241187607\|dbj\|LC319764.1\|	1160	g44376	i0	100	109.007633587786	255	0	97	0	1	255	762	508	Planktothrix agardhii gene for 16S ribosomal RNA, partial sequence, strain: NIES-1265	blastn	28560	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
9930847	9930847	PRJNA1016321_P_NODE_57728_length_226_cov_2.013072_g57497_i0	PRJNA1016321	57728	226	2.013072	4.54954272	Nostoc	1177	Bacteria	Bacteria	196	8.78e-46	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g57497	i0	83.105	7.86283185840708	219	33	96	2	1	217	5553524	5553740	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	1777	196	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
11206007	11206007	PRJNA1016321_P_NODE_38029_length_288_cov_1.772093_g37798_i0	PRJNA1016321	38029	288	1.772093	5.10362784	Planktothrix	54304	Bacteria	Bacteria	514	2.83e-141	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g37798	i0	99.645	173.493055555556	282	0	98	1	8	288	623231	622950	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	49966	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
14188682	14188682	PRJNA1016321_P_NODE_7052_length_768_cov_4.617266_g6853_i0	PRJNA1016321	7052	768	4.617266	35.46060288	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	1147	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g6853	i0	94.071	198.950520833333	759	40	99	5	12	768	9969837	9969082	Calothrix sp. PCC 7716 DNA, complete genome	blastn	152794	1147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
19285394	19285394	PRJNA1016321_P_NODE_41556_length_274_cov_1.144279_g41325_i0	PRJNA1016321	41556	274	1.144279	3.13532446	Stanieria cyanosphaera	102116	Bacteria	Bacteria	451	2.12e-122	NTclustered	gi\|428272017\|gb\|CP003654.1\|	111780	g41325	i0	96.35	1	274	10	100	0	1	274	208304	208577	Stanieria cyanosphaera PCC 7437 plasmid pSTA7437.01, complete sequence	blastn	274	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
20129107	20129107	PRJNA1016321_P_NODE_21336_length_410_cov_2.231454_g21105_i0	PRJNA1016321	21336	410	2.231454	9.1489614	Chroococcidiopsis	54298	Bacteria	Bacteria	728	0	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g21105	i0	99.748	132.375609756098	397	1	97	0	1	397	2947	3343	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	54274	728	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
21835985	21835985	PRJNA1016321_P_NODE_13138_length_546_cov_3.976744_g12915_i0	PRJNA1016321	13138	546	3.976744	21.71302224	Dulcicalothrix desertica	32056	Bacteria	Bacteria	773	0	NTclustered	gi\|283766156\|gb\|GQ980023.1\|	232991	g12915	i0	92.91	204.531135531136	536	30	98	6	1	535	9	537	Calothrix desertica PCC 7102 23S large subunit ribosomal RNA (rrnL) gene, partial sequence	blastn	111674	773	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
24385691	24385691	PRJNA1016321_P_NODE_3620_length_1064_cov_5.580222_g3470_i0	PRJNA1016321	3620	1064	5.580222	59.37356208	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	1622	0	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g3470	i0	95.068	214.332706766917	1034	46	97	5	22	1051	3670366	3669334	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	228050	1622	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1

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