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

8 rows where analysis = "blastn", bioproject = "PRJNA795983" 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
4608397	4608397	PRJNA795983_S_NODE_18204_length_317_cov_1.475410_g18079_i0	PRJNA795983	18204	317	1.47541	4.6770497	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	387	7.17e-103	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g18079	i0	88.785	276.889589905363	321	28	100	7	1	317	4390989	4391305	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	87774	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
5044648	5044648	PRJNA795983_S_NODE_25264_length_284_cov_1.454976_g25139_i0	PRJNA795983	25264	284	1.454976	4.1321318399999996	Chroococcidiopsis	54298	Bacteria	Bacteria	357	4.96e-94	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g25139	i0	89.51	148.552816901408	286	24	99	4	1	282	795218	795501	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	42189	357	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5044660	5044660	PRJNA795983_S_NODE_39504_length_245_cov_2.406977_g39379_i0	PRJNA795983	39504	245	2.406977	5.89709365	Gloeocapsopsis	693222	Bacteria	Bacteria	392	1.15e-104	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g39379	i0	99.083	115.930612244898	218	2	89	0	6	223	2928	3145	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28403	392	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
13533830	13533830	PRJNA795983_S_NODE_37171_length_249_cov_0.875000_g37046_i0	PRJNA795983	37171	249	0.875	2.17875	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	355	1.53e-93	NTclustered	gi\|2245130261\|gb\|CP097481.1\|	2653189	g37046	i0	92.369	1	249	19	100	0	1	249	282107	282355	Chroococcidiopsis sp. CCNUC1 plasmid pA, complete sequence	blastn	249	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
13970462	13970462	PRJNA795983_S_NODE_33431_length_257_cov_1.673913_g33306_i0	PRJNA795983	33431	257	1.673913	4.30195641	Chroococcidiopsis	54298	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g33306	i0	100	165.112840466926	257	0	100	0	1	257	810	1066	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	42434	475	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
22457426	22457426	PRJNA795983_S_NODE_42338_length_242_cov_0.911243_g42213_i0	PRJNA795983	42338	242	0.911243	2.20520806	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	353	5.34e-93	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g42213	i0	92.975	1	242	17	100	0	1	242	2431501	2431260	Allocoleopsis franciscana PCC 7113, complete genome	blastn	242	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
23732763	23732763	PRJNA795983_S_NODE_11059_length_375_cov_1.529801_g10934_i0	PRJNA795983	11059	375	1.529801	5.73675375	Cyanobacterium sp. HL-69	2054282	Bacteria	Bacteria	76.8	2.12e-9	NTclustered	gi\|1298149266\|gb\|CP024912.1\|	2054282	g10934	i0	79.646	0.301333333333333	113	18	30	5	162	272	849429	849320	Cyanobacterium sp. HL-69 chromosome, complete genome	blastn	113	76.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium sp. HL-69
23732947	23732947	PRJNA795983_S_NODE_29399_length_270_cov_0.857868_g29274_i0	PRJNA795983	29399	270	0.857868	2.3162436	Nostoc sp. UHCC 0926	3025190	Bacteria	Bacteria	453	5.810000000000001e-123	NTclustered	gi\|2444439127\|gb\|CP117768.1\|	3025190	g29274	i0	97.048	285.862962962963	271	4	99	4	2	270	3627475	3627743	Nostoc sp. UHCC 0926 chromosome, complete genome	blastn	77183	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0926

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