metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA839281" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA839281" and tax_phylum = "Cyanobacteriota"

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
829790	829790	PRJNA839281_S_NODE_30581_length_165_cov_0.879310_g30312_i0	PRJNA839281	30581	165	0.87931	1.4508615	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g30312	i0	100	2	165	0	100	0	1	165	4581901	4581737	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	330	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
3380639	3380639	PRJNA839281_S_NODE_33903_length_163_cov_0.894737_g33634_i0	PRJNA839281	33903	163	0.894737	1.45842131	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	143	7.839999999999999e-30	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g33634	i0	82.609	0.987730061349693	161	28	99	0	1	161	4079504	4079664	Gloeocapsa sp. PCC 7428, complete genome	blastn	161	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
5932899	5932899	PRJNA839281_S_NODE_27385_length_167_cov_0.864407_g27116_i0	PRJNA839281	27385	167	0.864407	1.44355969	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	296	5.86e-76	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g27116	i0	98.795	3.41317365269461	166	2	99	0	1	166	3549527	3549692	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	570	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
7208070	7208070	PRJNA839281_S_NODE_37286_length_161_cov_0.910714_g37017_i0	PRJNA839281	37286	161	0.910714	1.46624954	Anabaena cylindrica	1165	Bacteria	Bacteria	100	4.71e-17	NTclustered	gi\|1210081632\|dbj\|AP018166.1\|	272123	g37017	i0	88.372	2.48447204968944	86	7	52	3	6	88	5945247	5945162	Anabaena cylindrica PCC 7122 DNA, nearly complete genome	blastn	400	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena cylindrica
8482695	8482695	PRJNA839281_S_NODE_38007_length_161_cov_0.910714_g37738_i0	PRJNA839281	38007	161	0.910714	1.46624954	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	270	3.389999999999999e-68	NTclustered	gi\|2245450223\|gb\|CP083762.1\|	155894	g37738	i0	96.894	2	161	5	100	0	1	161	170574	170414	Chroococcidiopsis sp. CCMEE 29 plasmid unnamed, complete sequence	blastn	322	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
13583375	13583375	PRJNA839281_S_NODE_27311_length_167_cov_0.864407_g27042_i0	PRJNA839281	27311	167	0.864407	1.44355969	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	226	7.799999999999999e-55	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g27042	i0	91.018	1	167	15	100	0	1	167	6088648	6088482	Allocoleopsis franciscana PCC 7113, complete genome	blastn	167	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
20356783	20356783	PRJNA839281_S_NODE_35936_length_162_cov_0.902655_g35667_i0	PRJNA839281	35936	162	0.902655	1.4623011	Chroococcidiopsis	54298	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g35667	i0	99.383	2	162	1	100	0	1	162	5727369	5727530	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	324	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
24182054	24182054	PRJNA839281_S_NODE_37479_length_161_cov_0.910714_g37210_i0	PRJNA839281	37479	161	0.910714	1.46624954	Nostoc	1177	Bacteria	Bacteria	191	2.72e-44	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g37210	i0	88.125	2.98136645962733	160	19	99	0	2	161	1298207	1298366	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	480	191	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides

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