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

11 rows where analysis = "blastn", bioproject = "PRJNA488043" 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
5553509	5553509	PRJNA488043_P_NODE_4965_length_600_cov_8.604203_g3067_i0	PRJNA488043	4965	600	8.604203	51.625218	Gloeothece verrucosa	2546359	Bacteria	Bacteria	747	0	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g3067	i0	89.256	159.478333333333	605	54	100	10	1	600	1627150	1627748	Cyanothece sp. PCC 7822, complete genome	blastn	95687	747	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
9377861	9377861	PRJNA488043_S_NODE_608_length_238_cov_16.880383_g597_i0	PRJNA488043	608	238	16.880383	40.17531154	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	340	4.07e-89	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g597	i0	92.437	234.840336134454	238	18	100	0	1	238	3681446	3681683	Leptolyngbya sp. 7M chromosome	blastn	55892	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
13851512	13851512	PRJNA488043_P_NODE_13091_length_259_cov_5.734783_g10850_i0	PRJNA488043	13091	259	5.734783	14.85308797	Picosynechococcus	3079908	Bacteria	Bacteria	370	5.73e-98	NTclustered	gi\|169884305\|gb\|CP000951.1\|	32049	g10850	i0	92.664	173.08494208494201	259	15	100	4	1	259	1463823	1464077	Synechococcus sp. PCC 7002, complete genome	blastn	44829	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7002
14478344	14478344	PRJNA488043_P_NODE_13032_length_260_cov_20.744589_g10791_i0	PRJNA488043	13032	260	20.744589	53.9359314	Pleurocapsa concharum	980867	Bacteria	Bacteria	446	9.3e-121	NTclustered	gi\|322504118\|emb\|FR798929.1\|	980870	g10791	i0	97.692	102.661538461538	260	5	99	1	1	259	846	587	Pleurocapsa concharum VP3-02b partial 16S rRNA gene, strain VP3-02b	blastn	26692	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa concharum
14478443	14478443	PRJNA488043_P_NODE_20112_length_170_cov_4.638298_g17870_i0	PRJNA488043	20112	170	4.638298	7.8851066	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	254	3.63e-63	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17870	i0	93.567	1.00588235294118	171	9	100	2	1	170	197652	197483	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	171	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
15126061	15126061	PRJNA488043_S_NODE_932_length_196_cov_14.700599_g921_i0	PRJNA488043	932	196	14.700599	28.81317404	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	158	3.49e-34	NTclustered	gi\|428692674\|gb\|CP003944.1\|	13035	g921	i0	81.218	20.5408163265306	197	35	100	2	1	196	890168	889973	Dactylococcopsis salina PCC 8305, complete genome	blastn	4026	159	0.993710691823899	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Cymatolegaceae	Dactylococcopsis	Dactylococcopsis salina
17027153	17027153	PRJNA488043_P_NODE_20114_length_170_cov_4.361702_g17872_i0	PRJNA488043	20114	170	4.361702	7.4148934	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	254	3.63e-63	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17872	i0	93.567	1.00588235294118	171	9	100	2	1	170	197652	197483	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	171	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
20851595	20851595	PRJNA488043_P_NODE_4977_length_599_cov_8.187719_g3079_i0	PRJNA488043	4977	599	8.187719	49.04443681	Gloeothece verrucosa	2546359	Bacteria	Bacteria	732	0	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g3079	i0	88.87	175.580968280467	602	58	100	7	1	599	1626062	1626657	Cyanothece sp. PCC 7822, complete genome	blastn	105173	732	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
20851671	20851671	PRJNA488043_S_NODE_1657_length_150_cov_3.768595_g1646_i0	PRJNA488043	1657	150	3.768595	5.6528925	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	176	6.95e-40	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g1646	i0	88.356	135.6	146	17	99	0	2	147	4828195	4828340	Leptolyngbya sp. 7M chromosome	blastn	20340	176	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
21499764	21499764	PRJNA488043_P_NODE_16257_length_211_cov_1.357143_g14015_i0	PRJNA488043	16257	211	1.357143	2.86357173	Prochlorococcus	1218	Bacteria	Bacteria	67.6	6.62e-7	NTclustered	gi\|2895553815\|gb\|CP138929.1\|	59921	g14015	i0	84.507	1.20379146919431	71	8	33	3	51	120	1419716	1419648	Prochlorococcus marinus str. MIT 9107 chromosome, complete genome	blastn	254	67.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
22126288	22126288	PRJNA488043_P_NODE_16018_length_214_cov_1.524324_g13776_i0	PRJNA488043	16018	214	1.524324	3.26205336	Thermoleptolyngbya sp. PKUAC-SCTB121	2811482	Bacteria	Bacteria	128	3.04e-25	NTclustered	gi\|1992526127\|gb\|CP070366.1\|	2811482	g13776	i0	90	49.785046728972	100	8	46	2	116	214	4261305	4261207	Thermoleptolyngbya sp. PKUAC-SCTB121 chromosome, complete genome	blastn	10654	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya sp. PKUAC-SCTB121

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