metadata: contig_metadata: 17 rows where bioproject = "PRJNA939369" and tax_clade = "Cyanobacteriota/Melainabacteria group"

17 rows where bioproject = "PRJNA939369" 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
3808107	3808107	PRJNA939369_S_NODE_44563_length_267_cov_2.304124_g44146_i0	PRJNA939369	44563	267	2.304124	6.15201108	Synechococcus	1129	Bacteria	Bacteria	479	9.46e-131	NTclustered	gi\|2230632934\|gb\|CP096032.1\|	2936507	g44146	i0	99.245	84.2584269662921	265	2	99	0	3	267	1550632	1550896	Synechococcus sp. A10-1-5-1 chromosome, complete genome	blastn	22497	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. A10-1-5-1
6017514	6017514	PRJNA939369_S_NODE_32285_length_294_cov_2.447964_g31868_i0	PRJNA939369	32285	294	2.447964	7.19701416	Brasilonema sennae	1397703	Bacteria	Bacteria	499	8.099999999999998e-137	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g31868	i0	97.279	275.265306122449	294	8	100	0	1	294	1169018	1169311	Brasilonema sennae CENA114 chromosome	blastn	80928	499	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
11118018	11118018	PRJNA939369_S_NODE_39629_length_277_cov_1.450980_g39212_i0	PRJNA939369	39629	277	1.45098	4.0192146	Pleurocapsa sp. PCC 7327	118163	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|427977893\|gb\|CP003590.1\|	118163	g39212	i0	100	0.108303249097473	30	0	11	0	22	51	3116996	3117025	Pleurocapsa sp. PCC 7327, complete genome	blastn	30	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7327
16217554	16217554	PRJNA939369_S_NODE_72693_length_243_cov_0.870588_g72276_i0	PRJNA939369	72693	243	0.870588	2.11552884	Synechococcus sp. LTW-R	2751170	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|1891299085\|gb\|CP059060.1\|	2751170	g72276	i0	98.765	15.2592592592593	243	3	100	0	1	243	1533269	1533027	Synechococcus sp. LTW-R chromosome, complete genome	blastn	3708	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. LTW-R
19107481	19107481	PRJNA939369_S_NODE_5915_length_510_cov_4.633867_g5498_i0	PRJNA939369	5915	510	4.633867	23.6327217	Wilmottia	1048851	Bacteria	Bacteria	843	0	NTclustered	gi\|1700116479\|gb\|MN158648.1\|	2593982	g5498	i0	97.947	161.954901960784	487	9	95	1	24	510	1900	2385	Wilmottia murrayi ACKU581 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	82597	843	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Wilmottia	Wilmottia murrayi
21316528	21316528	PRJNA939369_S_NODE_557_length_1411_cov_8.402840_g339_i0	PRJNA939369	557	1411	8.40284	118.5640724	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1860	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g339	i0	90.61	156.128277817151	1427	99	100	25	1	1411	3527	2120	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	220297	1860	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21316655	21316655	PRJNA939369_S_NODE_72337_length_243_cov_0.905882_g71920_i0	PRJNA939369	72337	243	0.905882	2.20129326	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	250	7.2399999999999995e-62	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g71920	i0	85.246	4.12345679012346	244	34	100	2	1	243	2654904	2655146	Synechococcus sp. CB0101 chromosome, complete genome	blastn	1002	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
23866855	23866855	PRJNA939369_S_NODE_57979_length_250_cov_0.870056_g57562_i0	PRJNA939369	57979	250	0.870056	2.17514	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	250	7.48e-62	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g57562	i0	87.907	8.212	215	22	85	2	26	238	6373152	6373364	Allocoleopsis franciscana PCC 7113, complete genome	blastn	2053	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
26961544	26961544	PRJNA939369_S_NODE_22262_length_327_cov_1.515748_g21845_i0	PRJNA939369	22262	327	1.515748	4.95649596	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	199	1.8299999999999999e-62	NR	MBR5303442.1	2137880	g21845	i0	88	0.990825688073395	108	13	99.1	0	325	2	39	146	MBR5303442.1 hypothetical protein [Candidatus Gastranaerophilales bacterium]	diamond	324	199	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
27853248	27853248	PRJNA939369_S_NODE_2524_length_709_cov_1.573899_g2134_i0	PRJNA939369	2524	709	1.573899	11.15894391	root	1	Root_unresolved	Root_unresolved	138	4.15e-36	NR	MBE7708938.1	2775576	g2134	i0	33.3	2.00141043723554	240	149	99	5	6	707	24	258	MBE7708938.1 HNH endonuclease [Cyanobacteria bacterium SIG32]	diamond	1419	139	0.992805755395683	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SIG32
29204183	29204183	PRJNA939369_S_NODE_74849_length_242_cov_0.863905_g74432_i0	PRJNA939369	74849	242	0.863905	2.0906501	Prochlorococcus marinus	1219	Bacteria	Bacteria	42.7	0.0352	NR	WP_011824859.1	1219	g74432	i0	37.7	0.756198347107438	61	31	66.9	1	240	79	165	225	WP_011824859.1 carbohydrate kinase family protein [Prochlorococcus marinus]	diamond	183	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
29495169	29495169	PRJNA939369_S_NODE_14330_length_376_cov_1.089109_g13913_i0	PRJNA939369	14330	376	1.089109	4.09504984	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	45.1	0.0168	NR	MBW4622782.1	1874554	g13913	i0	53.7	3.71808510638298	41	19	32.7	0	326	204	3	43	MBW4622782.1 translation elongation factor Ts [Cyanosarcina radialis HA8281-LM2]	diamond	1398	45.4	0.993392070484582	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Cyanosarcina	Cyanosarcina radialis
30498991	30498991	PRJNA939369_S_NODE_5713_length_517_cov_1.497748_g5296_i0	PRJNA939369	5713	517	1.497748	7.74335716	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	70.1	1.67e-10	NR	MBR5303451.1	2137880	g5296	i0	50	0.382978723404255	66	33	38.3	0	11	208	77	142	MBR5303451.1 tail fiber protein [Candidatus Gastranaerophilales bacterium]	diamond	198	70.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
30846510	30846510	PRJNA939369_S_NODE_13814_length_381_cov_0.912338_g13397_i0	PRJNA939369	13814	381	0.912338	3.47600778	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	65.9	6.76e-10	NR	MBR5303416.1	2137880	g13397	i0	64.3	0.440944881889764	56	20	44.1	0	380	213	206	261	MBR5303416.1 hypothetical protein [Candidatus Gastranaerophilales bacterium]	diamond	168	65.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
31383942	31383942	PRJNA939369_S_NODE_57676_length_250_cov_0.870056_g57259_i0	PRJNA939369	57676	250	0.870056	2.17514	Synechococcaceae cyanobacterium	2588875	Bacteria	Bacteria	44.7	0.00824	NR	MFN9695637.1	2588875	g57259	i0	37.2	0.936	78	41	90	2	9	233	46	118	MFN9695637.1 NADPH-dependent assimilatory sulfite reductase hemoprotein subunit [Synechococcaceae cyanobacterium]	diamond	234	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae cyanobacterium
32206344	32206344	PRJNA939369_S_NODE_51398_length_256_cov_1.016393_g50981_i0	PRJNA939369	51398	256	1.016393	2.60196608	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	92.8	5.45e-22	NR	MBR5303438.1	2137880	g50981	i0	67.2	0.71484375	61	20	71.5	0	185	3	3	63	MBR5303438.1 hypothetical protein [Candidatus Gastranaerophilales bacterium]	diamond	183	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
32269764	32269764	PRJNA939369_S_NODE_2658_length_694_cov_1.526570_g2264_i0	PRJNA939369	2658	694	1.52657	10.5943958	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	312	2.7499999999999993e-104	NR	MBR5303416.1	2137880	g2264	i0	85.4	0.739193083573487	171	25	73.9	0	514	2	1	171	MBR5303416.1 hypothetical protein [Candidatus Gastranaerophilales bacterium]	diamond	513	312	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales 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);;