metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA287283" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA287283" 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
11850831	11850831	PRJNA287283_P_NODE_5290_length_259_cov_1.072816_g5066_i0	PRJNA287283	5290	259	1.072816	2.77859344	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	462	9.2e-126	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g5066	i0	98.842	158.586872586873	259	3	100	0	1	259	2019	1761	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41074	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12537697	12537697	PRJNA287283_P_NODE_6110_length_233_cov_1.822222_g5886_i0	PRJNA287283	6110	233	1.822222	4.24577726	Cyanophyceae	3028117	Bacteria	Bacteria	403	4.9999999999999985e-108	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g5886	i0	98.678	109.12017167382	227	3	97	0	1	227	3984	3758	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25425	403	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14401166	14401166	PRJNA287283_P_NODE_2752_length_393_cov_1.520588_g2528_i0	PRJNA287283	2752	393	1.520588	5.97591084	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	612	1.37e-170	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g2528	i0	94.911	115.847328244275	393	17	100	3	1	393	3471	3082	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	45528	612	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14401170	14401170	PRJNA287283_P_NODE_632_length_918_cov_2.894798_g480_i0	PRJNA287283	632	918	2.894798	26.57424564	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1303	0	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g480	i0	92.333	168.966230936819	926	55	100	16	1	918	3206	2289	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	155111	1303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14401172	14401172	PRJNA287283_P_NODE_8092_length_187_cov_1.283582_g7868_i0	PRJNA287283	8092	187	1.283582	2.40029834	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	335	1.4199999999999996e-87	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g7868	i0	98.93	195.802139037433	187	2	100	0	1	187	1752	1566	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36615	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18223837	18223837	PRJNA287283_P_NODE_10675_length_169_cov_2.172414_g10451_i0	PRJNA287283	10675	169	2.172414	3.67137966	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|453199516\|gb\|JQ997496.1\|	259957	g10451	i0	98.817	149.792899408284	169	2	100	0	1	169	335	167	Uncultured Chroococcidiopsis sp. clone GKJWQY101ANW47 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25315	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22048642	22048642	PRJNA287283_P_NODE_7678_length_194_cov_2.056738_g7454_i0	PRJNA287283	7678	194	2.056738	3.99007172	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	359	8.809999999999999e-95	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g7454	i0	100	157.396907216495	194	0	100	0	1	194	2288	2095	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30535	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24011106	24011106	PRJNA287283_P_NODE_1399_length_601_cov_2.226277_g1184_i0	PRJNA287283	1399	601	2.226277	13.37992477	Chroococcidiopsis	54298	Bacteria	Bacteria	889	0	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g1184	i0	93.929	181.133111480865	593	28	98	5	13	601	795432	794844	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	108861	889	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29

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