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

8 rows where analysis = "blastn", bioproject = "PRJNA827593" 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
5924220	5924220	PRJNA827593_P_NODE_27905_length_394_cov_1.439252_g27606_i0	PRJNA827593	27905	394	1.439252	5.67065288	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	671	0	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g27606	i0	98.429	240.520304568528	382	4	96	2	15	394	2762	2381	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	94765	671	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
7199424	7199424	PRJNA827593_P_NODE_42226_length_311_cov_2.579832_g41927_i0	PRJNA827593	42226	311	2.579832	8.02327752	Pleurocapsa sp. PCC 7327	118163	Bacteria	Bacteria	381	3.2599999999999987e-101	NTclustered	gi\|485099141\|ref\|NR_102536.1\|	118163	g41927	i0	88.818	143.659163987138	313	32	100	3	1	311	457	146	Pleurocapsa sp. PCC 7327 strain PCC 7327 23S ribosomal RNA, complete sequence	blastn	44678	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7327
8474244	8474244	PRJNA827593_P_NODE_47467_length_291_cov_2.655963_g47168_i0	PRJNA827593	47467	291	2.655963	7.72885233	Geminocystis sp. NIES-3709	1617448	Bacteria	Bacteria	62.1	4.48e-5	NTclustered	gi\|770470343\|dbj\|AP014821.1\|	1617448	g47168	i0	94.872	0.134020618556701	39	2	13	0	130	168	511066	511028	Geminocystis sp. NIES-3709 DNA, complete genome	blastn	39	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3709
14849052	14849052	PRJNA827593_P_NODE_27892_length_394_cov_1.566978_g27593_i0	PRJNA827593	27892	394	1.566978	6.17389332	Phormidium sp. NIES-2121	2510782	Bacteria	Bacteria	665	0	NTclustered	gi\|1566846234\|dbj\|LC455612.1\|	2510782	g27593	i0	98.925	154.007614213198	372	4	94	0	23	394	886	1257	Phormidium sp. NIES-2121 gene for 23S ribosomal RNA, partial sequence	blastn	60679	665	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2121
18673053	18673053	PRJNA827593_P_NODE_67215_length_242_cov_0.911243_g66916_i0	PRJNA827593	67215	242	0.911243	2.20520806	Picosynechococcus sp. PCC 7003	374981	Bacteria	Bacteria	278	3.3e-70	NTclustered	gi\|2275105\|emb\|X97393.1\|	374981	g66916	i0	92.746	65.202479338843	193	12	79	2	4	194	196	4	Synechococcus sp. rnpB gene, strain PCC7003	blastn	15779	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7003
23773437	23773437	PRJNA827593_P_NODE_27299_length_399_cov_1.346626_g27000_i0	PRJNA827593	27299	399	1.346626	5.37303774	Phormidium sp. NIES-2121	2510782	Bacteria	Bacteria	682	0	NTclustered	gi\|1566846234\|dbj\|LC455612.1\|	2510782	g27000	i0	97.5	152.734335839599	400	9	100	1	1	399	1746	1347	Phormidium sp. NIES-2121 gene for 23S ribosomal RNA, partial sequence	blastn	60941	682	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2121
24179980	24179980	PRJNA827593_P_NODE_32639_length_360_cov_1.902439_g32340_i0	PRJNA827593	32639	360	1.902439	6.8487804	Cyanophyceae	3028117	Bacteria	Bacteria	364	3.859999999999998e-96	NTclustered	gi\|2098452651\|gb\|CP083582.1\|	2653194	g32340	i0	87.117	247.436111111111	326	37	90	5	1	325	4176302	4176623	Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome	blastn	89077	366	0.994535519125683	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Kovacikia	Kovacikia minuta
24180051	24180051	PRJNA827593_P_NODE_52979_length_273_cov_1.975000_g52680_i0	PRJNA827593	52979	273	1.975	5.39175	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	60.2	1.5e-4	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g52680	i0	91.111	0.282051282051282	45	3	16	1	200	244	4845363	4845320	Nodosilinea sp. E11 chromosome	blastn	77	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11

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