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

5 rows where analysis = "blastn", bioproject = "PRJNA857143" 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
10163804	10163804	PRJNA857143_S_NODE_121408_length_291_cov_1.431193_g120315_i0	PRJNA857143	121408	291	1.431193	4.16477163	Bacteria	2	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|428688965\|gb\|CP003945.1\|	65093	g120315	i0	96.875	0.814432989690722	32	1	11	0	38	69	881163	881194	Halothece sp. PCC 7418 chromosome, complete genome	blastn	237	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Halothecacae	Halothece	Halothece sp. PCC 7418
11439052	11439052	PRJNA857143_S_NODE_28629_length_472_cov_3.323308_g27537_i0	PRJNA857143	28629	472	3.323308	15.68601376	Limnospira	2596745	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g27537	i0	100	0.296610169491525	28	0	6	0	218	245	1229741	1229714	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	140	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
13597163	13597163	PRJNA857143_S_NODE_159491_length_259_cov_2.494624_g158398_i0	PRJNA857143	159491	259	2.494624	6.46107616	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	329	9.73e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g158398	i0	89.883	113.266409266409	257	24	99	2	1	256	3680557	3680302	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	29336	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
18694279	18694279	PRJNA857143_S_NODE_112075_length_300_cov_1.669604_g110982_i0	PRJNA857143	112075	300	1.669604	5.008812	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	5.13e-114	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g110982	i0	92.053	147.16	302	22	100	2	1	300	3373	3072	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	44148	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18695519	18695519	PRJNA857143_S_NODE_57575_length_378_cov_3.770492_g56482_i0	PRJNA857143	57575	378	3.770492	14.25245976	Calothrix sp. NIES-3974	2005462	Bacteria	Bacteria	76.8	2.14e-9	NTclustered	gi\|1210184319\|dbj\|AP018254.1\|	2005462	g56482	i0	97.727	1.13492063492063	44	1	12	0	2	45	1881927	1881970	Calothrix sp. NIES-3974 DNA, complete genome	blastn	429	76.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-3974

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