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

8 rows where analysis = "blastn", bioproject = "PRJNA939369" 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
3808107	3808107	PRJNA939369_S_NODE_44563_length_267_cov_2.304124_g44146_i0	PRJNA939369	44563	267	2.304124	6.15201108	Synechococcus	1129	Bacteria	Bacteria	479	9.46e-131	NTclustered	gi\|2230632934\|gb\|CP096032.1\|	2936507	g44146	i0	99.245	84.2584269662921	265	2	99	0	3	267	1550632	1550896	Synechococcus sp. A10-1-5-1 chromosome, complete genome	blastn	22497	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. A10-1-5-1
6017514	6017514	PRJNA939369_S_NODE_32285_length_294_cov_2.447964_g31868_i0	PRJNA939369	32285	294	2.447964	7.19701416	Brasilonema sennae	1397703	Bacteria	Bacteria	499	8.099999999999998e-137	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g31868	i0	97.279	275.265306122449	294	8	100	0	1	294	1169018	1169311	Brasilonema sennae CENA114 chromosome	blastn	80928	499	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
11118018	11118018	PRJNA939369_S_NODE_39629_length_277_cov_1.450980_g39212_i0	PRJNA939369	39629	277	1.45098	4.0192146	Pleurocapsa sp. PCC 7327	118163	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|427977893\|gb\|CP003590.1\|	118163	g39212	i0	100	0.108303249097473	30	0	11	0	22	51	3116996	3117025	Pleurocapsa sp. PCC 7327, complete genome	blastn	30	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7327
16217554	16217554	PRJNA939369_S_NODE_72693_length_243_cov_0.870588_g72276_i0	PRJNA939369	72693	243	0.870588	2.11552884	Synechococcus sp. LTW-R	2751170	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|1891299085\|gb\|CP059060.1\|	2751170	g72276	i0	98.765	15.2592592592593	243	3	100	0	1	243	1533269	1533027	Synechococcus sp. LTW-R chromosome, complete genome	blastn	3708	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. LTW-R
19107481	19107481	PRJNA939369_S_NODE_5915_length_510_cov_4.633867_g5498_i0	PRJNA939369	5915	510	4.633867	23.6327217	Wilmottia	1048851	Bacteria	Bacteria	843	0	NTclustered	gi\|1700116479\|gb\|MN158648.1\|	2593982	g5498	i0	97.947	161.954901960784	487	9	95	1	24	510	1900	2385	Wilmottia murrayi ACKU581 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	82597	843	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Wilmottia	Wilmottia murrayi
21316528	21316528	PRJNA939369_S_NODE_557_length_1411_cov_8.402840_g339_i0	PRJNA939369	557	1411	8.40284	118.5640724	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1860	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g339	i0	90.61	156.128277817151	1427	99	100	25	1	1411	3527	2120	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	220297	1860	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21316655	21316655	PRJNA939369_S_NODE_72337_length_243_cov_0.905882_g71920_i0	PRJNA939369	72337	243	0.905882	2.20129326	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	250	7.2399999999999995e-62	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g71920	i0	85.246	4.12345679012346	244	34	100	2	1	243	2654904	2655146	Synechococcus sp. CB0101 chromosome, complete genome	blastn	1002	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
23866855	23866855	PRJNA939369_S_NODE_57979_length_250_cov_0.870056_g57562_i0	PRJNA939369	57979	250	0.870056	2.17514	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	250	7.48e-62	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g57562	i0	87.907	8.212	215	22	85	2	26	238	6373152	6373364	Allocoleopsis franciscana PCC 7113, complete genome	blastn	2053	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana

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