metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax_clade = "Cyanobacteriota/Melainabacteria group"

17 rows where analysis = "blastn", bioproject = "PRJNA642647" 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
1158548	1158548	PRJNA642647_P_NODE_1821_length_257_cov_4.577273_g1771_i0	PRJNA642647	1821	257	4.577273	11.76359161	Oscillatoria	1158	Bacteria	Bacteria	394	3.37e-105	NTclustered	gi\|604494736\|gb\|KF029609.1\|	1211	g1771	i0	97.807	88.6964980544747	228	5	89	0	30	257	657	430	Uncultured cyanobacterium clone 10.1.11-006_Isolat_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22795	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1894231	1894231	PRJNA642647_P_NODE_842_length_385_cov_6.623563_g792_i0	PRJNA642647	842	385	6.623563	25.50071755	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	531	3.87e-146	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g792	i0	92.308	185.233766233766	377	23	97	3	1	373	3670160	3670534	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	71315	531	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
3710354	3710354	PRJNA642647_P_NODE_3923_length_181_cov_2.548611_g3873_i0	PRJNA642647	3923	181	2.548611	4.61298591	root	1	Root_unresolved	Root_unresolved	313	6.39e-81	NTclustered	gi\|326205807\|gb\|HQ827427.1\|	1211	g3873	i0	98.315	98.171270718232	178	3	98	0	1	178	554	377	Uncultured cyanobacterium clone ciam16_P1R2G11 16S ribosomal RNA gene, partial sequence	blastn	17769	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
4445689	4445689	PRJNA642647_P_NODE_464_length_512_cov_3.976842_g415_i0	PRJNA642647	464	512	3.976842	20.36143104	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	564	5.21e-156	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g415	i0	93.915	119.07421875	378	15	73	6	138	509	3669468	3669843	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	60966	564	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
6996579	6996579	PRJNA642647_P_NODE_6686_length_150_cov_2.141593_g6636_i0	PRJNA642647	6686	150	2.141593	3.2123895	cyanobacterium ARS04158_00005	1564713	Bacteria	Bacteria	270	3.1e-68	NTclustered	gi\|704000437\|gb\|KM676599.1\|	1564713	g6636	i0	100	121.193333333333	146	0	97	0	4	149	253	398	Cyanobacterium ARS04158_00005 23S ribosomal RNA gene, partial sequence	blastn	18179	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium ARS04158_00005
8811472	8811472	PRJNA642647_P_NODE_2687_length_211_cov_3.574713_g2637_i0	PRJNA642647	2687	211	3.574713	7.54264443	Alkalinema	1620700	Bacteria	Bacteria	279	7.81e-71	NTclustered	gi\|2067595960\|gb\|MZ567048.1\|	2859775	g2637	i0	91.22	124.009478672986	205	18	97	0	4	208	2228	2024	Alkalinema pantanalense DHCY212 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26166	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Alkalinema	Alkalinema pantanalense
10822209	10822209	PRJNA642647_P_NODE_2969_length_203_cov_2.602410_g2919_i0	PRJNA642647	2969	203	2.60241	5.2828923	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	191	3.59e-44	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g2919	i0	86.034	7.00492610837438	179	24	88	1	24	202	1478225	1478402	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	1422	191	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
11361971	11361971	PRJNA642647_P_NODE_469_length_508_cov_5.887473_g420_i0	PRJNA642647	469	508	5.887473	29.90836284	Oscillatoriales	1150	Bacteria	Bacteria	449	1.5099999999999998e-121	NTclustered	gi\|225696244\|gb\|FJ805911.1\|	1211	g420	i0	95.714	143.574803149606	280	11	98	1	3	282	2049	2327	Uncultured cyanobacterium clone AN2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	72936	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11361981	11361981	PRJNA642647_P_NODE_809_length_391_cov_4.898305_g759_i0	PRJNA642647	809	391	4.898305	19.15237255	Oscillatoriales	1150	Bacteria	Bacteria	444	5.28e-120	NTclustered	gi\|225696244\|gb\|FJ805911.1\|	1211	g759	i0	95.985	175.572890025575	274	10	70	1	116	389	2321	2049	Uncultured cyanobacterium clone AN2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	68649	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12637726	12637726	PRJNA642647_P_NODE_3170_length_197_cov_3.068750_g3120_i0	PRJNA642647	3170	197	3.06875	6.0454375	Cyanophyceae	3028117	Bacteria	Bacteria	353	4.18e-93	NTclustered	gi\|121489667\|emb\|AM259260.1\|	1211	g3120	i0	98.985	102.015228426396	197	2	100	0	1	197	973	777	Uncultured cyanobacterium partial 16S rRNA gene, isolate cln_1TU28C77	blastn	20097	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17736468	17736468	PRJNA642647_P_NODE_3734_length_185_cov_1.209459_g3684_i0	PRJNA642647	3734	185	1.209459	2.23749915	Oscillatoriales	1150	Bacteria	Bacteria	294	2.38e-75	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g3684	i0	95.652	138.064864864865	184	7	99	1	3	185	1717	1900	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25542	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19010044	19010044	PRJNA642647_P_NODE_2615_length_214_cov_1.988701_g2565_i0	PRJNA642647	2615	214	1.988701	4.25582014	Synechocystis	1142	Bacteria	Bacteria	283	6.139999999999999e-72	NTclustered	gi\|2032561288\|gb\|CP054306.1\|	2732530	g2565	i0	90.741	140.383177570093	216	14	99	4	2	214	626861	627073	Synechocystis sp. PCC 7338 chromosome, complete genome	blastn	30042	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7338
19010064	19010064	PRJNA642647_P_NODE_4855_length_166_cov_9.883721_g4805_i0	PRJNA642647	4855	166	9.883721	16.40697686	root	1	Root_unresolved	Root_unresolved	302	1.2500000000000001e-77	NTclustered	gi\|63022551\|gb\|DQ004310.1\|	1211	g4805	i0	99.398	184	166	1	100	0	1	166	213	48	Uncultured cyanobacterium clone PEN12 16S ribosomal RNA gene, partial sequence	blastn	30544	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20284964	20284964	PRJNA642647_P_NODE_3816_length_183_cov_2.335616_g3766_i0	PRJNA642647	3816	183	2.335616	4.27417728	Microcoleus	44471	Bacteria	Bacteria	327	2.31e-85	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g3766	i0	100	154.448087431694	177	0	97	0	4	180	2930	3106	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28264	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21020364	21020364	PRJNA642647_P_NODE_1657_length_269_cov_6.137931_g1607_i0	PRJNA642647	1657	269	6.137931	16.51103439	Stenomitos frigidus	1886765	Bacteria	Bacteria	403	5.91e-108	NTclustered	gi\|2814759481\|gb\|CP170648.1\|	3070788	g1607	i0	93.985	248.245353159851	266	16	99	0	4	269	18978	19243	MAG: Stenomitos frigidus ULC029 chromosome, complete genome	blastn	66778	403	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos frigidus
21020404	21020404	PRJNA642647_P_NODE_517_length_490_cov_5.953642_g468_i0	PRJNA642647	517	490	5.953642	29.1728458	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	368	4.18e-97	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g468	i0	92.885	105.728571428571	253	18	52	0	128	380	3670534	3670282	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	51807	368	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
23570710	23570710	PRJNA642647_P_NODE_3439_length_191_cov_1.409091_g3389_i0	PRJNA642647	3439	191	1.409091	2.69136381	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	305	1.14e-78	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g3389	i0	95.767	193.146596858639	189	8	99	0	1	189	512098	512286	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	36891	305	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);;