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

5 rows where analysis = "blastn", bioproject = "PRJNA1074408" 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
191007	191007	PRJNA1074408_S_NODE_4781_length_212_cov_1.094675_g4651_i0	PRJNA1074408	4781	212	1.094675	2.320711	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	265	2.2e-66	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g4651	i0	89.252	118.084905660377	214	20	100	3	1	212	3297	3085	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	25034	265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3567159	3567159	PRJNA1074408_S_NODE_9703_length_152_cov_1.321101_g9573_i0	PRJNA1074408	9703	152	1.321101	2.00807352	root	1	Root_unresolved	Root_unresolved	281	1.46e-71	NTclustered	gi\|588284496\|gb\|KF951520.1\|	1211	g9573	i0	100	100.631578947368	152	0	100	0	1	152	261	412	Uncultured cyanobacterium clone PS41 16S ribosomal RNA gene, partial sequence	blastn	15296	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6568918	6568918	PRJNA1074408_S_NODE_4906_length_209_cov_1.445783_g4776_i0	PRJNA1074408	4906	209	1.445783	3.02168647	Cyanobium gracile	59930	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|427344508\|gb\|CP003495.1\|	292564	g4776	i0	96.875	0.287081339712919	32	1	15	0	55	86	585539	585570	Cyanobium gracile PCC 6307, complete genome	blastn	60	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
18042733	18042733	PRJNA1074408_S_NODE_9695_length_152_cov_1.697248_g9565_i0	PRJNA1074408	9695	152	1.697248	2.57981696	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	165	1.5300000000000002e-36	NTclustered	gi\|1280084618\|gb\|MF574180.1\|	119533	g9565	i0	86.275	283.243421052632	153	19	100	2	1	152	2174	2023	Scytonema hyalinum rrn type 1 operon and 16S ribosomal RNA gene, partial sequence; 16S-23S internal transcribed spacer, 23S ribosomal RNA gene, and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	43053	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
18868119	18868119	PRJNA1074408_S_NODE_8315_length_163_cov_1.600000_g8185_i0	PRJNA1074408	8315	163	1.6	2.608	root	1	Root_unresolved	Root_unresolved	302	1.22e-77	NTclustered	gi\|344944308\|gb\|JN106378.1\|	1211	g8185	i0	100	104.006134969325	163	0	100	0	1	163	189	351	Uncultured cyanobacterium clone ASG3 16S ribosomal RNA gene, partial sequence	blastn	16953	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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