metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1247234" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1247234" and tax_phylum = "Cyanobacteriota"

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
351304	351304	PRJNA1247234_P_NODE_22721_length_249_cov_1.329545_g22565_i0	PRJNA1247234	22721	249	1.329545	3.31056705	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	289	1.58e-73	NTclustered	gi\|225696178\|gb\|FJ805845.1\|	259957	g22565	i0	93.035	111.128514056225	201	9	80	5	51	249	1556	1753	Uncultured Chroococcidiopsis sp. clone AU1_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27671	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1051729	1051729	PRJNA1247234_P_NODE_27661_length_242_cov_0.923077_g27505_i0	PRJNA1247234	27661	242	0.923077	2.23384634	Microcystis	1125	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g27505	i0	100	19.995867768595	242	0	100	0	1	242	1283224	1282983	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	4839	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
1626312	1626312	PRJNA1247234_P_NODE_542_length_1163_cov_5.643119_g469_i0	PRJNA1247234	542	1163	5.643119	65.62947397	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1528	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g469	i0	91.818	130.742046431642	1100	85	100	5	1	1096	2884	1786	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	152053	1528	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2327195	2327195	PRJNA1247234_P_NODE_9782_length_345_cov_1.125000_g9626_i0	PRJNA1247234	9782	345	1.125	3.88125	Microcystis	1125	Bacteria	Bacteria	621	1.98e-173	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g9626	i0	99.13	6	345	3	100	0	1	345	988147	987803	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	2070	621	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
4879695	4879695	PRJNA1247234_P_NODE_11524_length_324_cov_0.880478_g11368_i0	PRJNA1247234	11524	324	0.880478	2.85274872	Chroococcidiopsis	54298	Bacteria	Bacteria	479	1.1799999999999993e-130	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g11368	i0	95.652	13.3888888888889	299	12	99	1	1	298	883650	883352	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	4338	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
4879701	4879701	PRJNA1247234_P_NODE_12004_length_318_cov_1.910204_g11848_i0	PRJNA1247234	12004	318	1.910204	6.07444872	Microcystis	1125	Bacteria	Bacteria	586	6.609999999999998e-163	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g11848	i0	100	85.8710691823899	317	0	99	0	2	318	4150000	4149684	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	27307	586	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
6154369	6154369	PRJNA1247234_P_NODE_13805_length_300_cov_2.035242_g13649_i0	PRJNA1247234	13805	300	2.035242	6.105726	Microcystis	1125	Bacteria	Bacteria	555	1.7399999999999995e-153	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g13649	i0	100	41.9166666666667	300	0	100	0	1	300	3442390	3442091	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	12575	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
6729109	6729109	PRJNA1247234_P_NODE_14046_length_298_cov_1.386667_g13890_i0	PRJNA1247234	14046	298	1.386667	4.13226766	Stanieria cyanosphaera	102116	Bacteria	Bacteria	213	1.2e-50	NTclustered	gi\|428267688\|gb\|CP003653.1\|	111780	g13890	i0	82.773	1.56711409395973	238	41	80	0	60	297	1303275	1303038	Stanieria cyanosphaera PCC 7437, complete genome	blastn	467	213	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
7429586	7429586	PRJNA1247234_P_NODE_19366_length_257_cov_2.586957_g19210_i0	PRJNA1247234	19366	257	2.586957	6.64847949	Microcystis	1125	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g19210	i0	99.611	19.7859922178988	257	1	100	0	1	257	4149706	4149450	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	5085	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
8704606	8704606	PRJNA1247234_P_NODE_7347_length_386_cov_1.549521_g7191_i0	PRJNA1247234	7347	386	1.549521	5.98115106	Leptolyngbya	47251	Bacteria	Bacteria	658	0	NTclustered	gi\|46409895\|gb\|AY584520.1\|	212450	g7191	i0	97.409	174.295336787565	386	10	100	0	1	386	1052	1437	Leptolyngbya sp. PCC 7410 23S ribosomal RNA gene, partial sequence	blastn	67278	664	0.990963855421687	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PCC 7410
9979752	9979752	PRJNA1247234_P_NODE_22188_length_250_cov_0.881356_g22032_i0	PRJNA1247234	22188	250	0.881356	2.20339	Microcystis	1125	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g22032	i0	100	22.704	250	0	100	0	1	250	4804890	4805139	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	5676	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
9979777	9979777	PRJNA1247234_P_NODE_24308_length_247_cov_0.896552_g24152_i0	PRJNA1247234	24308	247	0.896552	2.21448344	Chroococcidiopsis	54298	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g24152	i0	97.166	119.631578947368	247	7	100	0	1	247	4887959	4887713	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	29549	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
12530286	12530286	PRJNA1247234_P_NODE_16710_length_277_cov_1.372549_g16554_i0	PRJNA1247234	16710	277	1.372549	3.80196073	Microcystis	1125	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g16554	i0	100	65.2671480144404	277	0	100	0	1	277	4248333	4248057	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	18079	512	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
12530434	12530434	PRJNA1247234_P_NODE_8590_length_363_cov_1.906897_g8434_i0	PRJNA1247234	8590	363	1.906897	6.92203611	Microcystis	1125	Bacteria	Bacteria	671	0	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g8434	i0	100	86.9972451790634	363	0	100	0	1	363	2387207	2387569	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	31580	671	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
16928644	16928644	PRJNA1247234_P_NODE_20894_length_252_cov_0.871508_g20738_i0	PRJNA1247234	20894	252	0.871508	2.19620016	Moorena producens	1155739	Bacteria	Bacteria	91.6	4.84e-14	NTclustered	gi\|2412135964\|gb\|CP017708.2\|	1454205	g20738	i0	86.585	0.654761904761905	82	11	33	0	167	248	7483752	7483833	Moorena producens JHB chromosome, complete genome	blastn	165	91.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
21453514	21453514	PRJNA1247234_P_NODE_16977_length_275_cov_1.524752_g16821_i0	PRJNA1247234	16977	275	1.524752	4.193068	Microcystis	1125	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2041080097\|dbj\|AP024565.1\|	1126	g16821	i0	100	105.352727272727	275	0	100	0	1	275	3641438	3641712	Microcystis aeruginosa NIES-88 DNA, complete genome	blastn	28972	508	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa

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