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

18 rows where bioproject = "PRJEB58983" 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
124600	124600	PRJEB58983_P_NODE_10961_length_379_cov_2.751634_g10546_i0	PRJEB58983	10961	379	2.751634	10.42869286	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	342	1.9099999999999994e-89	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g10546	i0	83.607	88.5646437994723	366	59	97	1	12	377	1222539	1222903	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	33566	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
124833	124833	PRJEB58983_P_NODE_2261_length_837_cov_2.278796_g1896_i0	PRJEB58983	2261	837	2.278796	19.07352252	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	688	0	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g1896	i0	81.7	456.307048984468	847	135	100	19	1	837	597513	598349	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	381929	688	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6503148	6503148	PRJEB58983_P_NODE_25046_length_265_cov_1.265625_g24631_i0	PRJEB58983	25046	265	1.265625	3.35390625	Synechococcus sp. UTEX LB 2390	2137605	Bacteria	Bacteria	448	2.6399999999999996e-121	NTclustered	gi\|1373447567\|gb\|KY979129.1\|	2137605	g24631	i0	97.004	156.166037735849	267	6	100	2	1	265	416	150	Synechococcus sp. UTEX LB 2390 23S ribosomal RNA gene, partial sequence	blastn	41384	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. UTEX LB 2390
6503494	6503494	PRJEB58983_P_NODE_9866_length_397_cov_4.361111_g9452_i0	PRJEB58983	9866	397	4.361111	17.31361067	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	313	1.58e-80	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g9452	i0	81.538	231.561712846348	390	62	97	8	7	391	1223375	1222991	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	91930	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
9052265	9052265	PRJEB58983_P_NODE_30688_length_246_cov_0.901734_g30273_i0	PRJEB58983	30688	246	0.901734	2.21826564	[Synechococcus] sp. NIES-970	1827144	Bacteria	Bacteria	239	1.59e-58	NTclustered	gi\|1143527503\|dbj\|AP017959.1\|	1827144	g30273	i0	84.362	23.260162601626	243	38	99	0	1	243	397881	397639	Synechococcus sp. NIES-970 DNA, complete genome	blastn	5722	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Synechococcus] sp. NIES-970
10327762	10327762	PRJEB58983_P_NODE_15589_length_324_cov_1.776892_g15174_i0	PRJEB58983	15589	324	1.776892	5.75713008	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	532	8.92e-147	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g15174	i0	96.296	137.148148148148	324	12	100	0	1	324	3682130	3682453	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	44436	532	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
12878496	12878496	PRJEB58983_P_NODE_23151_length_273_cov_4.760000_g22736_i0	PRJEB58983	23151	273	4.76	12.9948	Pseudanabaenaceae cyanobacterium PMC-1017.18	2575741	Bacteria	Bacteria	483	7.5e-132	NTclustered	gi\|1628791265\|gb\|MK874330.1\|	2575741	g22736	i0	98.535	99.2564102564103	273	4	100	0	1	273	378	650	Pseudanabaenaceae cyanobacterium PMC-1017.18 16S ribosomal RNA gene, partial sequence	blastn	27097	483	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae		Pseudanabaenaceae cyanobacterium PMC-1017.18
15427216	15427216	PRJEB58983_P_NODE_20333_length_288_cov_1.790698_g19918_i0	PRJEB58983	20333	288	1.790698	5.15721024	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	246	1.14e-60	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g19918	i0	85.306	153.03125	245	29	84	7	33	274	511544	511304	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	44073	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
17976397	17976397	PRJEB58983_P_NODE_19495_length_293_cov_1.168182_g19080_i0	PRJEB58983	19495	293	1.168182	3.42277326	uncultured cyanobacterium	1211	Bacteria	Bacteria	501	2.24e-137	NTclustered	gi\|429732865\|gb\|JX887884.1\|	1211	g19080	i0	97.603	100.334470989761	292	7	99	0	2	293	1248	957	Uncultured cyanobacterium clone Emix2.2 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, and tRNA-Ile gene, partial sequence	blastn	29398	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26875667	26875667	PRJEB58983_P_NODE_15281_length_327_cov_1.500000_g14866_i0	PRJEB58983	15281	327	1.5	4.905	Richelia sp. RM2_1_2	2720436	Bacteria	Bacteria	124	2.14e-33	NR	NJO65226.1	2720436	g14866	i0	51.8	1.00917431192661	110	51	99.1	2	326	3	15	124	NJO65226.1 hypothetical protein [Richelia sp. RM2_1_2]	diamond	330	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. RM2_1_2
26938518	26938518	PRJEB58983_P_NODE_27302_length_255_cov_1.631868_g26887_i0	PRJEB58983	27302	255	1.631868	4.1612634	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	145	8.92e-41	NR	MEY3767064.1	2847862	g26887	i0	81.2	1	85	16	100	0	255	1	69	153	MEY3767064.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	255	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27500970	27500970	PRJEB58983_P_NODE_32503_length_242_cov_0.917160_g32088_i0	PRJEB58983	32503	242	0.91716	2.2195272	Cyanophyceae	3028117	Bacteria	Bacteria	76.3	5.85e-14	NR	MFM7571698.1	2164131	g32088	i0	59.1	2.62809917355372	66	27	81.8	0	198	1	658	723	MFM7571698.1 PAS domain S-box protein [Snowella sp.]	diamond	636	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Snowella	Snowella sp.
28233527	28233527	PRJEB58983_P_NODE_4066_length_605_cov_3.024436_g3658_i0	PRJEB58983	4066	605	3.024436	18.2978378	Richelia sp. RM2_1_2	2720436	Bacteria	Bacteria	301	2.99e-92	NR	NJO61051.1	2720436	g3658	i0	71.3	1.94380165289256	195	56	96.7	0	2	586	896	1090	NJO61051.1 hypothetical protein [Richelia sp. RM2_1_2]	diamond	1176	301	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. RM2_1_2
29433275	29433275	PRJEB58983_P_NODE_11770_length_367_cov_2.193878_g11355_i0	PRJEB58983	11770	367	2.193878	8.05153226	Richelia sp. RM2_1_2	2720436	Bacteria	Bacteria	89.7	4.04e-18	NR	NJO64997.1	2720436	g11355	i0	53.5	0.70299727520436	86	39	69.5	1	67	321	138	223	NJO64997.1 hypothetical protein [Richelia sp. RM2_1_2]	diamond	258	89.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. RM2_1_2
31930063	31930063	PRJEB58983_P_NODE_29577_length_248_cov_3.377143_g29162_i0	PRJEB58983	29577	248	3.377143	8.37531464	Synechococcus sp.	1131	Bacteria	Bacteria	49.3	2e-4	NR	MEB3264481.1	1131	g29162	i0	39.1	0.834677419354839	69	42	83.5	0	31	237	926	994	MEB3264481.1 CHAT domain-containing protein [Synechococcus sp.]	diamond	207	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp.
32081485	32081485	PRJEB58983_P_NODE_32478_length_242_cov_0.923077_g32063_i0	PRJEB58983	32478	242	0.923077	2.23384634	Cyanophyceae	3028117	Bacteria	Bacteria	149	1.06e-41	NR	WP_281005840.1	1152	g32063	i0	90	7.90909090909091	80	8	99.2	0	241	2	166	245	WP_281005840.1 MULTISPECIES: pseudaminic acid synthase [Pseudanabaena]	diamond	1914	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena
32246897	32246897	PRJEB58983_P_NODE_29578_length_248_cov_3.371429_g29163_i0	PRJEB58983	29578	248	3.371429	8.36114392	Gloeothece verrucosa	2546359	Bacteria	Bacteria	47.8	5.87e-4	NR	WP_063820729.1	2546359	g29163	i0	41.2	0.616935483870968	51	27	61.7	1	174	22	101	148	WP_063820729.1 hypothetical protein [Gloeothece verrucosa]	diamond	153	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
32846278	32846278	PRJEB58983_P_NODE_22700_length_276_cov_1.167488_g22285_i0	PRJEB58983	22700	276	1.167488	3.22226688	Elainella sp. Prado103	2929572	Bacteria	Bacteria	44.7	0.00365	NR	MCU0524949.1	2929572	g22285	i0	47.1	0.369565217391304	34	18	37	0	269	168	79	112	MCU0524949.1 WD40 domain-containing protein [Elainella sp. Prado103]	diamond	102	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Elainella	Elainella sp. Prado103

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