metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1098727" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1098727" 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
8673074	8673074	PRJNA1098727_P_NODE_15627_length_162_cov_0.920354_g15386_i0	PRJNA1098727	15627	162	0.920354	1.49097348	Oscillatoriales	1150	Bacteria	Bacteria	244	2.07e-60	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g15386	i0	93.827	4	162	10	100	0	1	162	6344252	6344091	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	648	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
10414500	10414500	PRJNA1098727_P_NODE_15509_length_162_cov_1.840708_g15268_i0	PRJNA1098727	15509	162	1.840708	2.98194696	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	196	5.89e-46	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g15268	i0	88.82	31.1975308641975	161	17	99	1	1	161	2010	1851	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	5054	196	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11223247	11223247	PRJNA1098727_P_NODE_1789_length_515_cov_2.369099_g1556_i0	PRJNA1098727	1789	515	2.369099	12.20085985	Cyanophyceae	3028117	Bacteria	Bacteria	676	0	NTclustered	gi\|427347790\|gb\|CP003943.1\|	99598	g1556	i0	90.329	203.642718446602	517	48	100	2	1	515	1915400	1915916	Calothrix sp. PCC 7507 chromosome, complete genome	blastn	104876	680	0.994117647058824	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7507
14239843	14239843	PRJNA1098727_P_NODE_10172_length_190_cov_1.992908_g9931_i0	PRJNA1098727	10172	190	1.992908	3.7865252	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	220	4.23e-53	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g9931	i0	88.462	131.647368421053	182	21	96	0	8	189	3254	3073	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25013	220	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15513746	15513746	PRJNA1098727_P_NODE_15893_length_162_cov_0.920354_g15652_i0	PRJNA1098727	15893	162	0.920354	1.49097348	Brasilonema sennae	1397703	Bacteria	Bacteria	134	4.6800000000000005e-27	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g15652	i0	81.481	2.00617283950617	162	30	100	0	1	162	914948	915109	Brasilonema sennae CENA114 chromosome	blastn	325	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
18871400	18871400	PRJNA1098727_P_NODE_15315_length_163_cov_0.912281_g15074_i0	PRJNA1098727	15315	163	0.912281	1.48701803	Planktothrix	54304	Bacteria	Bacteria	298	1.58e-76	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g15074	i0	100	12.840490797546	161	0	99	0	2	162	1915158	1915318	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	2093	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
20612313	20612313	PRJNA1098727_P_NODE_6157_length_253_cov_2.161765_g5916_i0	PRJNA1098727	6157	253	2.161765	5.46926545	Aliterella chasmolithica	2739056	Bacteria	Bacteria	372	1.55e-98	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g5916	i0	93.574	137.679841897233	249	16	98	0	2	250	1977	2225	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34833	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
23163412	23163412	PRJNA1098727_P_NODE_12399_length_171_cov_1.270492_g12158_i0	PRJNA1098727	12399	171	1.270492	2.17254132	uncultured cyanobacterium	1211	Bacteria	Bacteria	278	2.17e-70	NTclustered	gi\|171673237\|gb\|EU409853.1\|	1211	g12158	i0	96.45	97.1228070175439	169	4	99	2	2	170	54	220	Uncultured cyanobacterium clone 16L33 16S ribosomal RNA gene, partial sequence	blastn	16608	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23163444	23163444	PRJNA1098727_P_NODE_3039_length_387_cov_2.103550_g2798_i0	PRJNA1098727	3039	387	2.10355	8.1407385	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	569	8.249999999999997e-158	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g2798	i0	93.282	107.385012919897	387	24	99	2	1	386	2909	2524	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41558	569	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23163450	23163450	PRJNA1098727_P_NODE_5939_length_259_cov_0.838095_g5698_i0	PRJNA1098727	5939	259	0.838095	2.17066605	Synechococcus sp. CBW1107	2789857	Bacteria	Bacteria	60.2	1.41e-4	NTclustered	gi\|2638498304\|emb\|OY986430.1\|	2789857	g5698	i0	97.143	0.135135135135135	35	1	14	0	141	175	2168481	2168447	Synechococcus sp. CBW1107 isolate KAC_114 genome assembly, chromosome: 1	blastn	35	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107
23163451	23163451	PRJNA1098727_P_NODE_619_length_886_cov_2.910394_g459_i0	PRJNA1098727	619	886	2.910394	25.78609084	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1358	0	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g459	i0	94.476	130.07223476298	887	40	99	6	2	883	1939	2821	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	115244	1358	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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