metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA758087" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA758087" 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
733570	733570	PRJNA758087_P_NODE_36401_length_317_cov_1.299180_g35081_i0	PRJNA758087	36401	317	1.29918	4.1184006	Plectolyngbya terrestris	3016457	Bacteria	Bacteria	472	1.92e-128	NTclustered	gi\|2106138546\|gb\|OK382086.1\|	2880694	g35081	i0	95.593	150.173501577287	295	12	93	1	2	295	2282	1988	Plectolyngbya terrestris FBCC-A1479 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47605	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Plectolyngbya	Plectolyngbya terrestris
4561799	4561799	PRJNA758087_P_NODE_25084_length_500_cov_13.014052_g23764_i0	PRJNA758087	25084	500	13.014052	65.07026	Aliterella chasmolithica	2739056	Bacteria	Bacteria	562	1.8299999999999997e-155	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g23764	i0	90.255	117.42	431	40	86	2	42	471	2394	1965	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	58710	562	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
9662067	9662067	PRJNA758087_P_NODE_36388_length_317_cov_1.774590_g35068_i0	PRJNA758087	36388	317	1.77459	5.6254503	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	466	8.95e-127	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g35068	i0	95.833	214.785488958991	288	12	94	0	30	317	1859336	1859049	Calothrix sp. PCC 7716 DNA, complete genome	blastn	68087	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
10131455	10131455	PRJNA758087_P_NODE_41608_length_251_cov_1.129213_g40288_i0	PRJNA758087	41608	251	1.129213	2.83432463	Leptolyngbya	47251	Bacteria	Bacteria	326	1.21e-84	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g40288	i0	95.567	118.195219123506	203	9	82	0	27	229	247327	247125	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	29667	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
11406528	11406528	PRJNA758087_P_NODE_35029_length_336_cov_1.463878_g33709_i0	PRJNA758087	35029	336	1.463878	4.91863008	Leptolyngbya	47251	Bacteria	Bacteria	292	1.72e-74	NTclustered	gi\|2198507406\|gb\|CP092420.1\|	462680	g33709	i0	86.245	1.60119047619048	269	37	80	0	50	318	355477	355209	Leptolyngbya boryana IU 594 plasmid p1, complete sequence	blastn	538	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
12212728	12212728	PRJNA758087_P_NODE_18990_length_639_cov_24.434629_g17693_i0	PRJNA758087	18990	639	24.434629	156.13727931	Anabaena azotica	197653	Bacteria	Bacteria	54.7	0.018	NTclustered	gi\|2894833396\|gb\|CP178454.1\|	3392114	g17693	i0	100	0.0453834115805947	29	0	5	0	426	454	4088887	4088859	Anabaena azotica SJ-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena azotica
12213534	12213534	PRJNA758087_P_NODE_9230_length_1073_cov_74.860000_g8211_i0	PRJNA758087	9230	1073	74.86	803.2478	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	512	4.16e-140	NTclustered	gi\|1210227864\|dbj\|AP018282.1\|	2005460	g8211	i0	96.743	0.447343895619758	307	10	29	0	26	332	66206	66512	Chondrocystis sp. NIES-4102 plasmid plasmid1 DNA, complete genome	blastn	480	512	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
13487466	13487466	PRJNA758087_P_NODE_37071_length_308_cov_1.800000_g35751_i0	PRJNA758087	37071	308	1.8	5.544	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	401	2.4799999999999992e-107	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g35751	i0	92.254	93.224025974026	284	20	92	2	2	284	3033	2751	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28713	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13956737	13956737	PRJNA758087_P_NODE_38191_length_294_cov_1.742081_g36871_i0	PRJNA758087	38191	294	1.742081	5.12171814	Cyanophyceae	3028117	Bacteria	Bacteria	342	1.45e-89	NTclustered	gi\|664803803\|gb\|KM019916.1\|	1521500	g36871	i0	100	66.7585034013605	185	0	63	0	24	208	1086	1270	Plectonema sp. SAG 38.90 16S ribosomal RNA gene, partial sequence	blastn	19627	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema sp. SAG 38.90
16505642	16505642	PRJNA758087_P_NODE_29053_length_427_cov_3.923729_g27733_i0	PRJNA758087	29053	427	3.923729	16.75432283	Nostocaceae	1162	Bacteria	Bacteria	525	2.0199999999999998e-144	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g27733	i0	90.148	182.332552693208	406	37	95	3	1	404	2378140	2377736	Nostoc sp. PCC 7120 DNA, complete genome	blastn	77856	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
23686538	23686538	PRJNA758087_P_NODE_30539_length_402_cov_6.534954_g29219_i0	PRJNA758087	30539	402	6.534954	26.27051508	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	464	4.179999999999999e-126	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g29219	i0	91.667	126.174129353234	336	26	83	2	43	377	2089	1755	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	50722	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23686828	23686828	PRJNA758087_P_NODE_42379_length_248_cov_0.708571_g41059_i0	PRJNA758087	42379	248	0.708571	1.75725608	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	348	2.55e-91	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g41059	i0	97.537	93.4959677419355	203	5	82	0	1	203	2862	3064	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23187	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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