metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA743294" 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
3273579	3273579	PRJNA743294_P_NODE_59523_length_227_cov_2.967532_g59067_i0	PRJNA743294	59523	227	2.967532	6.73629764	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	298	2.35e-76	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g59067	i0	90.308	259.11013215859	227	22	100	0	1	227	2649	2875	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	58818	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
5026599	5026599	PRJNA743294_P_NODE_52504_length_246_cov_0.901734_g52048_i0	PRJNA743294	52504	246	0.901734	2.21826564	Synechococcales	1890424	Bacteria	Bacteria	145	3.56e-30	NTclustered	gi\|1895767613\|gb\|CP047940.1\|	261284	g52048	i0	79.048	20.3008130081301	210	44	85	0	1	210	1872883	1873092	Cyanobium sp. NS01 chromosome, complete genome	blastn	4994	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. NS01
5825784	5825784	PRJNA743294_P_NODE_54645_length_244_cov_0.912281_g54189_i0	PRJNA743294	54645	244	0.912281	2.22596564	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	289	1.5400000000000003e-73	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g54189	i0	88.163	157.372950819672	245	25	100	4	1	244	4390036	4389795	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	38399	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
7100712	7100712	PRJNA743294_P_NODE_29286_length_307_cov_1.692308_g28830_i0	PRJNA743294	29286	307	1.692308	5.19538556	Okeanomitos corallinicola	3231550	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2715117499\|gb\|CP150886.1\|	3133117	g28830	i0	100	0.0912052117263844	28	0	9	0	136	163	5016975	5016948	Okeanomitos corallinicola TIOX110 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Okeanomitos	Okeanomitos corallinicola
7100783	7100783	PRJNA743294_P_NODE_37626_length_276_cov_1.472906_g37170_i0	PRJNA743294	37626	276	1.472906	4.06522056	Synechococcus sp. CHAB TP201715.1	2737637	Bacteria	Bacteria	481	2.73e-131	NTclustered	gi\|1843475423\|gb\|MT488154.1\|	2737637	g37170	i0	99.62	37.7934782608696	263	1	95	0	1	263	1535	1797	Synechococcus sp. CHAB TP201715.1 clone 05 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	10431	481	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CHAB TP201715.1
8375478	8375478	PRJNA743294_P_NODE_48447_length_250_cov_2.401130_g47991_i0	PRJNA743294	48447	250	2.40113	6.002825	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	4.16e-114	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g47991	i0	97.2	115.884	250	7	100	0	1	250	2542	2791	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28971	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13475776	13475776	PRJNA743294_P_NODE_17931_length_381_cov_2.500000_g17475_i0	PRJNA743294	17931	381	2.5	9.525	Crocosphaera subtropica	2546360	Bacteria	Bacteria	73.1	2.79e-8	NTclustered	gi\|171696371\|gb\|CP000806.1\|	43989	g17475	i0	92.157	0.228346456692913	51	4	13	0	163	213	1632701	1632651	Cyanothece sp. ATCC 51142 circular chromosome, complete sequence	blastn	87	73.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera subtropica
13952241	13952241	PRJNA743294_P_NODE_11411_length_470_cov_1.516373_g10955_i0	PRJNA743294	11411	470	1.516373	7.1269531	Cyanophyceae	3028117	Bacteria	Bacteria	514	4.85e-141	NTclustered	gi\|46409893\|gb\|AY584518.1\|	272129	g10955	i0	89.975	126.176595744681	399	39	85	1	6	403	1112	1510	Oscillatoria sp. PCC 6506 23S ribosomal RNA gene, partial sequence	blastn	59303	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Kamptonema	Kamptonema sp. PCC 6506
16024467	16024467	PRJNA743294_P_NODE_14013_length_427_cov_2.629944_g13557_i0	PRJNA743294	14013	427	2.629944	11.22986088	Crinalium epipsammum	241425	Bacteria	Bacteria	536	9.319999999999997e-148	NTclustered	gi\|485099154\|ref\|NR_102549.1\|	1173022	g13557	i0	90	143.084309133489	420	35	98	6	10	427	1486	1072	Crinalium epipsammum PCC 9333 strain PCC 9333 23S ribosomal RNA, complete sequence	blastn	61097	536	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Crinalium	Crinalium epipsammum
16024808	16024808	PRJNA743294_P_NODE_57453_length_238_cov_2.496970_g56997_i0	PRJNA743294	57453	238	2.49697	5.9427886	Synechocystis sp. PCC 9413	77760	Bacteria	Bacteria	422	1.41e-113	NTclustered	gi\|7770709\|gb\|AF068771.3\|AF068771	77760	g56997	i0	98.739	1	238	2	100	1	1	238	1473	1709	Synechocystis PCC9413 beta-phycocyanin (cpcB), alpha-phycocyanin (cpcA), and 35 k phycocyanin specific rod linker polypeptide (cpcC) genes, complete cds; and phycocyanin alpha-subunit phycocyanobilin lyase (cpcE) gene, partial cds	blastn	238	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 9413
17300178	17300178	PRJNA743294_P_NODE_31454_length_297_cov_2.535714_g30998_i0	PRJNA743294	31454	297	2.535714	7.53107058	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	527	3.759999999999999e-145	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g30998	i0	98.653	115.272727272727	297	4	100	0	1	297	127	423	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34236	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21600481	21600481	PRJNA743294_P_NODE_1997_length_1022_cov_3.338251_g1715_i0	PRJNA743294	1997	1022	3.338251	34.11692522	Nostocales	1161	Bacteria	Bacteria	1232	0	NTclustered	gi\|485099135\|ref\|NR_102530.1\|	56107	g1715	i0	88.608	180.972602739726	1027	99	100	17	1	1022	13	1026	Cylindrospermum stagnale PCC 7417 strain PCC 7417 23S ribosomal RNA, complete sequence	blastn	184954	1232	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale

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