metadata: contig_metadata: 8 rows where bioproject = "PRJNA591000" and tax_clade = "Cyanobacteriota/Melainabacteria group"

8 rows where bioproject = "PRJNA591000" 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
10769213	10769213	PRJNA591000_P_NODE_15549_length_275_cov_5.426829_g13943_i0	PRJNA591000	15549	275	5.426829	14.92377975	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	412	1.0099999999999997e-110	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g13943	i0	94.118	102.392727272727	272	14	99	2	1	271	2852	3122	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	28158	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19691329	19691329	PRJNA591000_P_NODE_696_length_1266_cov_4.590137_g473_i0	PRJNA591000	696	1266	4.590137	58.11113442	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	516	3.82e-141	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g473	i0	93.642	88.2424960505529	346	20	72	2	805	1148	1873	2218	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	111715	516	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
26731119	26731119	PRJNA591000_P_NODE_2001_length_909_cov_4.352273_g1477_i0	PRJNA591000	2001	909	4.352273	39.56216157	Leptolyngbyaceae cyanobacterium UHCC 1019	3126709	Bacteria	Bacteria	184	2.52e-48	NR	MEX0271399.1	3126709	g1477	i0	85	0.372937293729373	113	16	37.3	1	476	814	1040	1151	MEX0271399.1 phage tail tape measure protein [Leptolyngbyaceae cyanobacterium UHCC 1019]	diamond	339	184	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium UHCC 1019
28153745	28153745	PRJNA591000_P_NODE_7265_length_519_cov_1.120408_g5820_i0	PRJNA591000	7265	519	1.120408	5.81491752	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	78.2	2.79e-13	NR	WP_009632951.1	927677	g5820	i0	97.4	0.450867052023121	39	1	22.5	0	517	401	178	216	WP_009632951.1 PhnE/PtxC family ABC transporter permease [Synechocystis sp. PCC 7509]	diamond	234	78.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
30142536	30142536	PRJNA591000_P_NODE_5372_length_633_cov_1.491722_g4232_i0	PRJNA591000	5372	633	1.491722	9.44260026	Oscillatoriales cyanobacterium M59_W2019_021	2774343	Bacteria	Bacteria	61.2	5.96e-7	NR	HIK51512.1	2774343	g4232	i0	72.7	0.156398104265403	33	9	15.6	0	532	630	240	272	HIK51512.1 choice-of-anchor J domain-containing protein [Oscillatoriales cyanobacterium M59_W2019_021]	diamond	99	61.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium M59_W2019_021
31009409	31009409	PRJNA591000_P_NODE_6934_length_533_cov_2.904762_g5527_i0	PRJNA591000	6934	533	2.904762	15.48238146	Nostocales	1161	Bacteria	Bacteria	187	9.39e-52	NR	WP_208342373.1	1550245	g5527	i0	59.5	2.63977485928705	158	60	86.7	1	531	70	345	502	WP_208342373.1 host specificity protein J [Aetokthonos hydrillicola]	diamond	1407	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Aetokthonos	Aetokthonos hydrillicola
31216736	31216736	PRJNA591000_P_NODE_10495_length_437_cov_2.252451_g8921_i0	PRJNA591000	10495	437	2.252451	9.84321087	Anabaena sp. CRKS33	1710888	Bacteria	Bacteria	63.2	2.7e-9	NR	OBQ32603.1	1710888	g8921	i0	71.8	0.267734553775744	39	11	26.8	0	117	1	53	91	OBQ32603.1 MAG: hypothetical protein AN487_22065 [Anabaena sp. CRKS33]	diamond	117	63.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. CRKS33
31565280	31565280	PRJNA591000_P_NODE_15036_length_379_cov_2.131429_g13433_i0	PRJNA591000	15036	379	2.131429	8.07811591	Cyanobacteria bacterium J149	2420335	Bacteria	Bacteria	55.8	3.86e-6	NR	RMD71164.1	2420335	g13433	i0	80.6	0.245382585751979	31	6	24.5	0	286	378	162	192	RMD71164.1 MAG: hypothetical protein D6822_03205, partial [Cyanobacteria bacterium J149]	diamond	93	55.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J149

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