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

23 rows where analysis = "blastn", bioproject = "PRJNA316313" 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
1661227	1661227	PRJNA316313_P_NODE_206062_length_187_cov_3.360000_g204676_i0	PRJNA316313	206062	187	3.36	6.2832	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	130	7.19e-26	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g204676	i0	97.368	0.812834224598931	76	2	81	0	1	76	10488562	10488637	Calothrix sp. PCC 7716 DNA, complete genome	blastn	152	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
4215118	4215118	PRJNA316313_P_NODE_420044_length_151_cov_4.947368_g418658_i0	PRJNA316313	420044	151	4.947368	7.47052568	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	141	2.56e-29	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g418658	i0	88.095	1.66887417218543	126	5	77	3	1	116	2279173	2279048	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	252	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
6763853	6763853	PRJNA316313_P_NODE_143986_length_187_cov_5.006667_g142600_i0	PRJNA316313	143986	187	5.006667	9.36246729	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	106	1.21e-18	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g142600	i0	92	0.401069518716578	75	6	40	0	1	75	3657639	3657565	Calothrix sp. PCC 7716 DNA, complete genome	blastn	75	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
7446453	7446453	PRJNA316313_P_NODE_49066_length_263_cov_3.367257_g47681_i0	PRJNA316313	49066	263	3.367257	8.85588591	Oscillatoriales	1150	Bacteria	Bacteria	403	5.75e-108	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g47681	i0	94.942	127.262357414449	257	13	98	0	7	263	1373549	1373293	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	33470	403	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
8039898	8039898	PRJNA316313_P_NODE_220027_length_187_cov_3.120000_g218641_i0	PRJNA316313	220027	187	3.12	5.8344	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	130	7.19e-26	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g218641	i0	97.368	0.406417112299465	76	2	41	0	112	187	1609597	1609672	Allocoleopsis franciscana PCC 7113, complete genome	blastn	76	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
8720021	8720021	PRJNA316313_P_NODE_160487_length_187_cov_4.286667_g159101_i0	PRJNA316313	160487	187	4.286667	8.01606729	Chroococcidiopsis	54298	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g159101	i0	100	1.62566844919786	76	0	81	0	1	76	4922937	4923012	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	304	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
9996676	9996676	PRJNA316313_P_NODE_489008_length_150_cov_4.548673_g487622_i0	PRJNA316313	489008	150	4.548673	6.8230095	Chlorogloeopsis	1123	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g487622	i0	100	0.373333333333333	28	0	19	0	10	37	5939439	5939466	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
11865388	11865388	PRJNA316313_P_NODE_240890_length_187_cov_2.933333_g239504_i0	PRJNA316313	240890	187	2.933333	5.48533271	Cyanobium sp. NIES-981	1851505	Bacteria	Bacteria	86.1	1.58e-12	NTclustered	gi\|1034210027\|emb\|LT578417.1\|	1851505	g239504	i0	91.803	1.57219251336898	61	5	33	0	9	69	1390294	1390234	Cyanobium sp. NIES-981 strain NIES-981 genome assembly, chromosome: I	blastn	294	86.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. NIES-981
13141124	13141124	PRJNA316313_P_NODE_363291_length_170_cov_3.511278_g361905_i0	PRJNA316313	363291	170	3.511278	5.9691726	Nostoc sp. NIES-3756	1751286	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g361905	i0	100	1.02941176470588	30	0	18	0	44	73	2467096	2467125	Nostoc sp. NIES-3756 DNA, complete genome	blastn	175	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
13821136	13821136	PRJNA316313_P_NODE_245591_length_187_cov_2.893333_g244205_i0	PRJNA316313	245591	187	2.893333	5.41053271	Chroococcidiopsis	54298	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g244205	i0	100	1.62566844919786	76	0	81	0	1	76	5632679	5632754	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	304	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
13821820	13821820	PRJNA316313_P_NODE_436291_length_151_cov_4.105263_g434905_i0	PRJNA316313	436291	151	4.105263	6.19894713	Chroococcidiopsis	54298	Bacteria	Bacteria	141	2.56e-29	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g434905	i0	100	2.02649006622517	76	0	100	0	76	151	4336545	4336620	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	306	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
14415913	14415913	PRJNA316313_P_NODE_286552_length_187_cov_2.520000_g285166_i0	PRJNA316313	286552	187	2.52	4.7124	Nostoc sp. 'Peltigera membranacea cyanobiont' N6	1261031	Bacteria	Bacteria	76.8	9.5e-10	NTclustered	gi\|1349664091\|gb\|CP026681.1\|	1261031	g285166	i0	97.727	0.946524064171123	44	1	24	0	141	184	4159317	4159360	Nostoc sp. 'Peltigera membranacea cyanobiont' N6 chromosome, complete genome	blastn	177	76.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Peltigera membranacea cyanobiont' N6
15689291	15689291	PRJNA316313_P_NODE_216073_length_187_cov_3.186667_g214687_i0	PRJNA316313	216073	187	3.186667	5.95906729	Crinalium epipsammum	241425	Bacteria	Bacteria	86.1	1.58e-12	NTclustered	gi\|428245228\|gb\|CP003620.1\|	1173022	g214687	i0	87.013	0.411764705882353	77	9	41	1	112	187	2639944	2640020	Crinalium epipsammum PCC 9333, complete genome	blastn	77	86.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Crinalium	Crinalium epipsammum
15689359	15689359	PRJNA316313_P_NODE_230113_length_187_cov_3.053333_g228727_i0	PRJNA316313	230113	187	3.053333	5.70973271	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	119	1.56e-22	NTclustered	gi\|2245130261\|gb\|CP097481.1\|	2653189	g228727	i0	94.737	1.61497326203209	76	4	41	0	1	76	10307	10232	Chroococcidiopsis sp. CCNUC1 plasmid pA, complete sequence	blastn	302	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
16964207	16964207	PRJNA316313_P_NODE_257414_length_187_cov_2.766667_g256028_i0	PRJNA316313	257414	187	2.766667	5.17366729	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	115	2.01e-21	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g256028	i0	95.775	0.764705882352941	71	3	38	0	117	187	5814679	5814609	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	143	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
16965176	16965176	PRJNA316313_P_NODE_420394_length_151_cov_4.921053_g419008_i0	PRJNA316313	420394	151	4.921053	7.43079003	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	274	2.42e-69	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g419008	i0	99.342	138.013245033113	152	0	100	1	1	151	1280300	1280451	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	20840	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
19512247	19512247	PRJNA316313_P_NODE_155616_length_187_cov_4.466667_g154230_i0	PRJNA316313	155616	187	4.466667	8.35266729	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	135	1.55e-27	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g154230	i0	98.684	1.02139037433155	76	1	41	0	1	76	5020179	5020104	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	191	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
19513937	19513937	PRJNA316313_P_NODE_457796_length_151_cov_3.359649_g456410_i0	PRJNA316313	457796	151	3.359649	5.07306999	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	198	1.5e-46	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g456410	i0	90.123	1.0728476821192101	162	3	99	1	3	151	3133993	3134154	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	162	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
20787732	20787732	PRJNA316313_P_NODE_148457_length_187_cov_4.766667_g147071_i0	PRJNA316313	148457	187	4.766667	8.91366729	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	135	1.55e-27	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g147071	i0	98.684	0.812834224598931	76	1	81	0	112	187	781282	781207	Calothrix sp. PCC 7716 DNA, complete genome	blastn	152	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
21469715	21469715	PRJNA316313_P_NODE_318077_length_187_cov_2.273333_g316691_i0	PRJNA316313	318077	187	2.273333	4.25113271	Oscillatoriales	1150	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|2395771017\|gb\|CP066886.2\|	147317	g316691	i0	100	27.2085561497326	76	0	81	0	1	76	500233	500158	Arthrospira sp. PCC 9108 chromosome, complete genome	blastn	5088	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Arthrospira	Arthrospira sp. PCC 9108
21469917	21469917	PRJNA316313_P_NODE_366797_length_168_cov_2.557252_g365411_i0	PRJNA316313	366797	168	2.557252	4.29618336	Prochlorococcus	1218	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2895599909\|gb\|CP138966.1\|	1499498	g365411	i0	100	0.5	28	0	17	0	81	108	1739171	1739144	Prochlorococcus sp. MIT 0601 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 0601
22744576	22744576	PRJNA316313_P_NODE_246038_length_187_cov_2.886667_g244652_i0	PRJNA316313	246038	187	2.886667	5.39806729	Chroococcidiopsis	54298	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g244652	i0	100	2.7379679144385	76	0	81	0	1	76	1797249	1797324	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	512	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
23339791	23339791	PRJNA316313_P_NODE_430779_length_151_cov_4.324561_g429393_i0	PRJNA316313	430779	151	4.324561	6.53008711	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	102	1.21e-17	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g429393	i0	89.157	17.3774834437086	83	8	54	1	68	149	1046305	1046387	Synechococcus sp. CB0101 chromosome, complete genome	blastn	2624	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101

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