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

9 rows where analysis = "blastn", bioproject = "PRJNA1180292" 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
1041252	1041252	PRJNA1180292_P_NODE_4121_length_340_cov_1.715356_g3989_i0	PRJNA1180292	4121	340	1.715356	5.8322104	root	1	Root_unresolved	Root_unresolved	627	4.199999999999999e-175	NTclustered	gi\|2022617059\|gb\|MW876296.1\|	1211	g3989	i0	100	196.420588235294	339	0	99	0	1	339	507	845	Uncultured cyanobacterium clone Chav3-2-80 16S ribosomal RNA gene, partial sequence	blastn	66783	627	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1041259	1041259	PRJNA1180292_P_NODE_5361_length_301_cov_1.504386_g5229_i0	PRJNA1180292	5361	301	1.504386	4.52820186	Chroococcidiopsis	54298	Bacteria	Bacteria	388	1.88e-103	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g5229	i0	90.099	155.056478405316	303	25	99	3	1	300	795209	795509	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	46672	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
4144833	4144833	PRJNA1180292_P_NODE_8144_length_253_cov_0.866667_g8012_i0	PRJNA1180292	8144	253	0.866667	2.19266751	Nostoc sp. TCL240-02	2572090	Bacteria	Bacteria	219	2.1399999999999993e-52	NTclustered	gi\|1854569723\|gb\|CP040094.1\|	2572090	g8012	i0	84.615	0.873517786561265	221	33	87	1	32	251	3943703	3943923	Nostoc sp. TCL240-02 chromosome, complete genome	blastn	221	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL240-02
9245711	9245711	PRJNA1180292_P_NODE_11428_length_245_cov_0.906977_g11296_i0	PRJNA1180292	11428	245	0.906977	2.22209365	Sphaerospermopsis torques-reginae	984207	Bacteria	Bacteria	224	4.43e-54	NTclustered	gi\|2080647037\|gb\|CP080598.1\|	984208	g11296	i0	94.483	5.57959183673469	145	8	59	0	99	243	5211378	5211234	Sphaerospermopsis torques-reginae ITEP-024 chromosome	blastn	1367	224	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis torques-reginae
11796556	11796556	PRJNA1180292_P_NODE_9790_length_249_cov_0.886364_g9658_i0	PRJNA1180292	9790	249	0.886364	2.20704636	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	339	1.5399999999999998e-88	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g9658	i0	93.074	2.84738955823293	231	16	93	0	19	249	3771503	3771733	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	709	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
14346935	14346935	PRJNA1180292_P_NODE_6912_length_268_cov_1.994872_g6780_i0	PRJNA1180292	6912	268	1.994872	5.34625696	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g6780	i0	100	248.514925373134	268	0	100	0	1	268	5151	4884	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	66602	496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
15620604	15620604	PRJNA1180292_P_NODE_11073_length_246_cov_0.901734_g10941_i0	PRJNA1180292	11073	246	0.901734	2.21826564	Anabaena cylindrica	1165	Bacteria	Bacteria	122	1.67e-23	NTclustered	gi\|1210081632\|dbj\|AP018166.1\|	272123	g10941	i0	91.954	3.47967479674797	87	7	35	0	2	88	5166600	5166686	Anabaena cylindrica PCC 7122 DNA, nearly complete genome	blastn	856	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena cylindrica
16894924	16894924	PRJNA1180292_P_NODE_11494_length_245_cov_0.906977_g11362_i0	PRJNA1180292	11494	245	0.906977	2.22209365	Planktothricoides raciborskii	132608	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g11362	i0	94.595	1.06530612244898	37	0	27	2	168	202	2693355	2693391	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	261	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
16895009	16895009	PRJNA1180292_P_NODE_6354_length_279_cov_1.266990_g6222_i0	PRJNA1180292	6354	279	1.26699	3.5349021	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	364	2.909999999999999e-96	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g6222	i0	90.288	10.7025089605735	278	27	99	0	1	278	5952917	5953194	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	2986	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2

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