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

8 rows where analysis = "blastn", bioproject = "PRJEB75230" 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
3546748	3546748	PRJEB75230_P_NODE_55803_length_304_cov_2.082251_g55621_i0	PRJEB75230	55803	304	2.082251	6.33004304	root	1	Root_unresolved	Root_unresolved	499	8.419999999999998e-137	NTclustered	gi\|53773351\|gb\|AY711876.1\|	1211	g55621	i0	97.603	106.710526315789	292	5	96	2	9	299	402	692	Uncultured cyanobacterium clone SIMO-2510 16S ribosomal RNA gene, partial sequence	blastn	32440	499	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5238242	5238242	PRJEB75230_P_NODE_10085_length_469_cov_2.176768_g9903_i0	PRJEB75230	10085	469	2.176768	10.20904192	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	741	0	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g9903	i0	95.494	117.059701492537	466	18	99	2	4	469	2806	2344	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	54901	741	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12890405	12890405	PRJEB75230_P_NODE_18691_length_391_cov_1.223270_g18509_i0	PRJEB75230	18691	391	1.22327	4.7829857	uncultured Pleurocapsales cyanobacterium	183215	Bacteria	Bacteria	691	0	NTclustered	gi\|745734118\|gb\|KM458372.1\|	183215	g18509	i0	99.735	102.506393861893	377	1	96	0	15	391	1	377	Uncultured Pleurocapsales cyanobacterium isolate OTU 00115 23S ribosomal RNA gene, partial sequence	blastn	40080	691	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			uncultured Pleurocapsales cyanobacterium
16714423	16714423	PRJEB75230_P_NODE_79374_length_280_cov_1.463768_g79192_i0	PRJEB75230	79374	280	1.463768	4.0985504	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	453	6.05e-123	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g79192	i0	95.76	124.714285714286	283	9	100	1	1	280	2177	2459	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34920	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17987406	17987406	PRJEB75230_P_NODE_111055_length_255_cov_1.692308_g110873_i0	PRJEB75230	111055	255	1.692308	4.3153854	cyanobacterium endosymbiont of Epithemia turgida	718217	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|667665922\|dbj\|AP012549.1\|	1228987	g110873	i0	94.118	0.133333333333333	34	2	13	0	173	206	149436	149403	Cyanobacterium endosymbiont of Epithemia turgida isolate EtSB Lake Yunoko DNA, complete genome	blastn	34	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Epithemia turgida
17989507	17989507	PRJEB75230_P_NODE_89815_length_271_cov_2.282828_g89633_i0	PRJEB75230	89815	271	2.282828	6.18646388	Prochlorococcus sp. MIT 1011	3082520	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2895599930\|gb\|CP138983.1\|	3082520	g89633	i0	100	0.103321033210332	28	0	10	0	182	209	505927	505954	Prochlorococcus sp. MIT 1011 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 1011
19263273	19263273	PRJEB75230_P_NODE_75676_length_283_cov_2.195238_g75494_i0	PRJEB75230	75676	283	2.195238	6.21252354	Aliterella chasmolithica	2739056	Bacteria	Bacteria	385	2.27e-102	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g75494	i0	91.459	114.367491166078	281	22	99	2	4	283	2267	1988	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32366	385	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
21813283	21813283	PRJEB75230_P_NODE_161078_length_244_cov_0.900585_g160896_i0	PRJEB75230	161078	244	0.900585	2.1974274	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	231	2.63e-56	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g160896	i0	83.951	2.95491803278689	243	37	99	2	3	244	4867719	4867478	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	721	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29

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