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

12 rows where analysis = "blastn", bioproject = "PRJNA529224" 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
3665707	3665707	PRJNA529224_S_NODE_1083_length_200_cov_67.345029_g1076_i0	PRJNA529224	1083	200	67.345029	134.690058	Oscillatoriales	1150	Bacteria	Bacteria	342	9.209999999999999e-90	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g1076	i0	97.5	118	200	5	100	0	1	200	813848	813649	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	23600	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
4942737	4942737	PRJNA529224_S_NODE_64_length_512_cov_80.550725_g59_i0	PRJNA529224	64	512	80.550725	412.419712	Oscillatoriales	1150	Bacteria	Bacteria	935	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g59	i0	99.609	142.47265625	512	2	100	0	1	512	811936	811425	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	72946	935	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
6218019	6218019	PRJNA529224_S_NODE_145_length_414_cov_59.748052_g138_i0	PRJNA529224	145	414	59.748052	247.35693528	Oscillatoriales	1150	Bacteria	Bacteria	760	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g138	i0	99.758	175.678743961353	414	1	100	0	1	414	813203	812790	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	72731	765	0.993464052287582	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
8150989	8150989	PRJNA529224_S_NODE_1607_length_165_cov_8.882353_g1600_i0	PRJNA529224	1607	165	8.882353	14.65588245	Synechococcus sp. CBW1108	1353147	Bacteria	Bacteria	279	5.81e-71	NTclustered	gi\|1940487417\|gb\|CP060395.1\|	1353147	g1600	i0	98.125	156.933333333333	160	3	97	0	3	162	922253	922094	Synechococcus sp. CBW1108 chromosome, complete genome	blastn	25894	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1108
8767484	8767484	PRJNA529224_S_NODE_167_length_399_cov_60.272973_g160_i0	PRJNA529224	167	399	60.272973	240.48916227	Oscillatoriales	1150	Bacteria	Bacteria	732	0	NTclustered	gi\|1566846289\|dbj\|LC455669.1\|	118562	g160	i0	99.749	184.862155388471	399	1	100	0	1	399	992	1390	Arthrospira platensis NIES-46 gene for 23S ribosomal RNA, partial sequence	blastn	73760	732	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
8767501	8767501	PRJNA529224_S_NODE_687_length_238_cov_55.779904_g680_i0	PRJNA529224	687	238	55.779904	132.75617152	Limnospira	2596745	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g680	i0	100	139.352941176471	238	0	100	0	1	238	812218	812455	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	33166	440	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
13868269	13868269	PRJNA529224_S_NODE_1211_length_188_cov_315.132075_g1204_i0	PRJNA529224	1211	188	315.132075	592.448301	Oscillatoriales	1150	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g1204	i0	100	188.909574468085	188	0	100	0	1	188	813359	813172	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	35515	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
16417239	16417239	PRJNA529224_S_NODE_173_length_390_cov_35.614958_g166_i0	PRJNA529224	173	390	35.614958	138.8983362	Oscillatoriales	1150	Bacteria	Bacteria	627	4.869999999999999e-175	NTclustered	gi\|1566846289\|dbj\|LC455669.1\|	118562	g166	i0	95.641	143.235897435897	390	17	100	0	1	390	1381	992	Arthrospira platensis NIES-46 gene for 23S ribosomal RNA, partial sequence	blastn	55862	627	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
16417245	16417245	PRJNA529224_S_NODE_293_length_337_cov_975.422078_g286_i0	PRJNA529224	293	337	975.422078	3287.17240286	Oscillatoriales	1150	Bacteria	Bacteria	569	7.099999999999998e-158	NTclustered	gi\|1566846288\|dbj\|LC455668.1\|	118562	g286	i0	98.452	100.00296735905	323	5	96	0	15	337	2	324	Arthrospira platensis NIES-46 gene for 16S ribosomal RNA, partial sequence	blastn	33701	569	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
17692348	17692348	PRJNA529224_S_NODE_1794_length_156_cov_36.637795_g1787_i0	PRJNA529224	1794	156	36.637795	57.1549602	Oscillatoriales	1150	Bacteria	Bacteria	279	5.41e-71	NTclustered	gi\|743760207\|gb\|KP219068.1\|	1211	g1787	i0	99.351	101.679487179487	154	1	99	0	2	155	880	727	Uncultured cyanobacterium clone 10A6 16S ribosomal RNA gene, partial sequence	blastn	15862	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17692353	17692353	PRJNA529224_S_NODE_334_length_320_cov_121.931271_g327_i0	PRJNA529224	334	320	121.931271	390.1800672	Oscillatoriales	1150	Bacteria	Bacteria	586	6.65e-163	NTclustered	gi\|743760207\|gb\|KP219068.1\|	1211	g327	i0	99.688	102.996875	320	1	100	0	1	320	371	52	Uncultured cyanobacterium clone 10A6 16S ribosomal RNA gene, partial sequence	blastn	32959	586	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22174779	22174779	PRJNA529224_S_NODE_358_length_311_cov_97.783688_g351_i0	PRJNA529224	358	311	97.783688	304.10726968	uncultured cyanobacterium	1211	Bacteria	Bacteria	520	6.629999999999998e-143	NTclustered	gi\|171221461\|gb\|EU414894.1\|	1211	g351	i0	96.795	106.167202572347	312	8	100	2	1	311	64	374	Uncultured cyanobacterium clone Fuku2-SW-PH53 16S ribosomal RNA gene, partial sequence	blastn	33018	520	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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