metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA986481" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA986481" 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
3524574	3524574	PRJNA986481_P_NODE_803_length_1403_cov_12.577548_g646_i0	PRJNA986481	803	1403	12.577548	176.46299844	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2091	0	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g646	i0	93.772	103.611546685674	1397	79	99	7	1	1391	1631	3025	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	145367	2091	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9901468	9901468	PRJNA986481_P_NODE_18148_length_384_cov_2.173134_g17623_i0	PRJNA986481	18148	384	2.173134	8.34483456	Nostoc sp. UHCC 0870	2914041	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2190707562\|gb\|CP091913.1\|	2914041	g17623	i0	100	0.078125	30	0	8	0	317	346	333553	333524	Nostoc sp. UHCC 0870 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0870
9901746	9901746	PRJNA986481_P_NODE_37088_length_267_cov_1.977064_g36563_i0	PRJNA986481	37088	267	1.977064	5.27876088	Synechococcus sp. PROS-7-1	1442556	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1895782591\|gb\|CP047945.1\|	1442556	g36563	i0	100	0.104868913857678	28	0	10	0	26	53	76510	76483	Synechococcus sp. PROS-7-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PROS-7-1
10200810	10200810	PRJNA986481_P_NODE_59868_length_241_cov_1.354167_g59343_i0	PRJNA986481	59868	241	1.354167	3.26354247	Oscillatoriales	1150	Bacteria	Bacteria	427	3.079999999999999e-115	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g59343	i0	99.156	133.45643153527	237	2	98	0	5	241	2229	2465	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32163	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14026008	14026008	PRJNA986481_P_NODE_43351_length_260_cov_0.957346_g42826_i0	PRJNA986481	43351	260	0.957346	2.4890996	Oscillatoriales	1150	Bacteria	Bacteria	457	4.3e-124	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g42826	i0	100	119.819230769231	247	0	95	0	14	260	2009	1763	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31153	457	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16276059	16276059	PRJNA986481_P_NODE_10673_length_501_cov_7.546460_g10152_i0	PRJNA986481	10673	501	7.54646	37.8077646	Kovacikia minuta	2931930	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|2098452651\|gb\|CP083582.1\|	2653194	g10152	i0	100	0.0558882235528942	28	0	6	0	157	184	3886849	3886876	Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Kovacikia	Kovacikia minuta
20398367	20398367	PRJNA986481_P_NODE_16656_length_402_cov_2.164306_g16131_i0	PRJNA986481	16656	402	2.164306	8.70051012	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|427368660\|gb\|CP003549.1\|	373994	g16131	i0	100	0.283582089552239	29	0	7	0	15	43	6297824	6297852	Rivularia sp. PCC 7116, complete genome	blastn	114	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. PCC 7116
20398575	20398575	PRJNA986481_P_NODE_62656_length_226_cov_2.282486_g62131_i0	PRJNA986481	62656	226	2.282486	5.15841836	Nostocales	1161	Bacteria	Bacteria	329	8.3e-86	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g62131	i0	93.636	175	220	14	99	0	4	223	1851886	1852105	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	39550	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
23925790	23925790	PRJNA986481_P_NODE_1539_length_1118_cov_4.000000_g1292_i0	PRJNA986481	1539	1118	4	44.72	Stanieria cyanosphaera	102116	Bacteria	Bacteria	645	4.1e-180	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g1292	i0	79.932	17.6967799642218	887	171	79	6	12	893	1	885	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	19785	645	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera

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