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

6 rows where analysis = "blastn", bioproject = "PRJNA675638" 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
5752144	5752144	PRJNA675638_P_NODE_6705_length_265_cov_1.379630_g6508_i0	PRJNA675638	6705	265	1.37963	3.6560195	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g6508	i0	100	0.105660377358491	28	0	11	0	227	254	1687046	1687073	Synechococcus sp. CB0101 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
13402552	13402552	PRJNA675638_P_NODE_13111_length_197_cov_1.378378_g12914_i0	PRJNA675638	13111	197	1.378378	2.71540466	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	322	1.18e-83	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g12914	i0	96.875	119.309644670051	192	6	97	0	1	192	1913	2104	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	23504	322	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15951306	15951306	PRJNA675638_S_NODE_4873_length_204_cov_0.980645_g4811_i0	PRJNA675638	4873	204	0.980645	2.0005158	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	355	1.21e-93	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g4811	i0	98.039	117.490196078431	204	4	100	0	1	204	2810	2607	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23968	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17746771	17746771	PRJNA675638_P_NODE_14554_length_188_cov_1.323741_g14357_i0	PRJNA675638	14554	188	1.323741	2.48863308	Chroococcaceae	1890464	Bacteria	Bacteria	326	8.6e-85	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g14357	i0	97.872	112.627659574468	188	4	100	0	1	188	1197	1010	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	21174	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
19775414	19775414	PRJNA675638_S_NODE_4976_length_202_cov_1.104575_g4914_i0	PRJNA675638	4976	202	1.104575	2.2312415	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	313	7.31e-81	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g4914	i0	94.581	140.871287128713	203	10	100	1	1	202	794851	794649	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	28456	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
24874704	24874704	PRJNA675638_S_NODE_8060_length_165_cov_1.655172_g7998_i0	PRJNA675638	8060	165	1.655172	2.7310338	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g7998	i0	100	0.16969696969697	28	0	17	0	11	38	1687073	1687046	Synechococcus sp. CB0101 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101

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