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

5 rows where analysis = "blastn", bioproject = "PRJNA1000943" 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
2695327	2695327	PRJNA1000943_P_NODE_15603_length_242_cov_0.834320_g15465_i0	PRJNA1000943	15603	242	0.83432	2.0190544	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	329	8.99e-86	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g15465	i0	91.286	231.074380165289	241	21	99	0	1	241	3669250	3669490	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	55920	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
10348349	10348349	PRJNA1000943_P_NODE_9429_length_271_cov_1.651515_g9291_i0	PRJNA1000943	9429	271	1.651515	4.47560565	Trichocoleus sp. 1.9A	2876723	Bacteria	Bacteria	344	3.6599999999999997e-90	NTclustered	gi\|2095813678\|gb\|OK161232.1\|	2876723	g9291	i0	91.935	177.09594095941	248	17	92	3	24	271	3409	3653	Trichocoleus sp. 1.9A 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47993	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus sp. 1.9A
13752697	13752697	PRJNA1000943_P_NODE_13591_length_246_cov_1.803468_g13453_i0	PRJNA1000943	13591	246	1.803468	4.43653128	root	1	Root_unresolved	Root_unresolved	141	4.61e-29	NTclustered	gi\|586852035\|gb\|KF896310.1\|	1211	g13453	i0	88.136	50.0365853658537	118	14	48	0	126	243	90	207	Uncultured cyanobacterium clone T0_C1 16S ribosomal RNA gene, partial sequence	blastn	12309	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15447900	15447900	PRJNA1000943_P_NODE_6533_length_318_cov_1.534694_g6395_i0	PRJNA1000943	6533	318	1.534694	4.88032692	uncultured cyanobacterium	1211	Bacteria	Bacteria	527	4.06e-145	NTclustered	gi\|389547566\|gb\|JQ402494.1\|	1211	g6395	i0	96.541	100.487421383648	318	11	100	0	1	318	643	326	Uncultured cyanobacterium clone CNY_02855 16S ribosomal RNA gene, partial sequence	blastn	31955	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
24371034	24371034	PRJNA1000943_P_NODE_4280_length_380_cov_2.188925_g4143_i0	PRJNA1000943	4280	380	2.188925	8.317915	Dulcicalothrix desertica	32056	Bacteria	Bacteria	697	0	NTclustered	gi\|283766156\|gb\|GQ980023.1\|	232991	g4143	i0	99.737	169.597368421053	380	1	100	0	1	380	63	442	Calothrix desertica PCC 7102 23S large subunit ribosomal RNA (rrnL) gene, partial sequence	blastn	64447	697	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica

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