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

21 rows where analysis = "blastn", bioproject = "PRJNA795663" 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
1216252	1216252	PRJNA795663_S_NODE_17901_length_153_cov_1.870690_g17796_i0	PRJNA795663	17901	153	1.87069	2.8621557	root	1	Root_unresolved	Root_unresolved	254	3.2e-63	NTclustered	gi\|225696244\|gb\|FJ805911.1\|	1211	g17796	i0	99.286	114.901960784314	140	1	92	0	1	140	2235	2096	Uncultured cyanobacterium clone AN2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17580	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2491865	2491865	PRJNA795663_S_NODE_9682_length_195_cov_4.297468_g9577_i0	PRJNA795663	9682	195	4.297468	8.3800626	Synechococcus	1129	Bacteria	Bacteria	89.8	1.28e-13	NTclustered	gi\|2895599921\|gb\|CP138969.1\|	166309	g9577	i0	80.159	8.58461538461538	126	19	63	6	1	123	1426953	1427075	Synechococcus sp. MIT S9220 chromosome, complete genome	blastn	1674	89.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. MIT S9220
4607918	4607918	PRJNA795663_S_NODE_7664_length_216_cov_1.888268_g7559_i0	PRJNA795663	7664	216	1.888268	4.07865888	Cyanobium sp. NS01	261284	Bacteria	Bacteria	311	2.85e-80	NTclustered	gi\|1895767613\|gb\|CP047940.1\|	261284	g7559	i0	92.593	59.5231481481481	216	16	100	0	1	216	2335896	2335681	Cyanobium sp. NS01 chromosome, complete genome	blastn	12857	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. NS01
4607936	4607936	PRJNA795663_S_NODE_8564_length_206_cov_1.828402_g8459_i0	PRJNA795663	8564	206	1.828402	3.76650812	Synechococcus sp. SynAce01	1916956	Bacteria	Bacteria	215	2.17e-51	NTclustered	gi\|1104554094\|gb\|CP018091.1\|	1916956	g8459	i0	85.437	1.96116504854369	206	30	100	0	1	206	2048393	2048598	Synechococcus sp. SynAce01 chromosome, complete genome	blastn	404	215	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. SynAce01
6320354	6320354	PRJNA795663_S_NODE_16345_length_159_cov_0.959016_g16240_i0	PRJNA795663	16345	159	0.959016	1.52483544	Synechococcus	1129	Bacteria	Bacteria	289	9.22e-74	NTclustered	gi\|7330161\|gb\|AF223444.1\|AF223444	115763	g16240	i0	99.371	61.2389937106918	159	1	100	0	1	159	259	101	Synechococcus sp. PS683 CpcB (cpcB) and CpcA (cpcA) genes, partial cds	blastn	9737	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PS683
6320446	6320446	PRJNA795663_S_NODE_8845_length_203_cov_1.632530_g8740_i0	PRJNA795663	8845	203	1.63253	3.3140359	Chlorogloeopsis	1123	Bacteria	Bacteria	337	4.3599999999999994e-88	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g8740	i0	96.552	241.039408866995	203	7	100	0	1	203	1852031	1851829	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	48931	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
7157600	7157600	PRJNA795663_S_NODE_10726_length_187_cov_7.140000_g10621_i0	PRJNA795663	10726	187	7.14	13.3518	Synechococcus sp. CBW1107	2789857	Bacteria	Bacteria	302	1.44e-77	NTclustered	gi\|2638507609\|emb\|OY986433.1\|	2789857	g10621	i0	99.398	89.6256684491979	166	1	89	0	20	185	2892225	2892390	Synechococcus sp. CBW1107 isolate KAC_106 genome assembly, chromosome: 1	blastn	16760	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107
8869597	8869597	PRJNA795663_S_NODE_67_length_1745_cov_87.373536_g26_i1	PRJNA795663	67	1745	87.373536	1524.6682032	Synechococcus	1129	Bacteria	Bacteria	2433	0	NTclustered	gi\|146740640\|emb\|AM709627.1\|	115746	g26	i1	97.868	153.702578796562	1407	30	81	0	36	1442	2343	3749	Synechococcus sp. PCC 7920 partial ribosomal RNA operon, strain PCC 7920	blastn	268211	2455	0.991038696537678	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PCC 7920
9707495	9707495	PRJNA795663_S_NODE_12088_length_179_cov_1.366197_g11983_i0	PRJNA795663	12088	179	1.366197	2.44549263	Cyanobium sp. NIES-981	1851505	Bacteria	Bacteria	159	8.689999999999998e-35	NTclustered	gi\|1034210027\|emb\|LT578417.1\|	1851505	g11983	i0	82.682	6.43575418994413	179	31	100	0	1	179	1586669	1586847	Cyanobium sp. NIES-981 strain NIES-981 genome assembly, chromosome: I	blastn	1152	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. NIES-981
10983217	10983217	PRJNA795663_S_NODE_12429_length_177_cov_1.585714_g12324_i0	PRJNA795663	12429	177	1.585714	2.80671378	Cyanobium gracile	59930	Bacteria	Bacteria	228	2.3099999999999997e-55	NTclustered	gi\|427344508\|gb\|CP003495.1\|	292564	g12324	i0	89.831	34.7118644067797	177	18	100	0	1	177	1793458	1793634	Cyanobium gracile PCC 6307, complete genome	blastn	6144	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
12259070	12259070	PRJNA795663_S_NODE_830_length_579_cov_2.147601_g741_i0	PRJNA795663	830	579	2.147601	12.43460979	Synechococcus sp. NB0720_010	2907159	Bacteria	Bacteria	791	0	NTclustered	gi\|2227925466\|gb\|CP090898.1\|	2907159	g741	i0	91.349	69.4214162348877	578	50	99	0	1	578	1229543	1230120	Synechococcus sp. NB0720_010 chromosome, complete genome	blastn	40195	791	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. NB0720_010
13970216	13970216	PRJNA795663_S_NODE_1131_length_510_cov_3.959831_g1031_i0	PRJNA795663	1131	510	3.959831	20.1951381	Synechococcales	1890424	Bacteria	Bacteria	459	2.5199999999999998e-124	NTclustered	gi\|427344508\|gb\|CP003495.1\|	292564	g1031	i0	83.202	89.1509803921569	506	79	99	6	2	504	2864263	2863761	Cyanobium gracile PCC 6307, complete genome	blastn	45467	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
13970350	13970350	PRJNA795663_S_NODE_71_length_1661_cov_93.304187_g26_i2	PRJNA795663	71	1661	93.304187	1549.78254607	Synechococcus	1129	Bacteria	Bacteria	2449	0	NTclustered	gi\|146740640\|emb\|AM709627.1\|	115746	g26	i2	98.014	158.131848284166	1410	28	85	0	217	1626	3752	2343	Synechococcus sp. PCC 7920 partial ribosomal RNA operon, strain PCC 7920	blastn	262657	2471	0.991096721974909	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PCC 7920
16081722	16081722	PRJNA795663_S_NODE_10053_length_192_cov_2.987097_g9948_i0	PRJNA795663	10053	192	2.987097	5.73522624	Synechococcus sp. RS9909	221352	Bacteria	Bacteria	171	4.37e-38	NTclustered	gi\|1895776483\|gb\|CP047943.1\|	221352	g9948	i0	91.2	28.890625	125	11	65	0	1	125	502638	502762	Synechococcus sp. RS9909 chromosome, complete genome	blastn	5547	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RS9909
16081803	16081803	PRJNA795663_S_NODE_1413_length_466_cov_2.319347_g1308_i0	PRJNA795663	1413	466	2.319347	10.80815702	Synechococcus sp. CCFWC 502	2978474	Bacteria	Bacteria	664	0	NTclustered	gi\|2482403951\|gb\|CP114977.1\|	2978474	g1308	i0	93.318	70.0557939914163	449	30	96	0	1	449	71456	71904	Synechococcus sp. CCFWC 502 chromosome	blastn	32646	664	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CCFWC 502
20342783	20342783	PRJNA795663_S_NODE_18076_length_153_cov_1.120690_g17971_i0	PRJNA795663	18076	153	1.12069	1.7146557	Synechococcus	1129	Bacteria	Bacteria	231	1.4999999999999997e-56	NTclustered	gi\|1895782591\|gb\|CP047945.1\|	1442556	g17971	i0	94.079	89.5555555555556	152	9	99	0	2	153	479897	479746	Synechococcus sp. PROS-7-1 chromosome, complete genome	blastn	13702	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PROS-7-1
22456686	22456686	PRJNA795663_S_NODE_8038_length_212_cov_1.257143_g7933_i0	PRJNA795663	8038	212	1.257143	2.66514316	Synechococcus sp. NIES-947	2956744	Bacteria	Bacteria	340	3.55e-89	NTclustered	gi\|2415642351\|dbj\|LC716315.1\|	2956744	g7933	i0	98.446	90.2405660377358	193	3	91	0	1	193	338	146	Synechococcus sp. NIES-947 petB gene for cytochrome b6, partial cds	blastn	19131	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. NIES-947
22894047	22894047	PRJNA795663_S_NODE_798_length_592_cov_6.931532_g709_i0	PRJNA795663	798	592	6.931532	41.03466944	Synechococcus	1129	Bacteria	Bacteria	108	1.23e-18	NTclustered	gi\|2638507609\|emb\|OY986433.1\|	2789857	g709	i0	86.869	17.1368243243243	99	9	40	4	496	592	1257634	1257538	Synechococcus sp. CBW1107 isolate KAC_106 genome assembly, chromosome: 1	blastn	10145	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107
23732282	23732282	PRJNA795663_S_NODE_4019_length_288_cov_40.494024_g3914_i0	PRJNA795663	4019	288	40.494024	116.62278912	Synechococcus sp. SynAce01	1916956	Bacteria	Bacteria	460	3.74e-125	NTclustered	gi\|1104554094\|gb\|CP018091.1\|	1916956	g3914	i0	97.753	175.559027777778	267	6	93	0	1	267	797479	797745	Synechococcus sp. SynAce01 chromosome, complete genome	blastn	50561	460	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. SynAce01
23732375	23732375	PRJNA795663_S_NODE_8499_length_207_cov_1.147059_g8394_i0	PRJNA795663	8499	207	1.147059	2.37441213	Cyanobium gracile	59930	Bacteria	Bacteria	137	4.86e-28	NTclustered	gi\|427344508\|gb\|CP003495.1\|	292564	g8394	i0	91.089	3.71980676328502	101	9	49	0	41	141	2864496	2864396	Cyanobium gracile PCC 6307, complete genome	blastn	770	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
25005761	25005761	PRJNA795663_S_NODE_1620_length_440_cov_2.598015_g1515_i0	PRJNA795663	1620	440	2.598015	11.431266	Synechococcus sp. CBW1107	2789857	Bacteria	Bacteria	473	7.659999999999999e-129	NTclustered	gi\|1940473883\|gb\|CP064908.1\|	2789857	g1515	i0	88.665	73.0454545454545	397	34	90	8	22	415	1656453	1656065	Synechococcus sp. CBW1107 chromosome, complete genome	blastn	32140	473	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107

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