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

13 rows where analysis = "blastn", bioproject = "PRJNA255848" 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
1643416	1643416	PRJNA255848_P_NODE_1522_length_905_cov_13.281542_g416_i3	PRJNA255848	1522	905	13.281542	120.1979551	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1443	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g416	i3	95.48	103.413259668508	907	36	100	4	1	905	2047	2950	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	93589	1443	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1643465	1643465	PRJNA255848_P_NODE_27942_length_188_cov_1.467626_g27624_i0	PRJNA255848	27942	188	1.467626	2.75913688	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	143	9.289999999999999e-30	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g27624	i0	81.921	0.941489361702128	177	24	92	6	16	188	902629	902457	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	177	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5472136	5472136	PRJNA255848_P_NODE_5345_length_479_cov_12.448837_g5030_i0	PRJNA255848	5345	479	12.448837	59.62992923	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	669	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g5030	i0	91.909	213.419624217119	482	33	100	6	1	479	2094	1616	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	102228	669	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6746456	6746456	PRJNA255848_P_NODE_43886_length_163_cov_0.894737_g43568_i0	PRJNA255848	43886	163	0.894737	1.45842131	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	152	1.3e-32	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g43568	i0	84.118	16.1840490797546	170	14	100	10	1	163	2831965	2831802	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	2638	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
10572806	10572806	PRJNA255848_P_NODE_5629_length_465_cov_2.860577_g5313_i0	PRJNA255848	5629	465	2.860577	13.30168305	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	684	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g5313	i0	93.162	113.352688172043	468	28	100	3	1	465	2107	1641	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	52709	684	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11260136	11260136	PRJNA255848_P_NODE_26489_length_193_cov_1.951389_g26171_i0	PRJNA255848	26489	193	1.951389	3.76618077	Cyanophyceae	3028117	Bacteria	Bacteria	351	1.46e-92	NTclustered	gi\|696175750\|gb\|KM112131.1\|	1211	g26171	i0	99.482	99.9170984455959	193	1	100	0	1	193	273	81	Uncultured cyanobacterium clone LJ6_347 16S ribosomal RNA gene, partial sequence	blastn	19284	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11847377	11847377	PRJNA255848_P_NODE_48550_length_154_cov_5.266667_g48232_i0	PRJNA255848	48550	154	5.266667	8.11066718	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	213	5.48e-51	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g48232	i0	93.75	140.707792207792	144	6	94	1	1	144	2607	2747	Uncultured Chroococcidiopsis sp. clone AR2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	21669	213	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13122465	13122465	PRJNA255848_P_NODE_27151_length_191_cov_1.183099_g26833_i0	PRJNA255848	27151	191	1.183099	2.25971909	Thermoleptolyngbya sp. PKUAC-SCTB121	2811482	Bacteria	Bacteria	283	5.35e-72	NTclustered	gi\|1992526127\|gb\|CP070366.1\|	2811482	g26833	i0	94.086	157.680628272251	186	11	98	0	1	186	4262569	4262754	Thermoleptolyngbya sp. PKUAC-SCTB121 chromosome, complete genome	blastn	30117	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya sp. PKUAC-SCTB121
13122581	13122581	PRJNA255848_P_NODE_831_length_1166_cov_11.079678_g416_i1	PRJNA255848	831	1166	11.079678	129.18904548	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1720	0	NTclustered	gi\|225696231\|gb\|FJ805898.1\|	259957	g416	i1	93.35	103.673241852487	1173	63	100	12	1	1166	3324	2160	Uncultured Chroococcidiopsis sp. clone NA3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	120883	1720	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13810494	13810494	PRJNA255848_P_NODE_48231_length_161_cov_0.892857_g47913_i0	PRJNA255848	48231	161	0.892857	1.43749977	Phormidesmis	1005722	Bacteria	Bacteria	252	1.23e-62	NTclustered	gi\|282765193\|gb\|FJ977128.1\|	1211	g47913	i0	95.031	100.080745341615	161	6	100	2	1	161	167	9	Uncultured cyanobacterium clone MIS200 16S ribosomal RNA gene, partial sequence	blastn	16113	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16946087	16946087	PRJNA255848_P_NODE_834_length_1165_cov_10.918459_g416_i2	PRJNA255848	834	1165	10.918459	127.20004735	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1655	0	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g416	i2	92.393	103.545064377682	1170	76	100	12	1	1165	2044	3205	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	120630	1655	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18908501	18908501	PRJNA255848_P_NODE_535_length_1389_cov_10.300746_g416_i0	PRJNA255848	535	1389	10.300746	143.07736194	Chroococcidiopsis	54298	Bacteria	Bacteria	1951	0	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g416	i0	92.894	103.343412526998	1351	83	97	10	1	1344	2038457	2037113	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	143544	1960	0.995408163265306	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
19494637	19494637	PRJNA255848_P_NODE_44216_length_163_cov_0.894737_g43898_i0	PRJNA255848	44216	163	0.894737	1.45842131	Anabaena azotica	197653	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2894833396\|gb\|CP178454.1\|	3392114	g43898	i0	100	0.177914110429448	29	0	18	0	34	62	167646	167618	Anabaena azotica SJ-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena azotica

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