metadata: contig_metadata: 10 rows where bioproject = "PRJNA674050" and tax_clade = "Cyanobacteriota/Melainabacteria group"

10 rows where bioproject = "PRJNA674050" 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
644270	644270	PRJNA674050_P_NODE_41601_length_224_cov_7.059603_g41398_i0	PRJNA674050	41601	224	7.059603	15.81351072	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	233	6.62e-57	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g41398	i0	86.636	407.558035714286	217	22	95	5	12	224	4829680	4829467	Leptolyngbya sp. 7M chromosome	blastn	91293	233	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
9572342	9572342	PRJNA674050_P_NODE_27468_length_249_cov_0.880682_g27265_i0	PRJNA674050	27468	249	0.880682	2.19289818	Cyanophyceae	3028117	Bacteria	Bacteria	99	1.24e-22	NR	WP_010994866.1	1162	g27265	i0	69	5.21686746987952	71	22	85.5	0	247	35	227	297	WP_010994866.1 MULTISPECIES: hypothetical protein [Nostocaceae]	diamond	1299	100	0.99	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae
9572875	9572875	PRJNA674050_P_NODE_40988_length_232_cov_5.849057_g40785_i0	PRJNA674050	40988	232	5.849057	13.56981224	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	237	5.34e-58	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g40785	i0	85.169	56.8448275862069	236	29	100	6	1	232	3681153	3680920	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13188	237	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
10847606	10847606	PRJNA674050_P_NODE_19469_length_260_cov_1.582888_g19266_i0	PRJNA674050	19469	260	1.582888	4.1155088	Stanieria cyanosphaera	102116	Bacteria	Bacteria	248	2.8199999999999997e-61	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g19266	i0	83.908	52.0153846153846	261	40	100	2	1	260	741	482	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	13524	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
13397991	13397991	PRJNA674050_P_NODE_29511_length_248_cov_0.874286_g29308_i0	PRJNA674050	29511	248	0.874286	2.16822928	Pelatocladus sp. BLCC-F211	3342752	Bacteria	Bacteria	100	2.23e-22	NR	WP_374871703.1	3342752	g29308	i0	63.2	1.83870967741935	76	28	91.9	0	248	21	212	287	WP_374871703.1 DEAD/DEAH box helicase [Pelatocladus sp. BLCC-F211]	diamond	456	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Pelatocladus	Pelatocladus sp. BLCC-F211
18495598	18495598	PRJNA674050_P_NODE_10835_length_294_cov_85.755656_g10632_i0	PRJNA674050	10835	294	85.755656	252.12162864	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	496	1.05e-135	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g10632	i0	99.27	146.969387755102	274	2	93	0	1	274	5575426	5575153	Anabaena sp. YBS01 chromosome, complete genome	blastn	43209	496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
19770939	19770939	PRJNA674050_P_NODE_33876_length_245_cov_0.906977_g33673_i0	PRJNA674050	33876	245	0.906977	2.22209365	Synechococcus sp. LA31	2741953	Bacteria	Bacteria	294	3.33e-75	NTclustered	gi\|2045437416\|gb\|CP075523.1\|	2741953	g33673	i0	88.571	2.96734693877551	245	24	99	3	3	245	1269834	1269592	Synechococcus sp. LA31 chromosome	blastn	727	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. LA31
21568379	21568379	PRJNA674050_P_NODE_11777_length_289_cov_1.944444_g11574_i0	PRJNA674050	11777	289	1.944444	5.61944316	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	192	1.43e-58	NR	MCC7529114.1	2052166	g11574	i0	100	2.98961937716263	96	0	99.7	0	288	1	136	231	MCC7529114.1 sigma-70 family RNA polymerase sigma factor [Candidatus Melainabacteria bacterium]	diamond	864	192	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
28092440	28092440	PRJNA674050_P_NODE_4565_length_358_cov_3.712281_g4362_i0	PRJNA674050	4565	358	3.712281	13.28996598	Aphanizomenon flos-aquae WA1	1176	Bacteria	Bacteria	69.7	4.85e-12	NR	OBQ32396.1	1710896	g4362	i0	38.1	1.12290502793296	134	55	95.5	4	343	2	16	141	OBQ32396.1 MAG: hypothetical protein AN484_27995, partial [Aphanizomenon flos-aquae WA102]	diamond	402	69.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
29039912	29039912	PRJNA674050_P_NODE_37448_length_243_cov_0.917647_g37245_i0	PRJNA674050	37448	243	0.917647	2.22988221	Aliterella atlantica	1827278	Bacteria	Bacteria	120	3.28e-32	NR	WP_045054534.1	1827278	g37245	i0	88.1	0.827160493827161	67	5	82.7	1	3	203	123	186	WP_045054534.1 (2Fe-2S) ferredoxin domain-containing protein [Aliterella atlantica]	diamond	201	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica

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