metadata: contig_metadata: 11 rows where bioproject = "PRJNA733995" and tax_clade = "Cyanobacteriota/Melainabacteria group"

11 rows where bioproject = "PRJNA733995" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
12196001	12196001	PRJNA733995_P_NODE_7510_length_313_cov_4.458333_g7463_i0	PRJNA733995	7510	313	4.458333	13.95458229	uncultured Tolypothrix sp.	442936	Bacteria	Bacteria	518	2.4e-142	NTclustered	gi\|745734112\|gb\|KM458379.1\|	442936	g7463	i0	96.486	190.900958466454	313	11	100	0	1	313	14	326	Uncultured Tolypothrix sp. isolate OTU 00124 23S ribosomal RNA gene, partial sequence	blastn	59752	518	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	uncultured Tolypothrix sp.
17294675	17294675	PRJNA733995_P_NODE_2514_length_567_cov_1.858300_g2467_i0	PRJNA733995	2514	567	1.8583	10.536561	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	54.7	0.016	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g2467	i0	94.286	0.0617283950617284	35	2	6	0	102	136	5989534	5989500	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	35	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
27062587	27062587	PRJNA733995_P_NODE_2062_length_623_cov_3.594545_g2015_i0	PRJNA733995	2062	623	3.594545	22.39401535	Nostocales	1161	Bacteria	Bacteria	47.8	0.00948	NR	WP_017748227.1	34078	g2015	i0	38.5	5.00802568218299	91	50	41.9	2	366	106	30	118	WP_017748227.1 hypothetical protein [Scytonema hofmannii]	diamond	3120	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema hofmannii
27305384	27305384	PRJNA733995_P_NODE_6123_length_346_cov_1.974359_g6076_i0	PRJNA733995	6123	346	1.974359	6.83128214	Nostoc sp.	1180	Bacteria	Bacteria	53.9	1.13e-6	NR	WP_334733461.1	1180	g6076	i0	55.8	0.710982658959538	43	19	37.3	0	9	137	1	43	WP_334733461.1 tetratricopeptide repeat protein [Nostoc sp.]	diamond	246	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
29294470	29294470	PRJNA733995_P_NODE_11889_length_251_cov_1.365169_g11842_i0	PRJNA733995	11889	251	1.365169	3.42657419	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	77.4	1.74e-14	NR	MBX9686158.1	2364082	g11842	i0	56.4	0.657370517928287	55	24	65.7	0	3	167	275	329	MBX9686158.1 lysophospholipase [Candidatus Obscuribacterales bacterium]	diamond	165	77.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29325936	29325936	PRJNA733995_P_NODE_12109_length_250_cov_0.870056_g12062_i0	PRJNA733995	12109	250	0.870056	2.17514	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	73.9	4.34e-13	NR	MBX9689537.1	2364082	g12062	i0	44	1.008	84	46	99.6	1	250	2	1894	1977	MBX9689537.1 FHA domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	252	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30526262	30526262	PRJNA733995_P_NODE_12953_length_246_cov_0.890173_g12906_i0	PRJNA733995	12953	246	0.890173	2.18982558	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	109	2.49e-26	NR	MBX9724844.1	2364082	g12906	i0	64.2	0.98780487804878	81	29	98.8	0	246	4	48	128	MBX9724844.1 class A beta-lactamase-related serine hydrolase [Candidatus Obscuribacterales bacterium]	diamond	243	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30620998	30620998	PRJNA733995_P_NODE_12293_length_249_cov_0.875000_g12246_i0	PRJNA733995	12293	249	0.875	2.17875	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	151	5.3e-44	NR	MBY0357794.1	2364082	g12246	i0	90.2	2.96385542168675	82	8	98.8	0	2	247	112	193	MBY0357794.1 fructose-6-phosphate aldolase [Candidatus Obscuribacterales bacterium]	diamond	738	151	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31537937	31537937	PRJNA733995_P_NODE_9276_length_283_cov_1.685714_g9229_i0	PRJNA733995	9276	283	1.685714	4.77057062	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	135	3.88e-38	NR	MBX9569814.1	2364082	g9229	i0	69.1	0.996466431095406	94	29	99.6	0	282	1	30	123	MBX9569814.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	282	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31664124	31664124	PRJNA733995_P_NODE_6017_length_350_cov_1.111913_g5970_i0	PRJNA733995	6017	350	1.111913	3.8916955	Cyanobacteria bacterium J06555_13	3023131	Bacteria	Bacteria	48.9	8.23e-4	NR	MEN8443588.1	3023131	g5970	i0	50	0.788571428571429	46	23	39.4	0	348	211	376	421	MEN8443588.1 tetratricopeptide repeat protein [Cyanobacteria bacterium J06555_13]	diamond	276	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06555_13
32675941	32675941	PRJNA733995_P_NODE_10140_length_272_cov_1.482412_g10093_i0	PRJNA733995	10140	272	1.482412	4.03216064	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	156	8.8e-45	NR	MBX9685144.1	2364082	g10093	i0	83.1	0.981617647058823	89	15	98.2	0	4	270	185	273	MBX9685144.1 tRNA pseudouridine(38-40) synthase TruA [Candidatus Obscuribacterales bacterium]	diamond	267	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium

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