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

19 rows where analysis = "blastn", bioproject = "PRJNA743294" 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
3273579	3273579	PRJNA743294_P_NODE_59523_length_227_cov_2.967532_g59067_i0	PRJNA743294	59523	227	2.967532	6.73629764	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	298	2.35e-76	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g59067	i0	90.308	259.11013215859	227	22	100	0	1	227	2649	2875	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	58818	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
5026599	5026599	PRJNA743294_P_NODE_52504_length_246_cov_0.901734_g52048_i0	PRJNA743294	52504	246	0.901734	2.21826564	Synechococcales	1890424	Bacteria	Bacteria	145	3.56e-30	NTclustered	gi\|1895767613\|gb\|CP047940.1\|	261284	g52048	i0	79.048	20.3008130081301	210	44	85	0	1	210	1872883	1873092	Cyanobium sp. NS01 chromosome, complete genome	blastn	4994	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. NS01
5825784	5825784	PRJNA743294_P_NODE_54645_length_244_cov_0.912281_g54189_i0	PRJNA743294	54645	244	0.912281	2.22596564	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	289	1.5400000000000003e-73	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g54189	i0	88.163	157.372950819672	245	25	100	4	1	244	4390036	4389795	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	38399	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
7100712	7100712	PRJNA743294_P_NODE_29286_length_307_cov_1.692308_g28830_i0	PRJNA743294	29286	307	1.692308	5.19538556	Okeanomitos corallinicola	3231550	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2715117499\|gb\|CP150886.1\|	3133117	g28830	i0	100	0.0912052117263844	28	0	9	0	136	163	5016975	5016948	Okeanomitos corallinicola TIOX110 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Okeanomitos	Okeanomitos corallinicola
7100783	7100783	PRJNA743294_P_NODE_37626_length_276_cov_1.472906_g37170_i0	PRJNA743294	37626	276	1.472906	4.06522056	Synechococcus sp. CHAB TP201715.1	2737637	Bacteria	Bacteria	481	2.73e-131	NTclustered	gi\|1843475423\|gb\|MT488154.1\|	2737637	g37170	i0	99.62	37.7934782608696	263	1	95	0	1	263	1535	1797	Synechococcus sp. CHAB TP201715.1 clone 05 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	10431	481	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CHAB TP201715.1
8375478	8375478	PRJNA743294_P_NODE_48447_length_250_cov_2.401130_g47991_i0	PRJNA743294	48447	250	2.40113	6.002825	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	4.16e-114	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g47991	i0	97.2	115.884	250	7	100	0	1	250	2542	2791	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	28971	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13475776	13475776	PRJNA743294_P_NODE_17931_length_381_cov_2.500000_g17475_i0	PRJNA743294	17931	381	2.5	9.525	Crocosphaera subtropica	2546360	Bacteria	Bacteria	73.1	2.79e-8	NTclustered	gi\|171696371\|gb\|CP000806.1\|	43989	g17475	i0	92.157	0.228346456692913	51	4	13	0	163	213	1632701	1632651	Cyanothece sp. ATCC 51142 circular chromosome, complete sequence	blastn	87	73.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera subtropica
13952241	13952241	PRJNA743294_P_NODE_11411_length_470_cov_1.516373_g10955_i0	PRJNA743294	11411	470	1.516373	7.1269531	Cyanophyceae	3028117	Bacteria	Bacteria	514	4.85e-141	NTclustered	gi\|46409893\|gb\|AY584518.1\|	272129	g10955	i0	89.975	126.176595744681	399	39	85	1	6	403	1112	1510	Oscillatoria sp. PCC 6506 23S ribosomal RNA gene, partial sequence	blastn	59303	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Kamptonema	Kamptonema sp. PCC 6506
16024467	16024467	PRJNA743294_P_NODE_14013_length_427_cov_2.629944_g13557_i0	PRJNA743294	14013	427	2.629944	11.22986088	Crinalium epipsammum	241425	Bacteria	Bacteria	536	9.319999999999997e-148	NTclustered	gi\|485099154\|ref\|NR_102549.1\|	1173022	g13557	i0	90	143.084309133489	420	35	98	6	10	427	1486	1072	Crinalium epipsammum PCC 9333 strain PCC 9333 23S ribosomal RNA, complete sequence	blastn	61097	536	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Crinalium	Crinalium epipsammum
16024808	16024808	PRJNA743294_P_NODE_57453_length_238_cov_2.496970_g56997_i0	PRJNA743294	57453	238	2.49697	5.9427886	Synechocystis sp. PCC 9413	77760	Bacteria	Bacteria	422	1.41e-113	NTclustered	gi\|7770709\|gb\|AF068771.3\|AF068771	77760	g56997	i0	98.739	1	238	2	100	1	1	238	1473	1709	Synechocystis PCC9413 beta-phycocyanin (cpcB), alpha-phycocyanin (cpcA), and 35 k phycocyanin specific rod linker polypeptide (cpcC) genes, complete cds; and phycocyanin alpha-subunit phycocyanobilin lyase (cpcE) gene, partial cds	blastn	238	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 9413
17300148	17300148	PRJNA743294_P_NODE_26834_length_319_cov_1.833333_g26378_i0	PRJNA743294	26834	319	1.833333	5.84833227	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	339	2.05e-88	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g26378	i0	87.333	174.489028213166	300	32	93	6	23	319	3682353	3682057	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	55662	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
17300178	17300178	PRJNA743294_P_NODE_31454_length_297_cov_2.535714_g30998_i0	PRJNA743294	31454	297	2.535714	7.53107058	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	527	3.759999999999999e-145	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g30998	i0	98.653	115.272727272727	297	4	100	0	1	297	127	423	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34236	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17300265	17300265	PRJNA743294_P_NODE_42214_length_262_cov_5.433862_g41758_i0	PRJNA743294	42214	262	5.433862	14.23671844	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	283	7.789999999999999e-72	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g41758	i0	86.957	97.0343511450382	253	31	96	2	11	262	3681454	3681203	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	25423	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
21124445	21124445	PRJNA743294_P_NODE_12357_length_453_cov_2.115789_g11901_i0	PRJNA743294	12357	453	2.115789	9.58452417	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g11901	i0	96.97	0.717439293598234	33	1	7	0	355	387	2336664	2336696	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	325	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
21600481	21600481	PRJNA743294_P_NODE_1997_length_1022_cov_3.338251_g1715_i0	PRJNA743294	1997	1022	3.338251	34.11692522	Nostocales	1161	Bacteria	Bacteria	1232	0	NTclustered	gi\|485099135\|ref\|NR_102530.1\|	56107	g1715	i0	88.608	180.972602739726	1027	99	100	17	1	1022	13	1026	Cylindrospermum stagnale PCC 7417 strain PCC 7417 23S ribosomal RNA, complete sequence	blastn	184954	1232	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
22399473	22399473	PRJNA743294_P_NODE_28298_length_312_cov_1.100418_g27842_i0	PRJNA743294	28298	312	1.100418	3.43330416	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	243	1.61e-59	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g27842	i0	80.818	158.144230769231	318	53	100	7	1	312	3681334	3681019	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	49341	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
22399545	22399545	PRJNA743294_P_NODE_38438_length_273_cov_2.300000_g37982_i0	PRJNA743294	38438	273	2.3	6.279	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	241	4.98e-59	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g37982	i0	83.209	34.7619047619048	268	39	97	5	8	271	3682269	3682534	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	9490	241	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
22399632	22399632	PRJNA743294_P_NODE_5078_length_678_cov_2.624793_g4637_i0	PRJNA743294	5078	678	2.624793	17.79609654	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	898	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g4637	i0	90.588	175.856932153392	680	61	100	3	1	678	3682258	3681580	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	119231	898	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
23675055	23675055	PRJNA743294_P_NODE_34699_length_285_cov_2.882075_g34243_i0	PRJNA743294	34699	285	2.882075	8.21391375	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	318	2.3499999999999991e-82	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g34243	i0	86.76	42.4631578947368	287	36	100	1	1	285	3679729	3680015	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	12102	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium

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