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

10 rows where analysis = "blastn", bioproject = "PRJNA615175" 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
594877	594877	PRJNA615175_P_NODE_19861_length_312_cov_1.184100_g19693_i0	PRJNA615175	19861	312	1.1841	3.694392	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	444	4.12e-120	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g19693	i0	92.308	2.40384615384615	312	24	100	0	1	312	1574733	1574422	Calothrix sp. PCC 7716 DNA, complete genome	blastn	750	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
2425003	2425003	PRJNA615175_P_NODE_1362_length_1268_cov_2.365690_g1269_i0	PRJNA615175	1362	1268	2.36569	29.9969492	Thermoleptolyngbya	2303528	Bacteria	Bacteria	1866	0	NTclustered	gi\|2592622306\|gb\|CP053540.1\|	2547457	g1269	i0	93.182	181.070189274448	1276	77	100	10	1	1268	312079	313352	Thermoleptolyngbya oregonensis NK1-22 chromosome, complete genome	blastn	229597	1882	0.991498405951116	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya oregonensis
5698333	5698333	PRJNA615175_P_NODE_13985_length_380_cov_2.869707_g13817_i0	PRJNA615175	13985	380	2.869707	10.9048866	Aliterella chasmolithica	2739056	Bacteria	Bacteria	603	7.969999999999999e-168	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g13817	i0	95.263	185.976315789474	380	18	100	0	1	380	2084	2463	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	70671	603	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
12074178	12074178	PRJNA615175_P_NODE_19850_length_312_cov_1.280335_g19682_i0	PRJNA615175	19850	312	1.280335	3.9946452	Kovacikia minuta	2931930	Bacteria	Bacteria	355	1.99e-93	NTclustered	gi\|2098452651\|gb\|CP083582.1\|	2653194	g19682	i0	89.68	234.294871794872	281	25	89	4	34	312	4176606	4176328	Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome	blastn	73100	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Kovacikia	Kovacikia minuta
14623825	14623825	PRJNA615175_P_NODE_24192_length_277_cov_2.264706_g24024_i0	PRJNA615175	24192	277	2.264706	6.27323562	cyanobacterium NIES-2125	2510788	Bacteria	Bacteria	239	1.82e-58	NTclustered	gi\|1566846232\|dbj\|LC455610.1\|	2510788	g24024	i0	82.31	149.736462093863	277	47	100	2	1	277	476	202	Cyanobacterium NIES-2125 gene for 23S ribosomal RNA, partial sequence	blastn	41477	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-2125
16452588	16452588	PRJNA615175_P_NODE_24553_length_274_cov_3.313433_g24385_i0	PRJNA615175	24553	274	3.313433	9.07880642	Nostocales	1161	Bacteria	Bacteria	403	6.03e-108	NTclustered	gi\|333109175\|gb\|JF768745.1\|	1029747	g24385	i0	93.704	305.554744525547	270	15	98	2	1	269	2104	2372	Aphanizomenon ovalisporum ILC-164 rDNA type 2 operon, complete sequence	blastn	83722	407	0.99017199017199	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Umezakia	Umezakia ovalisporum
18446719	18446719	PRJNA615175_P_NODE_10975_length_439_cov_1.893443_g10807_i0	PRJNA615175	10975	439	1.893443	8.31221477	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	654	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g10807	i0	95.813	271.911161731207	406	15	92	2	6	410	9969228	9968824	Calothrix sp. PCC 7716 DNA, complete genome	blastn	119369	654	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
21551764	21551764	PRJNA615175_P_NODE_7057_length_569_cov_5.038306_g6892_i0	PRJNA615175	7057	569	5.038306	28.66796114	Prochlorococcus	1218	Bacteria	Bacteria	555	3.509999999999999e-153	NTclustered	gi\|2895571264\|gb\|CP138937.1\|	59922	g6892	i0	84.441	168.95957820738101	572	80	100	7	1	569	1333	768	Prochlorococcus marinus str. MIT 9303 chromosome, complete genome	blastn	96138	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
23547298	23547298	PRJNA615175_P_NODE_14599_length_371_cov_1.033557_g14431_i0	PRJNA615175	14599	371	1.033557	3.83449647	Brasilonema sennae	1397703	Bacteria	Bacteria	228	5.459999999999999e-55	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g14431	i0	82.331	27.9676549865229	266	43	71	4	1	264	1575312	1575575	Brasilonema sennae CENA114 chromosome	blastn	10376	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
25376142	25376142	PRJNA615175_P_NODE_14380_length_374_cov_2.558140_g14212_i0	PRJNA615175	14380	374	2.55814	9.5674436	Leptolyngbya	47251	Bacteria	Bacteria	603	7.829999999999997e-168	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g14212	i0	95.733	181.991978609626	375	14	100	2	1	374	248179	248552	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	68065	608	0.991776315789474	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana

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