metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA939415" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA939415" 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
1256236	1256236	PRJNA939415_P_NODE_108161_length_214_cov_8.368794_g107739_i0	PRJNA939415	108161	214	8.368794	17.90921916	Nostocales	1161	Bacteria	Bacteria	65.8	2.42e-6	NTclustered	gi\|428256439\|gb\|CP003642.1\|	56107	g107739	i0	97.436	15.1588785046729	39	0	18	1	44	82	6745128	6745091	Cylindrospermum stagnale PCC 7417, complete genome	blastn	3244	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
4743234	4743234	PRJNA939415_P_NODE_111924_length_198_cov_4.192000_g111502_i0	PRJNA939415	111924	198	4.192	8.30016	Moorena producens	1155739	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|1082408432\|gb\|CP017599.1\|	1458985	g111502	i0	100	0.141414141414141	28	0	14	0	89	116	6035042	6035069	Moorena producens PAL-8-15-08-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
5084552	5084552	PRJNA939415_P_NODE_111584_length_199_cov_6.611111_g111162_i0	PRJNA939415	111584	199	6.611111	13.15611089	Bacillati	1783272	Bacteria	Bacteria	359	9.09e-95	NTclustered	gi\|321159404\|gb\|HQ711891.1\|	1211	g111162	i0	99.005	100.668341708543	201	0	100	1	1	199	355	555	Uncultured cyanobacterium clone DWIA06 16S ribosomal RNA gene, partial sequence	blastn	20033	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
7294671	7294671	PRJNA939415_P_NODE_99146_length_236_cov_2.644172_g98724_i0	PRJNA939415	99146	236	2.644172	6.24024592	Nostoc piscinale	224012	Bacteria	Bacteria	62.1	3.52e-5	NTclustered	gi\|930349143\|gb\|CP012036.1\|	224013	g98724	i0	95	5.97033898305085	40	1	17	1	93	131	6353469	6353430	Nostoc piscinale CENA21 chromosome	blastn	1409	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc piscinale
8569218	8569218	PRJNA939415_P_NODE_83247_length_251_cov_0.865169_g82825_i0	PRJNA939415	83247	251	0.865169	2.17157419	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	398	2.5399999999999994e-106	NTclustered	gi\|2245130563\|gb\|CP097482.1\|	2653189	g82825	i0	95.219	1	251	12	100	0	1	251	741	491	Chroococcidiopsis sp. CCNUC1 plasmid pB, complete sequence	blastn	251	398	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
11119430	11119430	PRJNA939415_P_NODE_56649_length_277_cov_2.073529_g56227_i0	PRJNA939415	56649	277	2.073529	5.74367533	Gloeomargarita lithophora	1188228	Bacteria	Bacteria	76.8	1.51e-9	NTclustered	gi\|1100591715\|gb\|CP017675.1\|	1188229	g56227	i0	97.727	0.317689530685921	44	1	16	0	128	171	758609	758566	Gloeomargarita lithophora Alchichica-D10 chromosome	blastn	88	76.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeomargaritales	Gloeomargaritaceae	Gloeomargarita	Gloeomargarita lithophora
14010830	14010830	PRJNA939415_P_NODE_99471_length_235_cov_4.296296_g99049_i0	PRJNA939415	99471	235	4.296296	10.0962956	Nostoc	1177	Bacteria	Bacteria	357	3.9899999999999996e-94	NTclustered	gi\|470483128\|ref\|NR_076575.1\|	63737	g99049	i0	94.421	270.08085106383	233	12	99	1	1	233	2856	2625	Nostoc punctiforme PCC 73102 strain PCC 73102 23S ribosomal RNA gene, complete sequence	blastn	63469	359	0.994428969359331	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
14943271	14943271	PRJNA939415_P_NODE_34192_length_310_cov_2.295359_g33770_i0	PRJNA939415	34192	310	2.295359	7.1156129	Synechococcus sp. LTW-R	2751170	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1891299085\|gb\|CP059060.1\|	2751170	g33770	i0	100	0.0903225806451613	28	0	9	0	229	256	72097	72124	Synechococcus sp. LTW-R chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. LTW-R
15284743	15284743	PRJNA939415_P_NODE_95232_length_241_cov_2.291667_g94810_i0	PRJNA939415	95232	241	2.291667	5.52291747	Synechococcus	1129	Bacteria	Bacteria	60.2	1.3e-4	NTclustered	gi\|2638507609\|emb\|OY986433.1\|	2789857	g94810	i0	100	0.265560165975104	32	0	13	0	210	241	1057996	1058027	Synechococcus sp. CBW1107 isolate KAC_106 genome assembly, chromosome: 1	blastn	64	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107
22592813	22592813	PRJNA939415_P_NODE_57578_length_276_cov_2.201970_g57156_i0	PRJNA939415	57578	276	2.20197	6.0774372	Tolypothrix tenuis	457083	Bacteria	Bacteria	346	1.04e-90	NTclustered	gi\|1210177014\|dbj\|AP018248.1\|	231146	g57156	i0	90	2.90217391304348	270	24	97	3	4	272	450068	450335	Tolypothrix tenuis PCC 7101 DNA, nearly complete genome	blastn	801	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix tenuis
22593143	22593143	PRJNA939415_P_NODE_76098_length_258_cov_1.664865_g75676_i0	PRJNA939415	76098	258	1.664865	4.2953517	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	366	7.38e-97	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g75676	i0	92.278	272.073643410853	259	18	100	2	1	258	2150713	2150456	Leptolyngbya sp. 7M chromosome	blastn	70195	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
25141144	25141144	PRJNA939415_P_NODE_17160_length_375_cov_7.397351_g16740_i0	PRJNA939415	17160	375	7.397351	27.74006625	Planktothricoides raciborskii	132608	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g16740	i0	100	0.0746666666666667	28	0	7	0	45	72	2854596	2854623	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
25142395	25142395	PRJNA939415_P_NODE_83420_length_251_cov_0.865169_g82998_i0	PRJNA939415	83420	251	0.865169	2.17157419	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	300	7.36e-77	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g82998	i0	88.142	1.00796812749004	253	28	100	2	1	251	2594885	2594633	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	253	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis

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