metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA721440" and tax_clade = "Cyanobacteriota/Melainabacteria group"

8 rows where analysis = "blastn", bioproject = "PRJNA721440" 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
3745379	3745379	PRJNA721440_S_NODE_17803_length_167_cov_0.881356_g17677_i0	PRJNA721440	17803	167	0.881356	1.47186452	Nostocales	1161	Bacteria	Bacteria	174	2.87e-39	NTclustered	gi\|1210177014\|dbj\|AP018248.1\|	231146	g17677	i0	88.732	224.916167664671	142	16	85	0	1	142	1645247	1645106	Tolypothrix tenuis PCC 7101 DNA, nearly complete genome	blastn	37561	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix tenuis
7088946	7088946	PRJNA721440_S_NODE_6006_length_247_cov_2.424242_g5880_i0	PRJNA721440	6006	247	2.424242	5.98787774	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	346	9.14e-91	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g5880	i0	92.887	172.919028340081	239	16	97	1	1	239	2455	2692	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	42711	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8363482	8363482	PRJNA721440_S_NODE_6547_length_239_cov_3.373684_g6421_i0	PRJNA721440	6547	239	3.373684	8.06310476	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g6421	i0	100	120.351464435146	239	0	100	0	1	239	3718	3480	Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28764	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10914192	10914192	PRJNA721440_S_NODE_529_length_686_cov_11.480377_g432_i0	PRJNA721440	529	686	11.480377	78.75538622	Stanieria cyanosphaera	102116	Bacteria	Bacteria	329	2.82e-85	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g432	i0	79.61	26.731778425656	461	92	67	2	12	471	426	885	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	18338	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
17288202	17288202	PRJNA721440_S_NODE_5494_length_256_cov_4.251208_g5368_i0	PRJNA721440	5494	256	4.251208	10.88309248	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	459	1.1699999999999999e-124	NTclustered	gi\|225696216\|gb\|FJ805883.1\|	259957	g5368	i0	99.213	132.08984375	254	2	99	0	1	254	2605	2858	Uncultured Chroococcidiopsis sp. clone NA4_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33815	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19837088	19837088	PRJNA721440_S_NODE_18596_length_165_cov_0.991379_g18470_i0	PRJNA721440	18596	165	0.991379	1.63577535	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	248	1.64e-61	NTclustered	gi\|225696257\|gb\|FJ805924.1\|	259957	g18470	i0	93.939	105.50303030303	165	8	99	1	3	165	3356	3520	Uncultured Chroococcidiopsis sp. clone AS2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17408	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21112744	21112744	PRJNA721440_S_NODE_1517_length_435_cov_5.173575_g1391_i0	PRJNA721440	1517	435	5.173575	22.50505125	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	638	2.54e-178	NTclustered	gi\|225696250\|gb\|FJ805917.1\|	259957	g1391	i0	93.034	115.758620689655	445	18	100	11	1	435	1811	2252	Uncultured Chroococcidiopsis sp. clone A1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	50355	638	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25420213	25420213	PRJNA721440_S_NODE_7440_length_228_cov_4.351955_g7314_i0	PRJNA721440	7440	228	4.351955	9.9224574	root	1	Root_unresolved	Root_unresolved	416	6.259999999999998e-112	NTclustered	gi\|242254648\|gb\|FJ844174.1\|	1211	g7314	i0	99.561	185	228	1	100	0	1	228	326	99	Uncultured cyanobacterium clone Cy09-12 16S ribosomal RNA gene, partial sequence	blastn	42180	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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