metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJEB41113" and tax

16 rows where analysis = "blastn", bioproject = "PRJEB41113" and tax_phylum = "Cyanobacteriota"

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
1333475	1333475	PRJEB41113_S_NODE_5522_length_184_cov_1.843537_g5513_i0	PRJEB41113	5522	184	1.843537	3.39210808	Nostoc flagelliforme	1306274	Bacteria	Bacteria	117	5.49e-22	NTclustered	gi\|1297075411\|gb\|CP024785.1\|	2038116	g5513	i0	78.804	1.98913043478261	184	31	98	8	5	184	3890736	3890557	Nostoc flagelliforme CCNUN1 chromosome, complete genome	blastn	366	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
2608989	2608989	PRJEB41113_S_NODE_13763_length_152_cov_2.773913_g13754_i0	PRJEB41113	13763	152	2.773913	4.21634776	Microcoleus vaginatus	119532	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g13754	i0	87.5	0.631578947368421	48	6	32	0	105	152	2259220	2259267	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	96	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
6437300	6437300	PRJEB41113_S_NODE_3446_length_201_cov_15.036585_g3437_i0	PRJEB41113	3446	201	15.036585	30.22353585	Nostoc sp. C057	2576903	Bacteria	Bacteria	80.5	8.02e-11	NTclustered	gi\|1866646741\|gb\|CP040281.1\|	2576903	g3437	i0	97.826	22.2338308457711	46	1	25	0	156	201	2338570	2338615	Nostoc sp. C057 chromosome, complete genome	blastn	4469	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C057
6437322	6437322	PRJEB41113_S_NODE_5626_length_183_cov_3.232877_g5617_i0	PRJEB41113	5626	183	3.232877	5.91616491	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	182	1.91e-41	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g5617	i0	85.311	0.967213114754098	177	24	96	2	3	178	2225613	2225788	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	177	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
8986215	8986215	PRJEB41113_S_NODE_1248_length_250_cov_4.183099_g1239_i0	PRJEB41113	1248	250	4.183099	10.4577475	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	305	1.57e-78	NTclustered	gi\|225696248\|gb\|FJ805915.1\|	259957	g1239	i0	91.818	102.52	220	17	88	1	32	250	2599	2818	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	25630	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8986227	8986227	PRJEB41113_S_NODE_15388_length_150_cov_1.690265_g15379_i0	PRJEB41113	15388	150	1.690265	2.5353975	Brasilonema sennae	1397703	Bacteria	Bacteria	108	2.57e-19	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g15379	i0	83.051	2.87333333333333	118	20	79	0	33	150	7295161	7295044	Brasilonema sennae CENA114 chromosome	blastn	431	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
10261981	10261981	PRJEB41113_S_NODE_6649_length_176_cov_5.035971_g6640_i0	PRJEB41113	6649	176	5.035971	8.86330896	Trichormus azollae	1164	Bacteria	Bacteria	58.4	3.19e-4	NTclustered	gi\|298231532\|gb\|CP002059.1\|	551115	g6640	i0	100	0.176136363636364	31	0	18	0	56	86	3397777	3397807	'Nostoc azollae' 0708, complete genome	blastn	31	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus azollae
11193227	11193227	PRJEB41113_S_NODE_7869_length_169_cov_3.522727_g7860_i0	PRJEB41113	7869	169	3.522727	5.95340863	root	1	Root_unresolved	Root_unresolved	52.8	0.014	NTclustered	gi\|2314726996\|dbj\|AP024677.1\|	1191	g7860	i0	100	5.65680473372781	28	0	17	0	24	51	300091	300064	MAG: Fischerella sp. KatS3mg066 DNA, complete genome	blastn	956	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp.
11537336	11537336	PRJEB41113_S_NODE_4010_length_195_cov_1.443038_g4001_i0	PRJEB41113	4010	195	1.443038	2.8139241	Nostoc punctiforme	272131	Bacteria	Bacteria	322	1.16e-83	NTclustered	gi\|186463002\|gb\|CP001037.1\|	63737	g4001	i0	96.41	7.27692307692308	195	7	100	0	1	195	8068750	8068556	Nostoc punctiforme PCC 73102 strain ATCC 29133 chromosome, complete genome	blastn	1419	322	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
12468947	12468947	PRJEB41113_S_NODE_3530_length_200_cov_6.668712_g3521_i0	PRJEB41113	3530	200	6.668712	13.337424	Wilmottia	1048851	Bacteria	Bacteria	363	7.069999999999999e-96	NTclustered	gi\|1700116479\|gb\|MN158648.1\|	2593982	g3521	i0	99.497	174.84	199	1	99	0	1	199	2111	1913	Wilmottia murrayi ACKU581 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34968	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Wilmottia	Wilmottia murrayi
19184674	19184674	PRJEB41113_S_NODE_7536_length_171_cov_2.529851_g7527_i0	PRJEB41113	7536	171	2.529851	4.32604521	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	89.8	1.09e-13	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g7527	i0	82.692	0.608187134502924	104	14	60	3	1	102	3645857	3645958	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	104	89.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
20460011	20460011	PRJEB41113_S_NODE_657_length_286_cov_70.188755_g648_i0	PRJEB41113	657	286	70.188755	200.7398393	Aliterella chasmolithica	2739056	Bacteria	Bacteria	363	1.08e-95	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g648	i0	94.118	111.786713286713	238	14	83	0	32	269	1970	2207	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	31971	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
21735837	21735837	PRJEB41113_S_NODE_1918_length_228_cov_7.890052_g1909_i0	PRJEB41113	1918	228	7.890052	17.98931856	Aliterella chasmolithica	2739056	Bacteria	Bacteria	374	3.8199999999999984e-99	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g1909	i0	97.273	139.995614035088	220	6	96	0	9	228	2417	2198	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	31919	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
21735849	21735849	PRJEB41113_S_NODE_3198_length_204_cov_24.712575_g3189_i0	PRJEB41113	3198	204	24.712575	50.413653	Cylindrospermum stagnale	142864	Bacteria	Bacteria	121	4.809999999999999e-23	NTclustered	gi\|428262251\|gb\|CP003643.1\|	56107	g3189	i0	87.037	1.05882352941176	108	13	52	1	90	196	16303	16410	Cylindrospermum stagnale PCC 7417 plasmid pCYLST.01, partial sequence	blastn	216	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
23011062	23011062	PRJEB41113_S_NODE_10859_length_157_cov_10.833333_g10850_i0	PRJEB41113	10859	157	10.833333	17.00833281	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	211	2.02e-50	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g10850	i0	94.815	138.044585987261	135	7	86	0	23	157	3090	2956	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	21673	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24284905	24284905	PRJEB41113_S_NODE_1040_length_260_cov_3.251121_g1031_i0	PRJEB41113	1040	260	3.251121	8.4529146	Geminocystis sp. NIES-3709	1617448	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|770470343\|dbj\|AP014821.1\|	1617448	g1031	i0	100	0.107692307692308	28	0	11	0	204	231	2017602	2017629	Geminocystis sp. NIES-3709 DNA, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3709

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