metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA495917" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA495917" 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
13231251	13231251	PRJNA495917_S_NODE_10291_length_173_cov_1.666667_g10097_i0	PRJNA495917	10291	173	1.666667	2.88333391	Nostoc	1177	Bacteria	Bacteria	113	4.41e-28	NR	WP_194044748.1	264686	g10097	i0	96.5	1.97687861271676	57	2	98.8	0	1	171	172	228	WP_194044748.1 heavy metal translocating P-type ATPase, partial [Nostoc edaphicum]	diamond	342	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
14506127	14506127	PRJNA495917_S_NODE_10792_length_171_cov_1.176471_g10598_i0	PRJNA495917	10792	171	1.176471	2.01176541	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	111	9.67e-27	NR	WP_009632510.1	927677	g10598	i0	94.6	0.982456140350877	56	3	98.2	0	2	169	72	127	WP_009632510.1 molecular chaperone DnaK [Synechocystis sp. PCC 7509]	diamond	168	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
26697040	26697040	PRJNA495917_S_NODE_3461_length_264_cov_1.689956_g3267_i0	PRJNA495917	3461	264	1.689956	4.46148384	Nostocales cyanobacterium W4_Combined_metabat2_030	2743981	Bacteria	Bacteria	54.7	6.42e-8	NR	NTW18972.1	2743981	g3267	i0	61.1	0.409090909090909	36	14	40.9	0	262	155	3	38	NTW18972.1 pentapeptide repeat-containing protein [Nostocales cyanobacterium W4_Combined_metabat2_030]	diamond	108	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium W4_Combined_metabat2_030
27266672	27266672	PRJNA495917_S_NODE_3183_length_275_cov_1.825000_g2989_i0	PRJNA495917	3183	275	1.825	5.01875	Tolypothrix sp. NIES-4	3100432	Bacteria	Bacteria	129	4.66e-34	NR	WP_089126921.1	2005459	g2989	i0	86.8	3.31636363636364	76	10	82.9	0	273	46	242	317	WP_089126921.1 DUF2382 domain-containing protein [Tolypothrix sp. NIES-4075]	diamond	912	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. NIES-4075
27456408	27456408	PRJNA495917_S_NODE_13003_length_161_cov_1.539683_g12809_i0	PRJNA495917	13003	161	1.539683	2.47888963	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	53.9	6.16e-8	NR	WP_106370038.1	2107693	g12809	i0	93.3	0.559006211180124	30	2	55.9	0	2	91	36	65	WP_106370038.1 heavy-metal-associated domain-containing protein [Chlorogloea sp. CCALA 695]	diamond	90	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
27677540	27677540	PRJNA495917_S_NODE_8704_length_183_cov_1.155405_g8510_i0	PRJNA495917	8704	183	1.155405	2.11439115	Xenococcus sp. PCC 73	102125	Bacteria	Bacteria	73.9	1.64e-13	NR	WP_006508737.1	102125	g8510	i0	53.3	0.983606557377049	60	28	98.4	0	2	181	283	342	WP_006508737.1 PQQ-dependent sugar dehydrogenase [Xenococcus sp. PCC 7305]	diamond	180	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Xenococcaceae	Xenococcus	Xenococcus sp. PCC 7305
27772157	27772157	PRJNA495917_S_NODE_9364_length_178_cov_3.818182_g9170_i0	PRJNA495917	9364	178	3.818182	6.79636396	Thermosynechococcaceae cyanobacterium MS004	2881380	Bacteria	Bacteria	42.4	0.0201	NR	MCG9891895.1	2881380	g9170	i0	50	0.707865168539326	42	19	67.4	1	24	143	21	62	MCG9891895.1 prohibitin family protein [Thermosynechococcaceae cyanobacterium MS004]	diamond	126	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae		Thermosynechococcaceae cyanobacterium MS004
28308785	28308785	PRJNA495917_S_NODE_10946_length_170_cov_1.481481_g10752_i0	PRJNA495917	10946	170	1.481481	2.5185177	Spirirestis rafaelensis	293980	Bacteria	Bacteria	91.7	8.09e-20	NR	MBW4450894.1	2835094	g10752	i0	92.3	1.83529411764706	52	4	91.8	0	1	156	22	73	MBW4450894.1 hypothetical protein [Spirirestis rafaelensis WJT71-NPBG6]	diamond	312	91.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
28340282	28340282	PRJNA495917_S_NODE_13566_length_159_cov_1.556452_g13372_i0	PRJNA495917	13566	159	1.556452	2.47475868	Nostocales	1161	Bacteria	Bacteria	92.4	5.13e-21	NR	WP_029635640.1	1161	g13372	i0	86.5	3.92452830188679	52	7	98.1	0	2	157	65	116	WP_029635640.1 MULTISPECIES: DUF2382 domain-containing protein [Nostocales]	diamond	624	92.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
29271251	29271251	PRJNA495917_S_NODE_14309_length_157_cov_0.983607_g14115_i0	PRJNA495917	14309	157	0.983607	1.54426299	Cyanophyceae	3028117	Bacteria	Bacteria	97.4	5.68e-22	NR	WP_235082041.1	1161	g14115	i0	94.1	4.87261146496815	51	3	97.5	0	155	3	232	282	WP_235082041.1 MULTISPECIES: group II intron reverse transcriptase/maturase [Nostocales]	diamond	765	97.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
30440241	30440241	PRJNA495917_S_NODE_5333_length_219_cov_2.673913_g5139_i0	PRJNA495917	5333	219	2.673913	5.85586947	Nostocales	1161	Bacteria	Bacteria	108	9.18e-28	NR	WP_062288101.1	224012	g5139	i0	84.5	7.9041095890411	58	9	79.5	0	1	174	116	173	WP_062288101.1 hypothetical protein [Nostoc piscinale]	diamond	1731	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc piscinale
30456500	30456500	PRJNA495917_S_NODE_8793_length_182_cov_1.870748_g8599_i0	PRJNA495917	8793	182	1.870748	3.40476136	Tolypothrix sp. T3-bin4	2768888	Bacteria	Bacteria	101	3.87e-23	NR	MBD0301167.1	2768888	g8599	i0	93.4	1.00549450549451	61	3	98.9	1	3	182	381	441	MBD0301167.1 translation initiation factor IF-2 N-terminal domain-containing protein [Tolypothrix sp. T3-bin4]	diamond	183	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. T3-bin4
30819248	30819248	PRJNA495917_S_NODE_5854_length_211_cov_1.539773_g5660_i0	PRJNA495917	5854	211	1.539773	3.24892103	Nostocales	1161	Bacteria	Bacteria	86.3	9e-20	NR	WP_051503031.1	379535	g5660	i0	85	1.70616113744076	60	8	83.9	1	178	2	1	60	WP_051503031.1 hypothetical protein [[Scytonema hofmanni] UTEX B 1581]	diamond	360	86.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	[Scytonema hofmanni] UTEX B 1581
31008807	31008807	PRJNA495917_S_NODE_14494_length_156_cov_1.636364_g14300_i0	PRJNA495917	14494	156	1.636364	2.55272784	Tolypothrix	111782	Bacteria	Bacteria	91.3	9.31e-20	NR	WP_029634748.1	1161	g14300	i0	88.2	1.98076923076923	51	6	98.1	0	156	4	322	372	WP_029634748.1 MULTISPECIES: translation initiation factor IF-2 [Nostocales]	diamond	309	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
31499268	31499268	PRJNA495917_S_NODE_12216_length_164_cov_1.286822_g12022_i0	PRJNA495917	12216	164	1.286822	2.11038808	Scytonema sp. HK-	1204	Bacteria	Bacteria	66.6	5.31e-13	NR	OKH59518.1	1137095	g12022	i0	84.6	0.713414634146341	39	6	71.3	0	118	2	7	45	OKH59518.1 hypothetical protein NIES2130_08125 [Scytonema sp. HK-05]	diamond	117	66.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. HK-05
32904963	32904963	PRJNA495917_S_NODE_13540_length_159_cov_1.612903_g13346_i0	PRJNA495917	13540	159	1.612903	2.56451577	Cyanophyceae	3028117	Bacteria	Bacteria	95.5	1.9900000000000003e-21	NR	WP_208339503.1	1550245	g13346	i0	84.9	5.9622641509434	53	8	100	0	159	1	331	383	WP_208339503.1 glutamate-1-semialdehyde 2,1-aminomutase [Aetokthonos hydrillicola]	diamond	948	95.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Aetokthonos	Aetokthonos hydrillicola

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