metadata: contig_metadata: 14 rows where bioproject = "PRJNA1151638" and tax_clade = "Cyanobacteriota/Melainabacteria group"

14 rows where bioproject = "PRJNA1151638" 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
2312232	2312232	PRJNA1151638_P_NODE_1462_length_380_cov_4.732899_g1395_i0	PRJNA1151638	1462	380	4.732899	17.9850162	Calothrix	1186	Bacteria	Bacteria	499	1.08e-136	NTclustered	gi\|428233323\|gb\|CP003610.1\|	1170562	g1395	i0	94.462	238.778947368421	325	16	99	1	57	379	4990361	4990037	Calothrix sp. PCC 6303, complete genome	blastn	90736	503	0.992047713717694	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
4128810	4128810	PRJNA1151638_P_NODE_1284_length_402_cov_2.000000_g1217_i0	PRJNA1151638	1284	402	2	8.04	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	673	0	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g1217	i0	96.782	187.616915422886	404	11	100	2	1	402	1798	2201	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	75422	673	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5405066	5405066	PRJNA1151638_P_NODE_5005_length_251_cov_2.539326_g4938_i0	PRJNA1151638	5005	251	2.539326	6.37370826	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	425	1.16e-114	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g4938	i0	97.211	291.027888446215	251	7	100	0	1	251	1857153	1856903	Calothrix sp. PCC 7716 DNA, complete genome	blastn	73048	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
9229962	9229962	PRJNA1151638_P_NODE_508_length_614_cov_3.356747_g442_i0	PRJNA1151638	508	614	3.356747	20.61042658	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1003	0	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g442	i0	96.254	129.967426710098	614	20	100	2	1	614	2772	3382	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	79800	1003	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9965104	9965104	PRJNA1151638_P_NODE_1588_length_369_cov_2.814189_g1521_i0	PRJNA1151638	1588	369	2.814189	10.38435741	Nostocaceae	1162	Bacteria	Bacteria	604	2.149999999999999e-168	NTclustered	gi\|1405363668\|gb\|MF571536.1\|	1180	g1521	i0	96.206	307.373983739837	369	14	100	0	1	369	147	515	Nostoc sp. 23S ribosomal RNA gene, partial sequence	blastn	113421	604	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
10505739	10505739	PRJNA1151638_P_NODE_2129_length_331_cov_2.600775_g2062_i0	PRJNA1151638	2129	331	2.600775	8.60856525	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	573	5.379999999999998e-159	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g2062	i0	97.885	115.184290030211	331	7	100	0	1	331	2909	3239	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	38126	573	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10505864	10505864	PRJNA1151638_P_NODE_889_length_470_cov_2.176322_g822_i0	PRJNA1151638	889	470	2.176322	10.2287134	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	800	0	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g822	i0	97.441	134.270212765957	469	12	99	0	2	470	2148	1680	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	63107	800	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12515682	12515682	PRJNA1151638_P_NODE_1950_length_341_cov_3.652985_g1883_i0	PRJNA1151638	1950	341	3.652985	12.45667885	Chlorogloeopsis	1123	Bacteria	Bacteria	427	4.58e-115	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g1883	i0	89.412	176.765395894428	340	34	99	2	1	339	1851878	1852216	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	60277	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
12515707	12515707	PRJNA1151638_P_NODE_6390_length_243_cov_6.770588_g6323_i0	PRJNA1151638	6390	243	6.770588	16.45252884	Trichocoleus	450526	Bacteria	Bacteria	387	5.29e-103	NTclustered	gi\|1373417991\|gb\|KY511275.1\|	1382649	g6323	i0	96.186	174.724279835391	236	9	97	0	8	243	1408	1173	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	42458	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus desertorum
19428114	19428114	PRJNA1151638_P_NODE_6616_length_242_cov_1.846154_g6549_i0	PRJNA1151638	6616	242	1.846154	4.46769268	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	370	5.3e-98	NTclustered	gi\|225696181\|gb\|FJ805848.1\|	259957	g6549	i0	94.239	108.115702479339	243	12	100	2	1	242	3787	4028	Uncultured Chroococcidiopsis sp. clone AU1_7 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26164	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20703375	20703375	PRJNA1151638_P_NODE_4057_length_266_cov_2.725389_g3990_i0	PRJNA1151638	4057	266	2.725389	7.24953474	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	359	1.28e-94	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g3990	i0	91.045	149.43984962406	268	20	99	4	2	266	1988	1722	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	39751	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21978793	21978793	PRJNA1151638_P_NODE_418_length_668_cov_4.142857_g354_i0	PRJNA1151638	418	668	4.142857	27.67428476	Aliterella chasmolithica	2739056	Bacteria	Bacteria	911	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g354	i0	98.088	164.673652694611	523	10	78	0	1	523	1978	2500	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	110002	911	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
23254263	23254263	PRJNA1151638_P_NODE_539_length_595_cov_2.111111_g473_i0	PRJNA1151638	539	595	2.111111	12.56111045	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	998	0	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g473	i0	96.975	105.233613445378	595	17	100	1	1	595	2933	2340	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	62614	998	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
31304182	31304182	PRJNA1151638_P_NODE_3895_length_270_cov_1.253807_g3828_i0	PRJNA1151638	3895	270	1.253807	3.3852789	Aliterella atlantica	1827278	Bacteria	Bacteria	101	7.450000000000001e-26	NR	WP_045056994.1	1827278	g3828	i0	94.3	0.588888888888889	53	3	58.9	0	159	1	1	53	WP_045056994.1 UPF0175 family protein [Aliterella atlantica]	diamond	159	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica

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