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

7 rows where analysis = "blastn", bioproject = "PRJNA565778" 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
4963909	4963909	PRJNA565778_S_NODE_3604_length_531_cov_42.554656_g3404_i0	PRJNA565778	3604	531	42.554656	225.96522336	Oculatella	1240886	Bacteria	Bacteria	608	2.469999999999999e-169	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g3404	i0	89.047	183.047080979284	493	51	93	3	3	494	491	1	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	97198	608	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
7513594	7513594	PRJNA565778_S_NODE_17806_length_262_cov_3.693333_g17510_i0	PRJNA565778	17806	262	3.693333	9.67653246	Limnospira	2596745	Bacteria	Bacteria	318	2.1299999999999995e-82	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g17510	i0	95.96	110.770992366412	198	4	85	4	45	240	812262	812457	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	29022	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
8211241	8211241	PRJNA565778_S_NODE_22847_length_231_cov_220.000000_g22551_i0	PRJNA565778	22847	231	220	508.2	uncultured Prochlorococcus sp.	159733	Bacteria	Bacteria	73.1	1.58e-8	NTclustered	gi\|317408359\|gb\|HQ849924.1\|	159733	g22551	i0	95.556	30.6320346320346	45	2	19	0	160	204	256	212	Uncultured Prochlorococcus sp. clone TS_1_DCM_31 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	7076	73.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	uncultured Prochlorococcus sp.
13889734	13889734	PRJNA565778_S_NODE_14851_length_286_cov_7.983936_g14555_i0	PRJNA565778	14851	286	7.983936	22.83405696	Oscillatoriales	1150	Bacteria	Bacteria	348	3.0100000000000004e-91	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g14555	i0	92.245	3.42657342657343	245	19	86	0	9	253	1536881	1537125	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	980	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
14586936	14586936	PRJNA565778_S_NODE_15992_length_276_cov_106.188285_g15696_i0	PRJNA565778	15992	276	106.188285	293.0796666	Aliterella chasmolithica	2739056	Bacteria	Bacteria	374	4.769999999999998e-99	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g15696	i0	94.606	104.876811594203	241	13	87	0	36	276	1965	2205	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	28946	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
15163939	15163939	PRJNA565778_S_NODE_3552_length_533_cov_62.308468_g3353_i0	PRJNA565778	3552	533	62.308468	332.10413444	Microcoleus	44471	Bacteria	Bacteria	863	0	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g3353	i0	98.371	149.774859287054	491	8	92	0	37	527	133467	132977	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	79830	863	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
15860773	15860773	PRJNA565778_S_NODE_15893_length_277_cov_117.025000_g15597_i0	PRJNA565778	15893	277	117.025	324.15925	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	351	2.24e-92	NTclustered	gi\|225696259\|gb\|FJ805926.1\|	259957	g15597	i0	92.975	109.231046931408	242	16	87	1	37	277	1698	1939	Uncultured Chroococcidiopsis sp. clone AS3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30257	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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