metadata: contig_metadata: 6 rows where bioproject = "PRJNA177642" and tax_clade = "Cyanobacteriota/Melainabacteria group"

6 rows where bioproject = "PRJNA177642" 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
15082637	15082637	PRJNA177642_P_NODE_14712_length_203_cov_3.212644_g13487_i0	PRJNA177642	14712	203	3.212644	6.52166732	Microcystis	1125	Bacteria	Bacteria	366	5.56e-97	NTclustered	gi\|1566846205\|dbj\|LC455583.1\|	1126	g13487	i0	99.505	119.743842364532	202	0	99	1	2	202	200	401	Microcystis aeruginosa NIES-3804 gene for 23S ribosomal RNA, partial sequence	blastn	24308	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
17632769	17632769	PRJNA177642_P_NODE_17734_length_165_cov_4.904412_g16509_i0	PRJNA177642	17734	165	4.904412	8.0922798	Microcystis	1125	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|119352232\|gb\|EF121241.1\|	1126	g16509	i0	100	101	165	0	100	0	1	165	750	586	Microcystis aeruginosa strain SPC 777 16S ribosomal RNA gene, partial sequence	blastn	16665	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
17632792	17632792	PRJNA177642_P_NODE_6234_length_553_cov_3.555344_g5114_i0	PRJNA177642	6234	553	3.555344	19.66105232	Microcystis	1125	Bacteria	Bacteria	1020	0	NTclustered	gi\|1566846220\|dbj\|LC455598.1\|	1126	g5114	i0	100	151.969258589512	552	0	99	0	2	553	1652	1101	Microcystis aeruginosa NIES-3795 gene for 23S ribosomal RNA, partial sequence	blastn	84039	1020	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
23317541	23317541	PRJNA177642_P_NODE_14359_length_213_cov_2.059783_g13134_i0	PRJNA177642	14359	213	2.059783	4.38733779	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	67.8	2.61e-11	NR	MEL7520179.1	3023125	g13134	i0	52.2	0.943661971830986	67	32	94.4	0	208	8	117	183	MEL7520179.1 hypothetical protein [Cyanobacteria bacterium J06553_1]	diamond	201	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
29270494	29270494	PRJNA177642_P_NODE_17929_length_165_cov_1.036765_g16704_i0	PRJNA177642	17929	165	1.036765	1.71066225	Bacteria	2	Bacteria	Bacteria	79.7	1.22e-15	NR	MBS1996879.1	2807731	g16704	i0	65.5	3	55	19	100	0	165	1	198	252	MBS1996879.1 FtsX-like permease family protein [Cyanobacteria bacterium SZAS LIN-2]	diamond	495	79.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-2
29916164	29916164	PRJNA177642_P_NODE_6231_length_554_cov_1.340952_g5111_i0	PRJNA177642	6231	554	1.340952	7.42887408	Coleofasciculus sp. Co-bin14	2768886	Bacteria	Bacteria	73.2	1.24e-11	NR	MBD0344629.1	2768886	g5111	i0	75.6	0.731046931407942	45	11	24.4	0	200	334	243	287	MBD0344629.1 hypothetical protein [Coleofasciculus sp. Co-bin14]	diamond	405	73.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. Co-bin14

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