metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1093380" and tax_clade = "Cyanobacteriota/Melainabacteria group"

8 rows where analysis = "blastn", bioproject = "PRJNA1093380" 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
2294642	2294642	PRJNA1093380_P_NODE_3502_length_328_cov_1.886275_g3396_i0	PRJNA1093380	3502	328	1.886275	6.186982	Nostocales	1161	Bacteria	Bacteria	479	1.1899999999999996e-130	NTclustered	gi\|78217335\|gb\|DQ234823.1\|	1166	g3396	i0	100	93.8932926829268	259	0	79	0	1	259	259	1	Anabaena flos-aquae strain UTEX LB2338 16S ribosomal RNA gene, partial sequence	blastn	30797	481	0.995841995841996	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum flos-aquae
4025766	4025766	PRJNA1093380_P_NODE_16004_length_243_cov_0.905882_g15898_i0	PRJNA1093380	16004	243	0.905882	2.20129326	Tolypothrix sp. PCC 7910	2099387	Bacteria	Bacteria	193	1.24e-44	NTclustered	gi\|1826566097\|gb\|CP050440.1\|	2099387	g15898	i0	88.679	8.56378600823045	159	16	65	2	8	165	5011083	5010926	Tolypothrix sp. PCC 7910 chromosome, complete genome	blastn	2081	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. PCC 7910
5302057	5302057	PRJNA1093380_P_NODE_5805_length_286_cov_1.807512_g5699_i0	PRJNA1093380	5805	286	1.807512	5.16948432	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	490	4.729999999999998e-134	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g5699	i0	97.552	177.545454545455	286	7	100	0	1	286	1244678	1244393	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	50778	490	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
6577099	6577099	PRJNA1093380_P_NODE_2906_length_351_cov_1.615108_g2800_i0	PRJNA1093380	2906	351	1.615108	5.66902908	uncultured Pleurocapsales cyanobacterium	183215	Bacteria	Bacteria	580	3.419999999999999e-161	NTclustered	gi\|745734118\|gb\|KM458372.1\|	183215	g2800	i0	100	127.501424501424	314	0	89	0	38	351	1	314	Uncultured Pleurocapsales cyanobacterium isolate OTU 00115 23S ribosomal RNA gene, partial sequence	blastn	44753	580	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			uncultured Pleurocapsales cyanobacterium
11677839	11677839	PRJNA1093380_P_NODE_8070_length_273_cov_1.155000_g7964_i0	PRJNA1093380	8070	273	1.155	3.15315	Nostoc punctiforme	272131	Bacteria	Bacteria	451	2.11e-122	NTclustered	gi\|1345606787\|gb\|MG968521.1\|	2081948	g7964	i0	96.958	254.395604395604	263	7	96	1	1	262	516	778	Nostoc punctiforme UTEX B 1629 23S ribosomal RNA gene, partial sequence	blastn	69450	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
13772622	13772622	PRJNA1093380_P_NODE_9551_length_264_cov_3.183246_g9445_i0	PRJNA1093380	9551	264	3.183246	8.40376944	Limnospira	2596745	Bacteria	Bacteria	488	1.5499999999999999e-133	NTclustered	gi\|1527124232\|emb\|LR025155.1\|	118562	g9445	i0	100	8.60227272727273	264	0	100	0	1	264	4409	4146	Arthrospira platensis mRNA for Ferredoxin-dependent glutamate synthase (A-glsF gene)	blastn	2271	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
20600127	20600127	PRJNA1093380_P_NODE_12877_length_249_cov_1.312500_g12771_i0	PRJNA1093380	12877	249	1.3125	3.268125	Leptolyngbya sp. HK-04	1137094	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|803375594\|dbj\|AB694933.1\|	1137094	g12771	i0	96.787	109.228915662651	249	8	100	0	1	249	294	46	Leptolyngbya sp. HK-04 gene for 16S ribosomal RNA, partial sequence	blastn	27198	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. HK-04
21421331	21421331	PRJNA1093380_P_NODE_697_length_666_cov_1.741990_g596_i0	PRJNA1093380	697	666	1.74199	11.6016534	Nostoc	1177	Bacteria	Bacteria	1096	0	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g596	i0	96.274	278.864864864865	671	19	100	5	1	666	6474845	6474176	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	185724	1105	0.99185520361991	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702

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