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

11 rows where analysis = "blastn", bioproject = "PRJNA851399" 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
3390333	3390333	PRJNA851399_P_NODE_8523_length_284_cov_1.187234_g8070_i0	PRJNA851399	8523	284	1.187234	3.37174456	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	337	6.46e-88	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g8070	i0	88.112	165.866197183099	286	30	100	4	1	284	2874	3157	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47106	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5061973	5061973	PRJNA851399_P_NODE_23544_length_170_cov_0.925620_g23091_i0	PRJNA851399	23544	170	0.92562	1.573554	Cyanophyceae	3028117	Bacteria	Bacteria	235	1.3199999999999998e-57	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g23091	i0	91.716	293.135294117647	169	14	99	0	2	170	792834	793002	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	49833	237	0.991561181434599	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5062051	5062051	PRJNA851399_P_NODE_3744_length_557_cov_5.261811_g3313_i0	PRJNA851399	3744	557	5.261811	29.30828727	Bacteria	2	Bacteria	Bacteria	970	0	NTclustered	gi\|691483301\|gb\|KM006915.1\|	1211	g3313	i0	98.032	100.411131059246	559	9	100	2	1	557	10	568	Uncultured cyanobacterium clone 4B-30 16S ribosomal RNA gene, partial sequence	blastn	55929	979	0.990806945863126	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
7217242	7217242	PRJNA851399_P_NODE_10346_length_244_cov_1.564103_g9893_i0	PRJNA851399	10346	244	1.564103	3.81641132	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	320	5.46e-83	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g9893	i0	96.392	149.516393442623	194	7	80	0	1	194	1857875	1857682	Calothrix sp. PCC 7716 DNA, complete genome	blastn	36482	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
7217745	7217745	PRJNA851399_P_NODE_8346_length_289_cov_1.725000_g7893_i0	PRJNA851399	8346	289	1.725	4.98525	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	462	1.04e-125	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g7893	i0	95.502	165.63321799308	289	13	100	0	1	289	1951	1663	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47868	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8492364	8492364	PRJNA851399_P_NODE_34947_length_163_cov_0.894737_g34494_i0	PRJNA851399	34947	163	0.894737	1.45842131	Halotia branconii	1620816	Bacteria	Bacteria	198	1.6499999999999999e-46	NTclustered	gi\|2500982325\|gb\|CP124543.1\|	1539056	g34494	i0	88.82	4.92638036809816	161	18	99	0	2	162	3993513	3993673	Halotia branconii CENA392 chromosome, complete genome	blastn	803	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Halotia	Halotia branconii
8492414	8492414	PRJNA851399_P_NODE_37587_length_162_cov_0.902655_g37134_i0	PRJNA851399	37587	162	0.902655	1.4623011	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	143	7.78e-30	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g37134	i0	83.23	0.993827160493827	161	21	98	6	2	159	7096800	7096957	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	161	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
9767307	9767307	PRJNA851399_P_NODE_20788_length_176_cov_1.196850_g20335_i0	PRJNA851399	20788	176	1.19685	2.106456	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g20335	i0	99.432	229.721590909091	176	1	100	0	1	176	1858894	1858719	Calothrix sp. PCC 7716 DNA, complete genome	blastn	40431	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
10162304	10162304	PRJNA851399_P_NODE_10088_length_248_cov_3.422111_g9635_i0	PRJNA851399	10088	248	3.422111	8.48683528	Bacteria	2	Bacteria	Bacteria	407	4.16e-109	NTclustered	gi\|171673241\|gb\|EU409857.1\|	1211	g9635	i0	96.356	98.3427419354839	247	9	99	0	2	248	250	4	Uncultured cyanobacterium clone 16S46 16S ribosomal RNA gene, partial sequence	blastn	24389	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11043128	11043128	PRJNA851399_P_NODE_33549_length_164_cov_0.886957_g33096_i0	PRJNA851399	33549	164	0.886957	1.45460948	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	132	1.71e-26	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g33096	i0	83.942	0.835365853658537	137	22	84	0	7	143	898325	898189	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	137	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
21241676	21241676	PRJNA851399_P_NODE_9597_length_258_cov_1.650718_g9144_i0	PRJNA851399	9597	258	1.650718	4.25885244	Aliterella chasmolithica	2739056	Bacteria	Bacteria	350	7.44e-92	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g9144	i0	94.323	117.848837209302	229	12	89	1	4	232	2171	1944	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	30405	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica

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