metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA1255065" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA1255065" 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
11838736	11838736	PRJNA1255065_P_NODE_143510_length_163_cov_0.912281_g141282_i0	PRJNA1255065	143510	163	0.912281	1.48701803	Phormidium nigroviride	482564	Bacteria	Bacteria	230	5.8499999999999985e-56	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g141282	i0	92.025	4	163	13	100	0	1	163	3087898	3088060	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	652	230	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
13113706	13113706	PRJNA1255065_P_NODE_112371_length_168_cov_0.873950_g110143_i0	PRJNA1255065	112371	168	0.87395	1.468236	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	143	8.139999999999998e-30	NTclustered	gi\|485099151\|ref\|NR_102546.1\|	1170562	g110143	i0	84.828	7.91666666666667	145	19	86	3	25	168	1582	1440	Calothrix sp. PCC 6303 strain PCC 6303 23S ribosomal RNA, complete sequence	blastn	1330	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
20761405	20761405	PRJNA1255065_P_NODE_113437_length_168_cov_0.873950_g111209_i0	PRJNA1255065	113437	168	0.87395	1.468236	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	241	2.81e-59	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g111209	i0	93.75	0.952380952380952	160	10	95	0	2	161	4268823	4268982	Calothrix sp. PCC 7716 DNA, complete genome	blastn	160	241	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
22036797	22036797	PRJNA1255065_P_NODE_139438_length_164_cov_0.904348_g137210_i0	PRJNA1255065	139438	164	0.904348	1.48313072	Nostoc sp. C057	2576903	Bacteria	Bacteria	178	2.17e-40	NTclustered	gi\|1866653707\|gb\|CP040290.1\|	2576903	g137210	i0	90.37	4.79878048780488	135	13	82	0	1	135	10235	10369	Nostoc sp. C057 plasmid p057_I	blastn	787	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C057
22730214	22730214	PRJNA1255065_P_NODE_54618_length_267_cov_1.908257_g52390_i0	PRJNA1255065	54618	267	1.908257	5.09504619	Bacteria	2	Bacteria	Bacteria	460	3.4299999999999996e-125	NTclustered	gi\|389547840\|gb\|JQ402768.1\|	1211	g52390	i0	97.761	100.007490636704	268	4	100	2	1	267	451	717	Uncultured cyanobacterium clone CNY_03229 16S ribosomal RNA gene, partial sequence	blastn	26702	460	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
24586672	24586672	PRJNA1255065_P_NODE_4680_length_1279_cov_6.069106_g3742_i0	PRJNA1255065	4680	1279	6.069106	77.62386574	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1816	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g3742	i0	92.284	161.637998436278	1283	93	100	6	1	1279	1607	2887	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	206735	1816	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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