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

6 rows where analysis = "blastn", bioproject = "PRJNA815356" 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
3369938	3369938	PRJNA815356_P_NODE_3623_length_362_cov_3.003460_g3460_i0	PRJNA815356	3623	362	3.00346	10.8725252	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	623	5.799999999999999e-174	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g3460	i0	97.784	123.099447513812	361	8	99	0	2	362	2210	2570	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44562	623	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5055946	5055946	PRJNA815356_P_NODE_5564_length_305_cov_3.125000_g5401_i0	PRJNA815356	5564	305	3.125	9.53125	Cyanophyceae	3028117	Bacteria	Bacteria	340	5.42e-89	NTclustered	gi\|1358126417\|gb\|KY963615.1\|	2094041	g5401	i0	86.971	159.245901639344	307	35	100	3	1	305	736	433	Gloeocapsa sp. UTEX B EE3 23S ribosomal RNA gene, partial sequence	blastn	48570	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UTEX B EE3
8472114	8472114	PRJNA815356_P_NODE_9827_length_247_cov_0.896552_g9664_i0	PRJNA815356	9827	247	0.896552	2.21448344	Limnospira platensis	118562	Bacteria	Bacteria	274	4.38e-69	NTclustered	gi\|83777317\|gb\|DQ120927.1\|	357682	g9664	i0	88.21	0.927125506072874	229	27	93	0	1	229	229	1	Arthrospira platensis Ap-s chemotaxis signal transduction protein gene, partial cds	blastn	229	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
11022894	11022894	PRJNA815356_P_NODE_3189_length_381_cov_3.389610_g3026_i0	PRJNA815356	3189	381	3.38961	12.9144141	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	538	2.2899999999999998e-148	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g3026	i0	92.348	154.530183727034	379	27	99	2	4	381	2922	2545	Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	58876	538	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12298301	12298301	PRJNA815356_P_NODE_5090_length_316_cov_1.835391_g4927_i0	PRJNA815356	5090	316	1.835391	5.79983556	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	459	1.49e-124	NTclustered	gi\|225696248\|gb\|FJ805915.1\|	259957	g4927	i0	92.835	112.591772151899	321	15	100	7	1	316	1916	2233	Uncultured Chroococcidiopsis sp. clone A1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	35579	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25454494	25454494	PRJNA815356_P_NODE_2540_length_419_cov_1.338150_g2377_i0	PRJNA815356	2540	419	1.33815	5.6068485	Chroococcidiopsis	54298	Bacteria	Bacteria	669	0	NTclustered	gi\|225696276\|gb\|FJ805943.1\|	259957	g2377	i0	95.498	138.568019093079	422	14	100	5	1	419	3999	3580	Uncultured Chroococcidiopsis sp. clone AS5_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	58060	669	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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