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

8 rows where bioproject = "PRJEB25583" 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
22957	22957	PRJEB25583_P_NODE_2881_length_239_cov_1.564356_g2704_i0	PRJEB25583	2881	239	1.564356	3.73881084	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	342	1.1399999999999999e-89	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g2704	i0	92.531	203.221757322176	241	14	100	4	1	239	1924	1686	Uncultured Chroococcidiopsis sp. clone AR2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48570	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2572901	2572901	PRJEB25583_P_NODE_803_length_539_cov_6.009960_g633_i0	PRJEB25583	803	539	6.00996	32.3936844	Aliterella chasmolithica	2739056	Bacteria	Bacteria	741	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g633	i0	92.19	119.734693877551	525	39	97	2	1	524	2485	1962	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	64537	741	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
7675245	7675245	PRJEB25583_P_NODE_1547_length_346_cov_4.757282_g1370_i0	PRJEB25583	1547	346	4.757282	16.46019572	Macrochaete lichenoides	1844961	Bacteria	Bacteria	508	1.62e-139	NTclustered	gi\|1026355709\|gb\|KU559618.1\|	1521517	g1370	i0	93.333	271.43063583815	345	21	99	2	3	346	2129	1786	Macrochaete lichenoides SAG 32.92 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	93915	508	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete lichenoides
12776585	12776585	PRJEB25583_P_NODE_731_length_574_cov_7.677840_g562_i0	PRJEB25583	731	574	7.67784	44.0708016	Calothrix sp. NIES-4101	2005461	Bacteria	Bacteria	845	0	NTclustered	gi\|1210217881\|dbj\|AP018280.1\|	2005461	g562	i0	93.217	278.935540069686	575	37	100	2	1	574	1243485	1242912	Calothrix sp. NIES-4101 DNA, complete genome	blastn	160109	845	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-4101
24248799	24248799	PRJEB25583_P_NODE_1700_length_327_cov_4.627586_g1523_i0	PRJEB25583	1700	327	4.627586	15.13220622	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	560	4.13e-155	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g1523	i0	97.561	126.34250764526	328	6	100	2	1	327	346	20	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	41314	560	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
27917501	27917501	PRJEB25583_P_NODE_7425_length_157_cov_0.966667_g7248_i0	PRJEB25583	7425	157	0.966667	1.51766719	Chroococcidiopsidaceae cyanobacterium CP_BM_ER_R8_30	2801879	Bacteria	Bacteria	97.8	8.0699999999999994e-23	NR	MBV9385538.1	2801879	g7248	i0	84.6	2.98089171974522	52	8	99.4	0	156	1	28	79	MBV9385538.1 transposase [Chroococcidiopsidaceae cyanobacterium CP_BM_ER_R8_30]	diamond	468	97.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae		Chroococcidiopsidaceae cyanobacterium CP_BM_ER_R8_30
29843642	29843642	PRJEB25583_P_NODE_7611_length_155_cov_1.957627_g7434_i0	PRJEB25583	7611	155	1.957627	3.03432185	Anabaena sp. UHCC	1167	Bacteria	Bacteria	42	0.0209	NR	WP_168536775.1	2590019	g7434	i0	36.7	1.89677419354839	49	31	94.8	0	6	152	90	138	WP_168536775.1 glycosyltransferase family 9 protein [Anabaena sp. UHCC 0253]	diamond	294	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. UHCC 0253
30033292	30033292	PRJEB25583_P_NODE_2691_length_248_cov_2.018957_g2514_i0	PRJEB25583	2691	248	2.018957	5.00701336	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	102	3.56e-25	NR	WP_009632162.1	927677	g2514	i0	89.7	0.701612903225806	58	6	70.2	0	176	3	1	58	WP_009632162.1 gamma carbonic anhydrase family protein [Synechocystis sp. PCC 7509]	diamond	174	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509

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