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

9 rows where bioproject = "PRJNA1068513" 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
4008302	4008302	PRJNA1068513_S_NODE_13144_length_244_cov_0.906433_g13098_i0	PRJNA1068513	13144	244	0.906433	2.21169652	Planktothrix sp. UBA8402	2055759	Bacteria	Bacteria	114	2.16e-28	NR	HAN73253.1	2055759	g13098	i0	70.9	0.971311475409836	79	23	97.1	0	2	238	40	118	HAN73253.1 hypothetical protein [Planktothrix sp. UBA8402]	diamond	237	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp. UBA8402
9109436	9109436	PRJNA1068513_S_NODE_5968_length_373_cov_1.556667_g5922_i0	PRJNA1068513	5968	373	1.556667	5.80636791	Cyanophyceae	3028117	Bacteria	Bacteria	168	1.06e-50	NR	WP_028948841.1	3028117	g5922	i0	75.2	0.844504021447721	105	26	84.5	0	2	316	65	169	WP_028948841.1 MULTISPECIES: peptidylprolyl isomerase [Cyanophyceae]	diamond	315	168	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
16758737	16758737	PRJNA1068513_S_NODE_1234_length_652_cov_3.880829_g1194_i0	PRJNA1068513	1234	652	3.880829	25.30300508	cyanobacterium endosymbiont of Epithemia clementina EcSB	3034674	Bacteria	Bacteria	54.7	0.018	NTclustered	gi\|2499392380\|gb\|CP123991.1\|	3034674	g1194	i0	100	0.044478527607362	29	0	4	0	150	178	557534	557506	Cyanobacterium endosymbiont of Epithemia clementina EcSB isolate Gazos Creek chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Epithemia clementina EcSB
20140062	20140062	PRJNA1068513_S_NODE_6776_length_351_cov_1.359712_g6730_i0	PRJNA1068513	6776	351	1.359712	4.77258912	Synechococcales	1890424	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2895565184\|gb\|CP138934.1\|	59925	g6730	i0	100	0.239316239316239	28	0	8	0	205	232	925807	925834	Prochlorococcus marinus str. GP2 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
26592233	26592233	PRJNA1068513_S_NODE_8761_length_306_cov_1.163090_g8715_i0	PRJNA1068513	8761	306	1.16309	3.5590554	Pseudanabaenaceae cyanobacterium bins.68	2971806	Bacteria	Bacteria	45.4	0.00829	NR	MDX1978247.1	2971806	g8715	i0	28.4	0.931372549019608	95	66	93.1	2	15	299	90	182	MDX1978247.1 hypothetical protein [Pseudanabaenaceae cyanobacterium bins.68]	diamond	285	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae		Pseudanabaenaceae cyanobacterium bins.68
29624657	29624657	PRJNA1068513_S_NODE_3770_length_459_cov_1.212435_g3725_i0	PRJNA1068513	3770	459	1.212435	5.56507665	Planktothricoides raciborskii	132608	Bacteria	Bacteria	47.8	0.00564	NR	WP_190880611.1	132608	g3725	i0	39.5	0.529411764705882	81	40	51	3	62	295	405	479	WP_190880611.1 C1 family peptidase [Planktothricoides raciborskii]	diamond	243	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
29901042	29901042	PRJNA1068513_S_NODE_13311_length_242_cov_1.514793_g13265_i0	PRJNA1068513	13311	242	1.514793	3.66579906	Nostoc	1177	Bacteria	Bacteria	50.8	3.09e-5	NR	WP_265273728.1	457945	g13265	i0	49.3	1.64876033057851	67	31	81.8	3	42	239	130	194	WP_265273728.1 alpha/beta hydrolase [Nostoc sp. KVJ3]	diamond	399	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. KVJ3
31386245	31386245	PRJNA1068513_S_NODE_8596_length_308_cov_3.638298_g8550_i0	PRJNA1068513	8596	308	3.638298	11.20595784	Nostoc	1177	Bacteria	Bacteria	82	3.25e-16	NR	WP_335059352.1	1180	g8550	i0	64.9	3.33116883116883	57	20	55.5	0	3	173	218	274	WP_335059352.1 pyrroline-5-carboxylate reductase [Nostoc sp.]	diamond	1026	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
31986967	31986967	PRJNA1068513_S_NODE_6358_length_362_cov_2.854671_g6312_i0	PRJNA1068513	6358	362	2.854671	10.33390902	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	48.9	5.64e-4	NR	MFH7026731.1	1735366	g6312	i0	46.3	1.48342541436464	41	22	34	0	3	125	145	185	MFH7026731.1 CAP domain-containing protein [Heteroscytonema crispum UTEX LB 1556]	diamond	537	49.3	0.991886409736308	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Heteroscytonemataceae	Heteroscytonema	Heteroscytonema crispum

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