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

13 rows where analysis = "blastn", bioproject = "PRJNA1226487" 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
1609747	1609747	PRJNA1226487_P_NODE_9722_length_450_cov_15.917772_g9622_i0	PRJNA1226487	9722	450	15.917772	71.629974	Albertania skiophila	2109500	Bacteria	Bacteria	732	0	NTclustered	gi\|1356054890\|gb\|MH030274.1\|	2109501	g9622	i0	96.197	212.16	447	17	99	0	1	447	2383	1937	Albertania skiophila str. SA373 Zammit 2014 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	95472	732	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Albertania	Albertania skiophila
2886005	2886005	PRJNA1226487_P_NODE_8203_length_475_cov_6.089552_g8104_i0	PRJNA1226487	8203	475	6.089552	28.925372	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	616	1.31e-171	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g8104	i0	90.275	178.4	473	42	99	4	5	475	1606	2076	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	84740	616	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4161886	4161886	PRJNA1226487_P_NODE_17664_length_374_cov_10.863787_g17562_i0	PRJNA1226487	17664	374	10.863787	40.63056338	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	113	1.61e-20	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g17562	i0	82.27	0.377005347593583	141	16	37	6	230	367	5331681	5331547	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	141	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
4161920	4161920	PRJNA1226487_P_NODE_3284_length_643_cov_2.205263_g3193_i0	PRJNA1226487	3284	643	2.205263	14.17984109	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1020	0	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g3193	i0	95.476	137.01399688958	641	25	99	3	1	638	2712	2073	Uncultured Chroococcidiopsis sp. clone NA4_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	88100	1020	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14363909	14363909	PRJNA1226487_P_NODE_37012_length_295_cov_23.648649_g36910_i0	PRJNA1226487	37012	295	23.648649	69.76351455	Edaphophycus epilithus	2989703	Bacteria	Bacteria	534	2.23e-147	NTclustered	gi\|2075814059\|gb\|MZ700337.1\|	2866018	g36910	i0	99.658	115.457627118644	292	1	99	0	1	292	2224	1933	Edaphophycus epilithus FBCC-A203 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34060	534	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Edaphophycus	Edaphophycus epilithus
14364110	14364110	PRJNA1226487_P_NODE_92_length_2039_cov_22.914547_g77_i0	PRJNA1226487	92	2039	22.914547	467.22761333	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	363	8.57e-95	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g77	i0	78.571	0.679254536537518	560	113	27	6	254	811	720287	719733	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	1385	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
16349322	16349322	PRJNA1226487_P_NODE_57313_length_261_cov_1.638298_g57211_i0	PRJNA1226487	57313	261	1.638298	4.27595778	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	67.6	8.5e-7	NTclustered	gi\|2093825993\|dbj\|AP023441.1\|	2764711	g57211	i0	100	159.567049808429	36	0	14	0	168	203	6546398	6546433	Nostoc sp. MS1 DNA, complete genome	blastn	41647	67.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. MS1
18186602	18186602	PRJNA1226487_P_NODE_7355_length_491_cov_142.464115_g7258_i0	PRJNA1226487	7355	491	142.464115	699.49880465	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	776	0	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g7258	i0	95.306	280.498981670061	490	21	99	2	4	491	2341	2830	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	137725	776	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
19460900	19460900	PRJNA1226487_P_NODE_25496_length_334_cov_4.643678_g25394_i0	PRJNA1226487	25496	334	4.643678	15.50988452	Microcystis aeruginosa	1126	Bacteria	Bacteria	575	1.5099999999999999e-159	NTclustered	gi\|2041080097\|dbj\|AP024565.1\|	1126	g25394	i0	98.176	8.82035928143713	329	6	99	0	6	334	4434536	4434864	Microcystis aeruginosa NIES-88 DNA, complete genome	blastn	2946	575	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
19461051	19461051	PRJNA1226487_P_NODE_7356_length_491_cov_142.088517_g7258_i1	PRJNA1226487	7356	491	142.088517	697.65461847	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	804	0	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g7258	i1	96.327	277.678207739308	490	16	99	2	4	491	2341	2830	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	136340	804	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
20173117	20173117	PRJNA1226487_P_NODE_29996_length_317_cov_17.577869_g29894_i0	PRJNA1226487	29996	317	17.577869	55.72184473	Chlorogloeopsis	1123	Bacteria	Bacteria	76.8	1.76e-9	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g29894	i0	100	12.5362776025237	41	0	15	0	11	51	6511800	6511840	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	3974	76.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
22011790	22011790	PRJNA1226487_P_NODE_82638_length_206_cov_7.338346_g82536_i0	PRJNA1226487	82638	206	7.338346	15.11699276	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	292	9.75e-75	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g82536	i0	94.681	136.519417475728	188	10	91	0	1	188	1815	1628	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	28123	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23998895	23998895	PRJNA1226487_P_NODE_45239_length_280_cov_1.487923_g45137_i0	PRJNA1226487	45239	280	1.487923	4.1661844	Planktothrix	54304	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2261183531\|emb\|LR882963.1\|	1160	g45137	i0	100	0.4	28	0	10	0	49	76	947816	947843	Planktothrix agardhii strain No.66 genome assembly, chromosome: I	blastn	112	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii

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