metadata: contig_metadata: 9 rows where bioproject = "PRJNA964500" and tax_clade = "Cyanobacteriota/Melainabacteria group"

9 rows where bioproject = "PRJNA964500" 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
3492555	3492555	PRJNA964500_S_NODE_8583_length_199_cov_3.000000_g8491_i0	PRJNA964500	8583	199	3	5.97	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	339	1.18e-88	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g8491	i0	100	138.005025125628	183	0	92	0	13	195	3119	2937	Uncultured Chroococcidiopsis sp. clone A1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27463	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4770178	4770178	PRJNA964500_S_NODE_6344_length_225_cov_5.255102_g6252_i0	PRJNA964500	6344	225	5.255102	11.8239795	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	359	1.0499999999999999e-94	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g6252	i0	96.33	92.9333333333333	218	8	97	0	8	225	3058	2841	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	20910	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7319906	7319906	PRJNA964500_S_NODE_1766_length_362_cov_9.123123_g1674_i0	PRJNA964500	1766	362	9.123123	33.02570526	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	558	1.66e-154	NTclustered	gi\|225696177\|gb\|FJ805844.1\|	259957	g1674	i0	94.505	147.176795580111	364	16	99	3	1	361	2549	2187	Uncultured Chroococcidiopsis sp. clone AU1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	53278	558	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7643451	7643451	PRJNA964500_S_NODE_10466_length_183_cov_35.805195_g10374_i0	PRJNA964500	10466	183	35.805195	65.52350685	Cyanophyceae	3028117	Bacteria	Bacteria	327	2.31e-85	NTclustered	gi\|192337896\|gb\|EU751505.1\|	1211	g10374	i0	98.907	112	183	2	100	0	1	183	430	248	Uncultured cyanobacterium clone HK05-A05 16S ribosomal RNA gene, partial sequence	blastn	20496	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14019277	14019277	PRJNA964500_S_NODE_2791_length_308_cov_33947.057348_g2699_i0	PRJNA964500	2791	308	33947.057348	104556.93663184	Bacteria	2	Bacteria	Bacteria	449	8.73e-122	NTclustered	gi\|94429069\|gb\|DQ471920.1\|	1211	g2699	i0	98.062	83.6428571428571	258	5	84	0	1	258	362	619	Uncultured cyanobacterium clone otu10 16S small subunit ribosomal RNA gene, partial sequence	blastn	25762	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15293443	15293443	PRJNA964500_S_NODE_2792_length_308_cov_33927.512545_g2700_i0	PRJNA964500	2792	308	33927.512545	104496.7386386	Chroococcidiopsis	54298	Bacteria	Bacteria	472	1.86e-128	NTclustered	gi\|55669005\|gb\|AY790400.1\|	1211	g2700	i0	99.612	83.7694805194805	258	1	84	0	51	308	361	104	Uncultured cyanobacterium clone GLT13 16S ribosomal RNA gene, partial sequence	blastn	25801	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20391775	20391775	PRJNA964500_S_NODE_12156_length_173_cov_3.798611_g12064_i0	PRJNA964500	12156	173	3.798611	6.57159703	Bacteria	2	Bacteria	Bacteria	292	7.87e-75	NTclustered	gi\|199584201\|gb\|FJ028693.1\|	1211	g12064	i0	97.647	98.3410404624277	170	4	98	0	1	170	82	251	Uncultured cyanobacterium clone SSB-71 16S ribosomal RNA gene, partial sequence	blastn	17013	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21343930	21343930	PRJNA964500_S_NODE_2557_length_318_cov_5.878893_g2465_i0	PRJNA964500	2557	318	5.878893	18.69487974	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	442	1.5099999999999994e-119	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g2465	i0	96.296	110.899371069182	270	8	84	2	51	318	3403	3134	Uncultured Chroococcidiopsis sp. clone NA4_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	35266	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23894371	23894371	PRJNA964500_S_NODE_6699_length_220_cov_4.643979_g6607_i0	PRJNA964500	6699	220	4.643979	10.2167538	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	324	3.7399999999999997e-84	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g6607	i0	93.213	181.318181818182	221	14	100	1	1	220	2564	2344	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39890	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010

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