metadata: contig_metadata: 16 rows where bioproject = "PRJNA637328" and tax_clade = "Cyanobacteriota/Melainabacteria group"

16 rows where bioproject = "PRJNA637328" 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
609181	609181	PRJNA637328_S_NODE_4221_length_151_cov_4.596491_g4144_i0	PRJNA637328	4221	151	4.596491	6.94070141	uncultured Pleurocapsales cyanobacterium	183215	Bacteria	Bacteria	267	4.04e-67	NTclustered	gi\|745734118\|gb\|KM458372.1\|	183215	g4144	i0	98.675	113	151	1	99	1	1	150	237	387	Uncultured Pleurocapsales cyanobacterium isolate OTU 00115 23S ribosomal RNA gene, partial sequence	blastn	17063	267	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			uncultured Pleurocapsales cyanobacterium
1155170	1155170	PRJNA637328_P_NODE_3761_length_455_cov_6.657635_g3288_i0	PRJNA637328	3761	455	6.657635	30.29223925	Nostocales	1161	Bacteria	Bacteria	652	0	NTclustered	gi\|1566846272\|dbj\|LC455652.1\|	77022	g3288	i0	92.747	271.789010989011	455	28	99	5	3	455	971	520	Cylindrospermopsis raciborskii NIES-1262 gene for 23S ribosomal RNA, partial sequence	blastn	123664	654	0.996941896024465	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Cylindrospermopsis	Cylindrospermopsis raciborskii
3159963	3159963	PRJNA637328_P_NODE_17943_length_246_cov_1.035533_g17466_i0	PRJNA637328	17943	246	1.035533	2.54741118	Microcystis aeruginosa	1126	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2719083847\|gb\|CP142375.1\|	3113711	g17466	i0	100	1	246	0	100	0	1	246	4411221	4411466	Microcystis aeruginosa 1339 chromosome, complete genome	blastn	246	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
7532981	7532981	PRJNA637328_S_NODE_1166_length_343_cov_5.173203_g1089_i0	PRJNA637328	1166	343	5.173203	17.74408629	Bacteria	2	Bacteria	Bacteria	606	5.519999999999998e-169	NTclustered	gi\|105990319\|gb\|DQ514050.1\|	1211	g1089	i0	98.542	99.6822157434402	343	5	100	0	1	343	417	75	Uncultured cyanobacterium clone 100M2_B9 16S ribosomal RNA gene, partial sequence	blastn	34191	606	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8262422	8262422	PRJNA637328_S_NODE_1147_length_347_cov_2.312903_g1070_i0	PRJNA637328	1147	347	2.312903	8.02577341	Aliterella chasmolithica	2739056	Bacteria	Bacteria	459	1.66e-124	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g1070	i0	90.517	123.619596541787	348	31	100	2	1	347	2355	2009	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	42896	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
8808036	8808036	PRJNA637328_P_NODE_4087_length_436_cov_13.320413_g3613_i0	PRJNA637328	4087	436	13.320413	58.07700068	Microcystis	1125	Bacteria	Bacteria	806	0	NTclustered	gi\|119352232\|gb\|EF121241.1\|	1126	g3613	i0	100	101	436	0	100	0	1	436	329	764	Microcystis aeruginosa strain SPC 777 16S ribosomal RNA gene, partial sequence	blastn	44036	806	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
11358557	11358557	PRJNA637328_S_NODE_2569_length_201_cov_2.426829_g2492_i0	PRJNA637328	2569	201	2.426829	4.8779262900000004	Cyanophyceae	3028117	Bacteria	Bacteria	209	9.8e-50	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g2492	i0	85.572	96.7810945273632	201	27	99	2	1	200	2925	3124	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	19453	211	0.990521327014218	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12088568	12088568	PRJNA637328_P_NODE_8150_length_321_cov_2.088235_g7675_i0	PRJNA637328	8150	321	2.088235	6.70323435	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	411	4.309999999999999e-110	NTclustered	gi\|485099151\|ref\|NR_102546.1\|	1170562	g7675	i0	91.864	160.498442367601	295	23	92	1	1	295	1204	1497	Calothrix sp. PCC 6303 strain PCC 6303 23S ribosomal RNA, complete sequence	blastn	51520	411	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
12634147	12634147	PRJNA637328_P_NODE_1330_length_818_cov_8.014304_g124_i1	PRJNA637328	1330	818	8.014304	65.55700672	Microcystis	1125	Bacteria	Bacteria	957	0	NTclustered	gi\|1861038582\|dbj\|LC557462.1\|	1126	g124	i1	88.433	134.591687041565	804	79	98	12	20	818	573	1367	Microcystis aeruginosa NIES-104 gene for 23S rRNA, partial sequence	blastn	110096	965	0.991709844559585	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
13363208	13363208	PRJNA637328_P_NODE_19031_length_241_cov_3.593750_g18554_i0	PRJNA637328	19031	241	3.59375	8.6609375	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	333	6.919999999999998e-87	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g18554	i0	91.701	124.995850622407	241	18	99	2	2	240	1780	2020	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30124	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17187163	17187163	PRJNA637328_S_NODE_2774_length_192_cov_1.909677_g2697_i0	PRJNA637328	2774	192	1.909677	3.66657984	uncultured cyanobacterium	1211	Bacteria	Bacteria	246	7.07e-61	NTclustered	gi\|1667280630\|gb\|MK968478.1\|	1211	g2697	i0	90.374	102.71875	187	18	97	0	1	187	106	292	Uncultured cyanobacterium clone illumina26 16S ribosomal RNA gene, partial sequence	blastn	19722	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17733008	17733008	PRJNA637328_P_NODE_6014_length_359_cov_2.012903_g5539_i0	PRJNA637328	6014	359	2.012903	7.22632177	Nostocales	1161	Bacteria	Bacteria	538	2.1399999999999994e-148	NTclustered	gi\|1345606775\|gb\|MG968509.1\|	2081938	g5539	i0	94.134	168.052924791086	358	14	99	5	6	359	442	88	Gloeotrichia ghosei UTEX LB 1921 23S ribosomal RNA gene, partial sequence	blastn	60331	538	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Gloeotrichiaceae	Gloeotrichia	Gloeotrichia ghosei
21557023	21557023	PRJNA637328_P_NODE_20457_length_230_cov_4.933702_g19980_i0	PRJNA637328	20457	230	4.933702	11.3475146	Chroococcales	1118	Bacteria	Bacteria	425	1.05e-114	NTclustered	gi\|119352232\|gb\|EF121241.1\|	1126	g19980	i0	100	102	230	0	100	0	1	230	1355	1126	Microcystis aeruginosa strain SPC 777 16S ribosomal RNA gene, partial sequence	blastn	23460	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
22286315	22286315	PRJNA637328_S_NODE_2338_length_213_cov_2.755682_g2261_i0	PRJNA637328	2338	213	2.755682	5.86960266	Oscillatoria acuminata	118323	Bacteria	Bacteria	305	1.3e-78	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g2261	i0	92.523	190.370892018779	214	15	100	1	1	213	2201280	2201067	Oscillatoria acuminata PCC 6304, complete genome	blastn	40549	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
30776210	30776210	PRJNA637328_P_NODE_21354_length_220_cov_4.438596_g20877_i0	PRJNA637328	21354	220	4.438596	9.7649112	Trichodesmium sp. St18_bin1	2954180	Bacteria	Bacteria	55.5	5.55e-7	NR	MDE5083781.1	2954180	g20877	i0	59.1	1.8	44	18	60	0	220	89	180	223	MDE5083781.1 tetratricopeptide repeat protein [Trichodesmium sp. St18_bin1]	diamond	396	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Trichodesmium	Trichodesmium sp. St18_bin1
32040934	32040934	PRJNA637328_P_NODE_22598_length_197_cov_4.459459_g22121_i0	PRJNA637328	22598	197	4.459459	8.78513423	Limnospira platensis	118562	Bacteria	Bacteria	102	1.99e-26	NR	MDV7390954.1	3080829	g22121	i0	82.5	0.959390862944162	63	11	95.9	0	6	194	32	94	MDV7390954.1 hypothetical protein [Arthrospira platensis SPKY1]	diamond	189	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis

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