metadata: contig_metadata: 5 rows where bioproject = "PRJNA733995", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

5 rows where bioproject = "PRJNA733995", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Cyanobacteriota"

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
12196001	12196001	PRJNA733995_P_NODE_7510_length_313_cov_4.458333_g7463_i0	PRJNA733995	7510	313	4.458333	13.95458229	uncultured Tolypothrix sp.	442936	Bacteria	Bacteria	518	2.4e-142	NTclustered	gi\|745734112\|gb\|KM458379.1\|	442936	g7463	i0	96.486	190.900958466454	313	11	100	0	1	313	14	326	Uncultured Tolypothrix sp. isolate OTU 00124 23S ribosomal RNA gene, partial sequence	blastn	59752	518	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	uncultured Tolypothrix sp.
17294675	17294675	PRJNA733995_P_NODE_2514_length_567_cov_1.858300_g2467_i0	PRJNA733995	2514	567	1.8583	10.536561	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	54.7	0.016	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g2467	i0	94.286	0.0617283950617284	35	2	6	0	102	136	5989534	5989500	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	35	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
27062587	27062587	PRJNA733995_P_NODE_2062_length_623_cov_3.594545_g2015_i0	PRJNA733995	2062	623	3.594545	22.39401535	Nostocales	1161	Bacteria	Bacteria	47.8	0.00948	NR	WP_017748227.1	34078	g2015	i0	38.5	5.00802568218299	91	50	41.9	2	366	106	30	118	WP_017748227.1 hypothetical protein [Scytonema hofmannii]	diamond	3120	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema hofmannii
27305384	27305384	PRJNA733995_P_NODE_6123_length_346_cov_1.974359_g6076_i0	PRJNA733995	6123	346	1.974359	6.83128214	Nostoc sp.	1180	Bacteria	Bacteria	53.9	1.13e-6	NR	WP_334733461.1	1180	g6076	i0	55.8	0.710982658959538	43	19	37.3	0	9	137	1	43	WP_334733461.1 tetratricopeptide repeat protein [Nostoc sp.]	diamond	246	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
31664124	31664124	PRJNA733995_P_NODE_6017_length_350_cov_1.111913_g5970_i0	PRJNA733995	6017	350	1.111913	3.8916955	Cyanobacteria bacterium J06555_13	3023131	Bacteria	Bacteria	48.9	8.23e-4	NR	MEN8443588.1	3023131	g5970	i0	50	0.788571428571429	46	23	39.4	0	348	211	376	421	MEN8443588.1 tetratricopeptide repeat protein [Cyanobacteria bacterium J06555_13]	diamond	276	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06555_13

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