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

6 rows where analysis = "blastn", bioproject = "PRJNA685607" 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
4494285	4494285	PRJNA685607_P_NODE_57764_length_263_cov_1.621053_g57405_i0	PRJNA685607	57764	263	1.621053	4.26336939	Nostoc sp. ATCC 53789	76335	Bacteria	Bacteria	381	2.7e-101	NTclustered	gi\|1796915833\|gb\|CP046708.1\|	76335	g57405	i0	92.776	5.85931558935361	263	19	100	0	1	263	31292	31030	Nostoc sp. ATCC 53789 plasmid pNsp_e, complete sequence	blastn	1541	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
8829476	8829476	PRJNA685607_P_NODE_93007_length_242_cov_0.911243_g92648_i0	PRJNA685607	93007	242	0.911243	2.20520806	Chlorogloeopsis	1123	Bacteria	Bacteria	145	3.5e-30	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g92648	i0	79.07	2.45867768595041	215	41	88	4	27	239	3954310	3954522	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	595	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
10870399	10870399	PRJNA685607_P_NODE_69229_length_250_cov_0.870056_g68870_i0	PRJNA685607	69229	250	0.870056	2.17514	Fischerella sp. JS2	2597771	Bacteria	Bacteria	117	7.92e-22	NTclustered	gi\|2589057682\|gb\|CP135918.1\|	2597771	g68870	i0	79.874	0.636	159	32	64	0	27	185	1881654	1881496	Fischerella sp. JS2 chromosome, complete genome	blastn	159	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. JS2
15969212	15969212	PRJNA685607_P_NODE_94913_length_241_cov_0.916667_g94554_i0	PRJNA685607	94913	241	0.916667	2.20916747	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	316	6.97e-82	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g94554	i0	90.456	5.62655601659751	241	21	99	2	2	241	3867356	3867595	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	1356	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
22343797	22343797	PRJNA685607_P_NODE_90458_length_243_cov_0.905882_g90099_i0	PRJNA685607	90458	243	0.905882	2.20129326	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	165	2.6999999999999997e-36	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g90099	i0	81.281	3.12345679012346	203	38	84	0	3	205	6288638	6288436	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	759	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
25402970	25402970	PRJNA685607_P_NODE_74420_length_248_cov_0.880000_g74061_i0	PRJNA685607	74420	248	0.88	2.1824	Nostoc	1177	Bacteria	Bacteria	281	2.63e-71	NTclustered	gi\|2237829811\|dbj\|AP025732.1\|	449208	g74061	i0	87.097	38.0443548387097	248	32	100	0	1	248	1725345	1725098	Nostoc cf. commune SO-36 DNA, complete genome	blastn	9435	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune

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