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

10 rows where analysis = "blastn", bioproject = "PRJNA289590" 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
1647062	1647062	PRJNA289590_P_NODE_1262_length_1237_cov_2.435185_g1093_i0	PRJNA289590	1262	1237	2.435185	30.12323845	Limnospira platensis	118562	Bacteria	Bacteria	1496	0	NTclustered	gi\|83777317\|gb\|DQ120927.1\|	357682	g1093	i0	98.469	11.3993532740501	849	13	69	0	1	849	849	1	Arthrospira platensis Ap-s chemotaxis signal transduction protein gene, partial cds	blastn	14101	1496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
8025599	8025599	PRJNA289590_P_NODE_1267_length_1233_cov_4.407095_g1097_i0	PRJNA289590	1267	1233	4.407095	54.33948135	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1290	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1097	i0	85.646	104.093268450933	1247	156	99	19	3	1233	3682149	3680910	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	128347	1290	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
9300779	9300779	PRJNA289590_P_NODE_31628_length_159_cov_2.245455_g31404_i0	PRJNA289590	31628	159	2.245455	3.57027345	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	224	2.64e-54	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g31404	i0	92.357	106.547169811321	157	12	99	0	1	157	51	207	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	16941	224	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
10576791	10576791	PRJNA289590_P_NODE_8349_length_326_cov_3.779783_g8125_i0	PRJNA289590	8349	326	3.779783	12.32209258	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	442	1.5599999999999995e-119	NTclustered	gi\|2851645142\|gb\|CP137338.1\|	3082949	g8125	i0	91.489	69.4079754601227	329	17	99	10	5	326	5151518	5151842	Altericista sp. CCNU0014 chromosome, complete genome	blastn	22627	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
14401637	14401637	PRJNA289590_P_NODE_29352_length_165_cov_0.870690_g29128_i0	PRJNA289590	29352	165	0.87069	1.4366385	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g29128	i0	98.788	157.842424242424	165	2	100	0	1	165	1930	2094	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	26044	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
18224145	18224145	PRJNA289590_P_NODE_20155_length_198_cov_1.838926_g19931_i0	PRJNA289590	20155	198	1.838926	3.64107348	uncultured cyanobacterium	1211	Bacteria	Bacteria	344	2.53e-90	NTclustered	gi\|429732865\|gb\|JX887884.1\|	1211	g19931	i0	97.98	99.989898989899	198	4	100	0	1	198	1281	1084	Uncultured cyanobacterium clone Emix2.2 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, and tRNA-Ile gene, partial sequence	blastn	19798	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20185460	20185460	PRJNA289590_P_NODE_24076_length_178_cov_1.209302_g23852_i0	PRJNA289590	24076	178	1.209302	2.15255756	Trichocoleus	450526	Bacteria	Bacteria	313	6.259999999999999e-81	NTclustered	gi\|1373417991\|gb\|KY511275.1\|	1382649	g23852	i0	98.315	188.23595505618	178	3	100	0	1	178	1205	1382	Trichocoleus desertorum ATA4-8-CV3 clone 10 23S ribosomal RNA gene, partial sequence; 23S-5S intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	33506	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus desertorum
20773853	20773853	PRJNA289590_P_NODE_14417_length_238_cov_2.560847_g14193_i0	PRJNA289590	14417	238	2.560847	6.09481586	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	392	1.11e-104	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g14193	i0	97.009	177.626050420168	234	6	98	1	1	233	1189	1422	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	42275	392	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
22736227	22736227	PRJNA289590_P_NODE_19338_length_203_cov_1.350649_g19114_i0	PRJNA289590	19338	203	1.350649	2.74181747	Altericista	2855430	Bacteria	Bacteria	316	5.679999999999998e-82	NTclustered	gi\|1841384167\|gb\|MT463168.1\|	2735524	g19114	i0	95.025	98.7536945812808	201	10	99	0	3	203	14	214	Altericista lacusladogae CALU 1174 16S ribosomal RNA gene, partial sequence	blastn	20047	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista lacusladogae
23324460	23324460	PRJNA289590_P_NODE_17659_length_214_cov_0.945455_g17435_i0	PRJNA289590	17659	214	0.945455	2.0232737	Trichocoleus sp. 1.9A	2876723	Bacteria	Bacteria	302	1.7e-77	NTclustered	gi\|2095813678\|gb\|OK161232.1\|	2876723	g17435	i0	92.056	199.714953271028	214	17	100	0	1	214	2933	2720	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	42739	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus sp. 1.9A

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