metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA807685" and tax_clade = "Cyanobacteriota/Melainabacteria group"

9 rows where analysis = "blastn", bioproject = "PRJNA807685" 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
4634996	4634996	PRJNA807685_P_NODE_33504_length_217_cov_1.516667_g32431_i0	PRJNA807685	33504	217	1.516667	3.29116739	Anabaenopsis circularis	109266	Bacteria	Bacteria	62.1	3.18e-5	NTclustered	gi\|1210095109\|dbj\|AP018174.1\|	1085406	g32431	i0	97.222	0.898617511520737	36	1	17	0	86	121	6027631	6027666	Anabaenopsis circularis NIES-21 DNA, nearly complete genome	blastn	195	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Anabaenopsis	Anabaenopsis circularis
8459591	8459591	PRJNA807685_P_NODE_36827_length_204_cov_1.832335_g35754_i0	PRJNA807685	36827	204	1.832335	3.7379634	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	350	5.64e-92	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g35754	i0	97.549	226.274509803922	204	5	100	0	1	204	1245434	1245231	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	46160	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
9734759	9734759	PRJNA807685_P_NODE_59568_length_159_cov_1.254098_g58495_i0	PRJNA807685	59568	159	1.254098	1.99401582	Nodularia sphaerocarpa	137816	Bacteria	Bacteria	62.1	2.19e-5	NTclustered	gi\|2198613447\|gb\|CP060140.1\|	2761619	g58495	i0	100	15.2327044025157	33	0	21	0	110	142	694342	694310	Nodularia sphaerocarpa UHCC 0038 chromosome, complete genome	blastn	2422	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia sphaerocarpa
11010625	11010625	PRJNA807685_P_NODE_64389_length_153_cov_2.448276_g63316_i0	PRJNA807685	64389	153	2.448276	3.74586228	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	267	4.1099999999999994e-67	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g63316	i0	98.039	140.699346405229	153	3	100	0	1	153	1935	2087	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	21527	267	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15250834	15250834	PRJNA807685_P_NODE_27612_length_248_cov_1.838863_g26539_i0	PRJNA807685	27612	248	1.838863	4.56038024	Nostocales	1161	Bacteria	Bacteria	65.8	2.88e-6	NTclustered	gi\|924287285\|gb\|CP011456.1\|	1647413	g26539	i0	97.368	0.931451612903226	38	1	15	0	147	184	3166661	3166698	Anabaena sp. WA102 chromosome, complete sequence	blastn	231	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. WA102
16109056	16109056	PRJNA807685_P_NODE_45133_length_182_cov_1.324138_g44060_i0	PRJNA807685	45133	182	1.324138	2.40993116	Nostoc sp. CENA543	1869241	Bacteria	Bacteria	169	1.4699999999999998e-37	NTclustered	gi\|1334417636\|gb\|CP023278.1\|	1869241	g44060	i0	85.119	35.2857142857143	168	21	91	4	17	182	1764030	1764195	Nostoc sp. CENA543 chromosome, complete genome	blastn	6422	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CENA543
21208697	21208697	PRJNA807685_P_NODE_16597_length_362_cov_2.049231_g15527_i0	PRJNA807685	16597	362	2.049231	7.41821622	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	248	4.08e-61	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g15527	i0	81.613	0.856353591160221	310	47	84	8	1	305	2605847	2605543	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	310	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
22483594	22483594	PRJNA807685_P_NODE_60298_length_158_cov_1.289256_g59225_i0	PRJNA807685	60298	158	1.289256	2.03702448	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	137	3.5e-28	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g59225	i0	85.185	0.854430379746835	135	18	85	2	24	158	194089	193957	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	135	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
22900413	22900413	PRJNA807685_P_NODE_50278_length_172_cov_1.703704_g49205_i0	PRJNA807685	50278	172	1.703704	2.93037088	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	198	1.7499999999999999e-46	NTclustered	gi\|308205634\|gb\|HQ291116.1\|	676037	g49205	i0	90.728	87.1511627906977	151	10	87	4	3	151	4171	4319	Nostoc flagelliforme str. Sunitezuoqi clone 44 hypothetical protein (Nfla_4401), hypothetical protein (Nfla_4402), amidohydrolase (Nfla_4403), brefeldin A esterase (Nfla_4404), and 6-phosphogluconate dehydrogenase (Nfla_4405) genes, complete cds	blastn	14990	200	0.99	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme

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