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

25 rows where analysis = "blastn", bioproject = "PRJNA715462" 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
1192309	1192309	PRJNA715462_P_NODE_64321_length_244_cov_0.888889_g63525_i0	PRJNA715462	64321	244	0.888889	2.16888916	Microcystis	1125	Bacteria	Bacteria	448	2.4e-121	NTclustered	gi\|815963219\|gb\|CP011304.1\|	1641812	g63525	i0	100	20.516393442623	242	0	99	0	3	244	4082216	4082457	Microcystis aeruginosa NIES-2549, complete genome	blastn	5006	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
1982503	1982503	PRJNA715462_P_NODE_7182_length_855_cov_1.480818_g6483_i0	PRJNA715462	7182	855	1.480818	12.6609939	Nostoc sp. PCC 7524	28072	Bacteria	Bacteria	1351	0	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g6483	i0	99.864	15.0713450292398	734	1	86	0	36	769	6008383	6009116	Nostoc sp. PCC 7524, complete genome	blastn	12886	1351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
2467631	2467631	PRJNA715462_P_NODE_44422_length_268_cov_1.153846_g43626_i0	PRJNA715462	44422	268	1.153846	3.09230728	Microcystis	1125	Bacteria	Bacteria	479	9.499999999999996e-131	NTclustered	gi\|2153464463\|gb\|CP086723.1\|	2894165	g43626	i0	98.881	20	268	3	100	0	1	268	209627	209360	MAG: Microcystis aeruginosa NIBR18 chromosome, complete genome	blastn	5360	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
2467659	2467659	PRJNA715462_P_NODE_55902_length_248_cov_0.880000_g55106_i0	PRJNA715462	55902	248	0.88	2.1824	Synechococcales	1890424	Bacteria	Bacteria	388	1.51e-103	NTclustered	gi\|2638501482\|emb\|OY986431.1\|	2116684	g55106	i0	96.203	79.8387096774194	237	9	96	0	1	237	2635215	2635451	Cyanobium usitatum str. Tous isolate KAC_108 genome assembly, chromosome: 1	blastn	19800	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium usitatum
4534701	4534701	PRJNA715462_P_NODE_59984_length_246_cov_0.890173_g59188_i0	PRJNA715462	59984	246	0.890173	2.18982558	Anabaenopsis circularis	109266	Bacteria	Bacteria	62.1	3.69e-5	NTclustered	gi\|1210095109\|dbj\|AP018174.1\|	1085406	g59188	i0	88.235	0.528455284552846	51	6	21	0	78	128	402024	402074	Anabaenopsis circularis NIES-21 DNA, nearly complete genome	blastn	130	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Anabaenopsis	Anabaenopsis circularis
5020528	5020528	PRJNA715462_P_NODE_33204_length_308_cov_0.927660_g32408_i0	PRJNA715462	33204	308	0.92766	2.8571928	Microcystis	1125	Bacteria	Bacteria	564	2.99e-156	NTclustered	gi\|2153464463\|gb\|CP086723.1\|	2894165	g32408	i0	99.675	217.727272727273	308	1	100	0	1	308	1903314	1903007	MAG: Microcystis aeruginosa NIBR18 chromosome, complete genome	blastn	67060	569	0.991212653778559	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
5020587	5020587	PRJNA715462_P_NODE_60284_length_246_cov_0.890173_g59488_i0	PRJNA715462	60284	246	0.890173	2.18982558	Microcystis	1125	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|2041080097\|dbj\|AP024565.1\|	1126	g59488	i0	99.593	14.9918699186992	246	1	100	0	1	246	1909894	1910139	Microcystis aeruginosa NIES-88 DNA, complete genome	blastn	3688	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
5810060	5810060	PRJNA715462_P_NODE_65425_length_243_cov_0.905882_g64629_i0	PRJNA715462	65425	243	0.905882	2.20129326	Microcystis panniformis	513223	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|914397586\|gb\|CP011339.1\|	1638788	g64629	i0	98.354	21.5843621399177	243	4	100	0	1	243	3666246	3666004	Microcystis panniformis FACHB-1757, complete genome	blastn	5245	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis panniformis
7084779	7084779	PRJNA715462_P_NODE_47546_length_259_cov_1.241935_g46750_i0	PRJNA715462	47546	259	1.241935	3.21661165	Microcystis aeruginosa	1126	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|2329605325\|gb\|CP097576.1\|	2945101	g46750	i0	100	25.7760617760618	259	0	100	0	1	259	2087619	2087361	Microcystis aeruginosa str. Chao 1910 chromosome, complete genome	blastn	6676	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
7085057	7085057	PRJNA715462_P_NODE_63526_length_244_cov_0.900585_g62730_i0	PRJNA715462	63526	244	0.900585	2.1974274	Okeanomitos corallinicola	3231550	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2715117499\|gb\|CP150886.1\|	3133117	g62730	i0	88.636	0.180327868852459	44	3	17	2	171	212	1660033	1660076	Okeanomitos corallinicola TIOX110 chromosome, complete genome	blastn	44	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Okeanomitos	Okeanomitos corallinicola
8359714	8359714	PRJNA715462_P_NODE_65647_length_243_cov_0.905882_g64851_i0	PRJNA715462	65647	243	0.905882	2.20129326	Microcystis aeruginosa	1126	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|1805636340\|gb\|CP046058.1\|	449468	g64851	i0	99.588	20	243	1	100	0	1	243	2071837	2072079	Microcystis aeruginosa NIES-298 chromosome, complete genome	blastn	4860	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
9634779	9634779	PRJNA715462_P_NODE_57008_length_248_cov_0.880000_g56212_i0	PRJNA715462	57008	248	0.88	2.1824	Microcystis aeruginosa	1126	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2719083847\|gb\|CP142375.1\|	3113711	g56212	i0	100	20	248	0	100	0	1	248	4130837	4130590	Microcystis aeruginosa 1339 chromosome, complete genome	blastn	4960	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
11395872	11395872	PRJNA715462_P_NODE_50969_length_251_cov_0.865169_g50173_i0	PRJNA715462	50969	251	0.865169	2.17157419	Microcystis	1125	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|150445933\|dbj\|AB279593.1\|	1126	g50173	i0	99.203	21	251	2	100	0	1	251	3278	3028	Microcystis aeruginosa new nonribosomal peptide synthetase and polyketide synthase gene cluster, complete cds	blastn	5271	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
11395887	11395887	PRJNA715462_P_NODE_55209_length_249_cov_0.875000_g54413_i0	PRJNA715462	55209	249	0.875	2.17875	Microcystis	1125	Bacteria	Bacteria	453	5.29e-123	NTclustered	gi\|2041080097\|dbj\|AP024565.1\|	1126	g54413	i0	99.597	226.586345381526	248	1	99	0	2	249	1874480	1874727	Microcystis aeruginosa NIES-88 DNA, complete genome	blastn	56420	455	0.995604395604396	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
11395897	11395897	PRJNA715462_P_NODE_57709_length_247_cov_0.885057_g56913_i0	PRJNA715462	57709	247	0.885057	2.18609079	Microcystis	1125	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1519305953\|dbj\|AP019314.1\|	213615	g56913	i0	100	33.6842105263158	247	0	100	0	1	247	5024717	5024471	Microcystis viridis NIES-102 DNA, complete genome	blastn	8320	457	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis viridis
13459954	13459954	PRJNA715462_P_NODE_55011_length_249_cov_0.875000_g54215_i0	PRJNA715462	55011	249	0.875	2.17875	Microcystis aeruginosa	1126	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|1805636340\|gb\|CP046058.1\|	449468	g54215	i0	99.197	19.0080321285141	249	2	100	0	1	249	1577139	1577387	Microcystis aeruginosa NIES-298 chromosome, complete genome	blastn	4733	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
13946083	13946083	PRJNA715462_P_NODE_17331_length_456_cov_0.762402_g16535_i0	PRJNA715462	17331	456	0.762402	3.47655312	Microcystis	1125	Bacteria	Bacteria	809	0	NTclustered	gi\|1519305953\|dbj\|AP019314.1\|	213615	g16535	i0	98.684	116.651315789474	456	6	100	0	1	456	573617	574072	Microcystis viridis NIES-102 DNA, complete genome	blastn	53193	815	0.992638036809816	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis viridis
14735428	14735428	PRJNA715462_P_NODE_66572_length_242_cov_0.911243_g65776_i0	PRJNA715462	66572	242	0.911243	2.20520806	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g65776	i0	100	87.7644628099174	242	0	100	0	1	242	2004691	2004450	Synechococcus sp. CB0101 chromosome, complete genome	blastn	21239	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
14735440	14735440	PRJNA715462_P_NODE_67372_length_242_cov_0.911243_g66576_i0	PRJNA715462	67372	242	0.911243	2.20520806	Microcystis aeruginosa	1126	Bacteria	Bacteria	431	2.4e-116	NTclustered	gi\|2041080097\|dbj\|AP024565.1\|	1126	g66576	i0	98.76	20	242	3	100	0	1	242	755727	755968	Microcystis aeruginosa NIES-88 DNA, complete genome	blastn	4840	431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
19044007	19044007	PRJNA715462_P_NODE_29935_length_326_cov_1.521739_g29139_i0	PRJNA715462	29935	326	1.521739	4.96086914	Microcystis	1125	Bacteria	Bacteria	575	1.4699999999999996e-159	NTclustered	gi\|1519305953\|dbj\|AP019314.1\|	213615	g29139	i0	100	513.177914110429	311	0	97	0	16	326	4741968	4741658	Microcystis viridis NIES-102 DNA, complete genome	blastn	167296	575	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis viridis
19832986	19832986	PRJNA715462_P_NODE_45796_length_264_cov_0.989529_g45000_i0	PRJNA715462	45796	264	0.989529	2.61235656	Microcystis panniformis	513223	Bacteria	Bacteria	483	7.219999999999998e-132	NTclustered	gi\|914397586\|gb\|CP011339.1\|	1638788	g45000	i0	99.621	20	264	1	100	0	1	264	2849039	2849302	Microcystis panniformis FACHB-1757, complete genome	blastn	5280	483	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis panniformis
19833236	19833236	PRJNA715462_P_NODE_59616_length_246_cov_0.890173_g58820_i0	PRJNA715462	59616	246	0.890173	2.18982558	Microcystis viridis	44822	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|1519305953\|dbj\|AP019314.1\|	213615	g58820	i0	99.187	19.9837398373984	246	2	100	0	1	246	1345420	1345175	Microcystis viridis NIES-102 DNA, complete genome	blastn	4916	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis viridis
21108884	21108884	PRJNA715462_P_NODE_64337_length_244_cov_0.883041_g63541_i0	PRJNA715462	64337	244	0.883041	2.15462004	Microcystis aeruginosa	1126	Bacteria	Bacteria	418	1.8799999999999994e-112	NTclustered	gi\|1805636340\|gb\|CP046058.1\|	449468	g63541	i0	97.541	21.7950819672131	244	6	100	0	1	244	4342097	4341854	Microcystis aeruginosa NIES-298 chromosome, complete genome	blastn	5318	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
23659380	23659380	PRJNA715462_P_NODE_60459_length_246_cov_0.890173_g59663_i0	PRJNA715462	60459	246	0.890173	2.18982558	Microcystis panniformis	513223	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|914397586\|gb\|CP011339.1\|	1638788	g59663	i0	99.593	24.0121951219512	246	1	100	0	1	246	4111716	4111961	Microcystis panniformis FACHB-1757, complete genome	blastn	5907	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis panniformis
25418881	25418881	PRJNA715462_P_NODE_66920_length_242_cov_0.911243_g66124_i0	PRJNA715462	66920	242	0.911243	2.20520806	Microcystis	1125	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2592646984\|gb\|CP116295.1\|	1194489	g66124	i0	100	27.8305785123967	242	0	100	0	1	242	2145580	2145339	Microcystis aeruginosa LE3 chromosome	blastn	6735	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa

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