metadata: contig_metadata: 18 rows where bioproject = "PRJNA690124" and tax_clade = "Cyanobacteriota/Melainabacteria group"

18 rows where bioproject = "PRJNA690124" 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
3220312	3220312	PRJNA690124_P_NODE_41263_length_258_cov_2.951351_g40897_i0	PRJNA690124	41263	258	2.951351	7.61448558	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	416	7.229999999999998e-112	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g40897	i0	95.736	162.895348837209	258	11	100	0	1	258	3670328	3670585	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	42027	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
8322773	8322773	PRJNA690124_P_NODE_5127_length_701_cov_2.730892_g4780_i0	PRJNA690124	5127	701	2.730892	19.14355292	Nodosilinea sp. 2.2B	2876719	Bacteria	Bacteria	1229	0	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g4780	i0	98.288	168.666191155492	701	12	100	0	1	701	2647	1947	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	118235	1229	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
8322915	8322915	PRJNA690124_P_NODE_57307_length_211_cov_4.202899_g56941_i0	PRJNA690124	57307	211	4.202899	8.86811689	Nodosilinea sp. 2.2B	2876719	Bacteria	Bacteria	390	3.459999999999999e-104	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g56941	i0	100	157.284360189573	211	0	100	0	1	211	3493	3703	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33187	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
11381721	11381721	PRJNA690124_P_NODE_17509_length_387_cov_1.442675_g17143_i0	PRJNA690124	17509	387	1.442675	5.58315225	Pleurocapsales	52604	Bacteria	Bacteria	671	0	NTclustered	gi\|2075441650\|ref\|NR_172667.1\|	54308	g17143	i0	97.938	101.049095607235	388	7	100	1	1	387	486	873	Pleurocapsa minor strain HA4230-MV1 16S ribosomal RNA, complete sequence	blastn	39106	671	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa minor
13932452	13932452	PRJNA690124_P_NODE_32871_length_289_cov_1.759259_g32505_i0	PRJNA690124	32871	289	1.759259	5.08425851	root	1	Root_unresolved	Root_unresolved	126	1.5499999999999998e-24	NTclustered	gi\|311115847\|gb\|HQ329074.1\|	1211	g32505	i0	100	23.757785467128	68	0	24	0	222	289	494	427	Uncultured cyanobacterium clone LvLM1.2.16 16S ribosomal RNA gene, partial sequence	blastn	6866	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14697923	14697923	PRJNA690124_P_NODE_20432_length_359_cov_2.248252_g20066_i0	PRJNA690124	20432	359	2.248252	8.07122468	Aliterella chasmolithica	2739056	Bacteria	Bacteria	525	1.6699999999999996e-144	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g20066	i0	94.925	173.779944289694	335	17	93	0	25	359	2500	2166	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	62387	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
14698419	14698419	PRJNA690124_P_NODE_43672_length_253_cov_0.866667_g43306_i0	PRJNA690124	43672	253	0.866667	2.19266751	Oscillatoriaceae cyanobacterium	2664179	Bacteria	Bacteria	89.4	3.06e-19	NR	HEY9724626.1	2664179	g43306	i0	61	1.99209486166008	82	29	97.2	1	6	251	130	208	HEY9724626.1 response regulator [Oscillatoriaceae cyanobacterium]	diamond	504	89.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae		Oscillatoriaceae cyanobacterium
14698735	14698735	PRJNA690124_P_NODE_6412_length_632_cov_1.844365_g6053_i0	PRJNA690124	6412	632	1.844365	11.6563868	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	1040	0	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g6053	i0	96.378	178.773734177215	635	17	100	4	1	632	3669604	3670235	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	112985	1040	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
21580781	21580781	PRJNA690124_P_NODE_4377_length_754_cov_4.483113_g4046_i0	PRJNA690124	4377	754	4.483113	33.80267202	Nodosilinea	1120752	Bacteria	Bacteria	1382	0	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g4046	i0	99.735	153.781167108753	754	2	100	0	1	754	2625	3378	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	115951	1382	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
25405025	25405025	PRJNA690124_P_NODE_37620_length_271_cov_1.575758_g37254_i0	PRJNA690124	37620	271	1.575758	4.27030418	Nostoc	1177	Bacteria	Bacteria	353	6.08e-93	NTclustered	gi\|930349143\|gb\|CP012036.1\|	224013	g37254	i0	90.406	231.752767527675	271	23	99	3	1	270	379918	379650	Nostoc piscinale CENA21 chromosome	blastn	62805	355	0.994366197183099	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc piscinale
26987333	26987333	PRJNA690124_P_NODE_45362_length_251_cov_0.876404_g44996_i0	PRJNA690124	45362	251	0.876404	2.19977404	Leptolyngbya sp. KIOST-1	1229172	Bacteria	Bacteria	168	1.59e-47	NR	WP_263970550.1	1229172	g44996	i0	98.8	0.9800796812749	82	1	98	0	250	5	278	359	WP_263970550.1 transglutaminase-like domain-containing protein [Leptolyngbya sp. KIOST-1]	diamond	246	168	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. KIOST-1
27208587	27208587	PRJNA690124_P_NODE_33222_length_288_cov_1.153488_g32856_i0	PRJNA690124	33222	288	1.153488	3.32204544	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	81.6	1.76e-16	NR	MBY0496793.1	2847862	g32856	i0	100	0.385416666666667	37	0	38.5	0	288	178	194	230	MBY0496793.1 TRAP transporter TatT component family protein [Cyanobacteriota bacterium]	diamond	111	81.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27587981	27587981	PRJNA690124_P_NODE_51224_length_246_cov_0.901734_g50858_i0	PRJNA690124	51224	246	0.901734	2.21826564	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	47.4	9.16e-4	NR	MBC7474511.1	2762020	g50858	i0	46.5	0.865853658536585	71	31	80.5	2	219	22	455	523	MBC7474511.1 IS200/IS605 family element transposase accessory protein TnpB [Candidatus Sericytochromatia bacterium]	diamond	213	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
27998524	27998524	PRJNA690124_P_NODE_34025_length_285_cov_0.990566_g33659_i0	PRJNA690124	34025	285	0.990566	2.8231131	unclassified Synechococcus	2626047	Bacteria	Bacteria	106	5.35e-28	NR	WP_255131134.1	2626047	g33659	i0	91.8	0.642105263157895	61	5	64.2	0	99	281	1	61	WP_255131134.1 MULTISPECIES: DUF2862 domain-containing protein [unclassified Synechococcus]	diamond	183	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus
28388647	28388647	PRJNA690124_P_NODE_526_length_1674_cov_3.620237_g439_i0	PRJNA690124	526	1674	3.620237	60.60276738	root	1	Root_unresolved	Root_unresolved	235	2.76e-69	NR	WP_104396736.1	1125	g439	i0	43.9	2.52329749103943	285	154	50.2	4	1609	770	2	285	WP_104396736.1 MULTISPECIES: follicular epithelium yolk protein subunit [Microcystis]	diamond	4224	237	0.991561181434599	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis
28630031	28630031	PRJNA690124_P_NODE_52807_length_245_cov_0.906977_g52441_i0	PRJNA690124	52807	245	0.906977	2.22209365	Synechococcus sp.	1131	Bacteria	Bacteria	125	2.44e-35	NR	MEB3270085.1	1131	g52441	i0	78.8	0.979591836734694	80	17	98	0	2	241	19	98	MEB3270085.1 DUF1257 domain-containing protein [Synechococcus sp.]	diamond	240	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp.
29387748	29387748	PRJNA690124_P_NODE_34909_length_281_cov_1.500000_g34543_i0	PRJNA690124	34909	281	1.5	4.215	Crocosphaera sp.	2729996	Bacteria	Bacteria	43.9	0.0231	NR	MDJ0661407.1	2729996	g34543	i0	31.6	0.811387900355872	76	50	79	1	236	15	206	281	MDJ0661407.1 NACHT domain-containing protein [Crocosphaera sp.]	diamond	228	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera sp.
29829580	29829580	PRJNA690124_P_NODE_34211_length_284_cov_1.165877_g33845_i0	PRJNA690124	34211	284	1.165877	3.31109068	Synechococcus sp. UW14	1131	Bacteria	Bacteria	209	1.45e-61	NR	WP_341882169.1	368503	g33845	i0	97.9	0.992957746478873	94	2	99.3	0	2	283	80	173	WP_341882169.1 1,4-alpha-glucan branching protein GlgB [Synechococcus sp. UW140]	diamond	282	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. UW140

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