metadata: contig_metadata: 4 rows where bioproject = "PRJNA1237888" and tax_clade = "Cyanobacteriota/Melainabacteria group"

4 rows where bioproject = "PRJNA1237888" 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
346546	346546	PRJNA1237888_S_NODE_4261_length_199_cov_1.153333_g4211_i0	PRJNA1237888	4261	199	1.153333	2.29513267	Brasilonema sennae	1397703	Bacteria	Bacteria	307	3.34e-79	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g4211	i0	94.898	237.844221105528	196	10	100	0	4	199	1168618	1168423	Brasilonema sennae CENA114 chromosome	blastn	47331	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
18198350	18198350	PRJNA1237888_S_NODE_3155_length_228_cov_1.469274_g3105_i0	PRJNA1237888	3155	228	1.469274	3.34994472	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	255	1.44e-63	NTclustered	gi\|225696180\|gb\|FJ805847.1\|	259957	g3105	i0	87.111	142.197368421053	225	29	99	0	1	225	2661	2885	Uncultured Chroococcidiopsis sp. clone AU1_6 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32421	255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18198362	18198362	PRJNA1237888_S_NODE_5475_length_177_cov_0.867188_g5425_i0	PRJNA1237888	5475	177	0.867188	1.53492276	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	272	1.0499999999999998e-68	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g5425	i0	94.382	125.129943502825	178	9	100	1	1	177	108	285	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22148	272	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24001846	24001846	PRJNA1237888_S_NODE_7099_length_163_cov_6.070175_g7049_i0	PRJNA1237888	7099	163	6.070175	9.89438525	root	1	Root_unresolved	Root_unresolved	302	1.22e-77	NTclustered	gi\|673537843\|gb\|KM277075.1\|	1211	g7049	i0	100	103.006134969325	163	0	100	0	1	163	411	249	Uncultured cyanobacterium clone T0_1090870 16S ribosomal RNA gene, partial sequence	blastn	16790	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);;