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

18 rows where bioproject = "PRJNA1145997" 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
7942499	7942499	PRJNA1145997_P_NODE_32587_length_339_cov_6.654135_g29968_i0	PRJNA1145997	32587	339	6.654135	22.55751765	Thermocoleostomius sinensis	3065396	Bacteria	Bacteria	448	3.4899999999999997e-121	NTclustered	gi\|2407448737\|gb\|CP113797.1\|	2016057	g29968	i0	91.463	152.964601769911	328	24	96	3	14	339	1127985	1128310	Thermocoleostomius sinensis A174 chromosome, complete genome	blastn	51855	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermocoleostomius	Thermocoleostomius sinensis
10493225	10493225	PRJNA1145997_P_NODE_41489_length_257_cov_1.505435_g38870_i0	PRJNA1145997	41489	257	1.505435	3.86896795	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	149	1.9799999999999994e-42	NR	HEY9836497.1	2692181	g38870	i0	87	5.36964980544747	77	10	89.9	0	232	2	29	105	HEY9836497.1 hypothetical protein [Vampirovibrionales bacterium]	diamond	1380	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales			Vampirovibrionales bacterium
11236636	11236636	PRJNA1145997_P_NODE_20969_length_660_cov_8.056218_g18396_i0	PRJNA1145997	20969	660	8.056218	53.1710388	Oscillatoriales	1150	Bacteria	Bacteria	1158	0	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g18396	i0	99.685	183.474242424242	634	1	96	1	9	642	1442	810	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	121093	1158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
11768277	11768277	PRJNA1145997_P_NODE_44490_length_249_cov_0.886364_g41871_i0	PRJNA1145997	44490	249	0.886364	2.20704636	Cyanophyceae	3028117	Bacteria	Bacteria	144	1.55e-41	NR	WP_190767649.1	3028117	g41871	i0	94.5	0.879518072289157	73	4	88	0	30	248	1	73	WP_190767649.1 MULTISPECIES: phycobiliprotein lyase [Cyanophyceae]	diamond	219	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
13043391	13043391	PRJNA1145997_P_NODE_51111_length_216_cov_5.510490_g48492_i0	PRJNA1145997	51111	216	5.51049	11.9026584	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	331	2.19e-86	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g48492	i0	96.954	160.680555555556	197	6	91	0	20	216	1748	1944	Uncultured Chroococcidiopsis sp. clone AR2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34707	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13786922	13786922	PRJNA1145997_P_NODE_51231_length_213_cov_6.242857_g48612_i0	PRJNA1145997	51231	213	6.242857	13.29728541	Oscillatoriales	1150	Bacteria	Bacteria	361	2.7399999999999994e-95	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g48612	i0	100	169.399061032864	195	0	92	0	19	213	2404288	2404094	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	36082	361	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
23242104	23242104	PRJNA1145997_P_NODE_50939_length_220_cov_10.768707_g48320_i0	PRJNA1145997	50939	220	10.768707	23.6911554	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	315	2.25e-81	NTclustered	gi\|225696177\|gb\|FJ805844.1\|	259957	g48320	i0	95.025	110.090909090909	201	9	91	1	1	200	2066	1866	Uncultured Chroococcidiopsis sp. clone AU1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24220	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24515734	24515734	PRJNA1145997_P_NODE_7640_length_1453_cov_48.775362_g6551_i0	PRJNA1145997	7640	1453	48.775362	708.70600986	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2034	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g6551	i0	92.502	122.852718513421	1427	98	98	7	20	1440	1619	3042	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	178505	2034	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
26943898	26943898	PRJNA1145997_P_NODE_36882_length_290_cov_1.437788_g34263_i0	PRJNA1145997	36882	290	1.437788	4.1695852	Leptolyngbya sp. DQ-M1	2933920	Bacteria	Bacteria	188	2.7699999999999997e-57	NR	WP_348243873.1	2933920	g34263	i0	88.5	0.993103448275862	96	11	99.3	0	290	3	103	198	WP_348243873.1 glycosyltransferase family 2 protein [Leptolyngbya sp. DQ-M1]	diamond	288	188	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. DQ-M1
27671000	27671000	PRJNA1145997_P_NODE_37624_length_284_cov_1.450237_g35005_i0	PRJNA1145997	37624	284	1.450237	4.11867308	Oscillatoriaceae cyanobacterium SKYG93	2972688	Bacteria	Bacteria	43.1	0.00576	NR	MCS6791363.1	2972688	g35005	i0	59.5	0.390845070422535	37	15	39.1	0	170	280	11	47	MCS6791363.1 hypothetical protein [Oscillatoriaceae cyanobacterium SKYG93]	diamond	111	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae		Oscillatoriaceae cyanobacterium SKYG93
27702703	27702703	PRJNA1145997_P_NODE_37344_length_286_cov_2.056338_g34725_i0	PRJNA1145997	37344	286	2.0563380000000002	5.88112668	Pseudanabaena sp.	1153	Bacteria	Bacteria	95.9	1.32e-20	NR	MFN7465328.1	1153	g34725	i0	55.1	0.933566433566434	89	37	92.3	2	283	20	451	537	MFN7465328.1 hypothetical protein [Pseudanabaena sp.]	diamond	267	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
28712836	28712836	PRJNA1145997_P_NODE_48887_length_242_cov_1.384615_g46268_i0	PRJNA1145997	48887	242	1.384615	3.3507683	Leptolyngbya sp. DQ-M1	2933920	Bacteria	Bacteria	75.9	7.81e-14	NR	WP_348243858.1	2933920	g46268	i0	87.8	1.01652892561983	41	5	50.8	0	241	119	563	603	WP_348243858.1 SLBB domain-containing protein [Leptolyngbya sp. DQ-M1]	diamond	246	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. DQ-M1
29123513	29123513	PRJNA1145997_P_NODE_44389_length_249_cov_1.761364_g41770_i0	PRJNA1145997	44389	249	1.761364	4.38579636	Thermosynechococcaceae cyanobacterium MS004	2881380	Bacteria	Bacteria	45.1	0.00543	NR	MCG9891895.1	2881380	g41770	i0	52.4	0.506024096385542	42	18	48.2	1	59	178	21	62	MCG9891895.1 prohibitin family protein [Thermosynechococcaceae cyanobacterium MS004]	diamond	126	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae		Thermosynechococcaceae cyanobacterium MS004
29375784	29375784	PRJNA1145997_P_NODE_35249_length_307_cov_1.000000_g32630_i0	PRJNA1145997	35249	307	1	3.07	Calothrix sp. MO_167.B12	3036781	Bacteria	Bacteria	136	9.68e-38	NR	MDJ0798473.1	3036781	g32630	i0	66.3	0.986970684039088	101	34	98.7	0	305	3	41	141	MDJ0798473.1 nucleotidyltransferase family protein [Calothrix sp. MO_167.B12]	diamond	303	136	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. MO_167.B12
29596463	29596463	PRJNA1145997_P_NODE_36770_length_291_cov_1.431193_g34151_i0	PRJNA1145997	36770	291	1.431193	4.16477163	Woronichinia naegeliana WA131	2824559	Bacteria	Bacteria	60.1	3.65e-8	NR	UXE64910.1	2824559	g34151	i0	41.6	1.89690721649485	89	49	90.7	2	286	23	50	136	UXE64910.1 MAG: AAA family ATPase [Woronichinia naegeliana WA131]	diamond	552	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
30133417	30133417	PRJNA1145997_P_NODE_50212_length_232_cov_3.320755_g47593_i0	PRJNA1145997	50212	232	3.320755	7.7041516	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	142	5.68e-39	NR	MBW4638843.1	2839657	g47593	i0	88.3	0.995689655172414	77	9	99.6	0	2	232	119	195	MBW4638843.1 hypothetical protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	231	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
32241067	32241067	PRJNA1145997_P_NODE_38098_length_280_cov_2.256039_g35479_i0	PRJNA1145997	38098	280	2.256039	6.3169092	Bacteria	2	Bacteria	Bacteria	164	1.21e-44	NR	MBD1833294.1	2692764	g35479	i0	84.9	1.99285714285714	93	14	99.6	0	279	1	915	1007	MBD1833294.1 toxin [Cyanobacteria bacterium FACHB-472]	diamond	558	165	0.993939393939394	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium FACHB-472
32809108	32809108	PRJNA1145997_P_NODE_35840_length_300_cov_4.246696_g33221_i0	PRJNA1145997	35840	300	4.246696	12.740088	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	58.5	2.07e-7	NR	MFM6550951.1	513223	g33221	i0	57.1	0.98	49	21	49	0	158	12	858	906	MFM6550951.1 endonuclease domain-containing protein [Microcystis panniformis]	diamond	294	58.9	0.99320882852292	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis panniformis

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