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

11 rows where analysis = "blastn", bioproject = "PRJNA450343" 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
4266041	4266041	PRJNA450343_P_NODE_11384_length_166_cov_0.871795_g11316_i0	PRJNA450343	11384	166	0.871795	1.4471797	Nostoc commune	1178	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2237836329\|dbj\|AP025733.1\|	449208	g11316	i0	100	0.168674698795181	28	0	17	0	125	152	204226	204199	Nostoc cf. commune SO-36 plasmid pANSO36A DNA, complete sequence	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
6195547	6195547	PRJNA450343_P_NODE_14265_length_151_cov_2.147059_g14197_i0	PRJNA450343	14265	151	2.147059	3.24205909	Acaryochloris	155977	Bacteria	Bacteria	191	2.4999999999999997e-44	NTclustered	gi\|470482548\|ref\|NR_076538.1\|	155978	g14197	i0	89.474	148.993377483444	152	14	100	2	1	151	1471	1321	Acaryochloris marina strain MBIC11017 23S ribosomal RNA gene, complete sequence	blastn	22498	191	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris marina
7470477	7470477	PRJNA450343_P_NODE_8706_length_184_cov_1.511111_g8638_i0	PRJNA450343	8706	184	1.511111	2.78044424	Oscillatoriales	1150	Bacteria	Bacteria	340	2.99e-89	NTclustered	gi\|1566846289\|dbj\|LC455669.1\|	118562	g8638	i0	100	113.907608695652	184	0	100	0	1	184	2053	2236	Arthrospira platensis NIES-46 gene for 23S ribosomal RNA, partial sequence	blastn	20959	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
8745488	8745488	PRJNA450343_P_NODE_14247_length_152_cov_2.223301_g14179_i0	PRJNA450343	14247	152	2.223301	3.37941752	Chroococcidiopsis	54298	Bacteria	Bacteria	244	1.91e-60	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g14179	i0	97.222	245.453947368421	144	4	95	0	1	144	793038	792895	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	37309	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
9366957	9366957	PRJNA450343_P_NODE_14248_length_152_cov_2.087379_g14180_i0	PRJNA450343	14248	152	2.087379	3.17281608	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	231	1.49e-56	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g14180	i0	94.118	279.473684210526	153	8	100	1	1	152	570719	570567	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	42480	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
11917796	11917796	PRJNA450343_P_NODE_330_length_985_cov_2.230769_g291_i0	PRJNA450343	330	985	2.230769	21.97307465	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1507	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g291	i0	94.428	119.98883248731	987	43	99	8	6	985	2912	1931	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	118189	1507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15741693	15741693	PRJNA450343_P_NODE_3533_length_285_cov_0.775424_g3465_i0	PRJNA450343	3533	285	0.775424	2.2099584	Gloeothece verrucosa	2546359	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g3465	i0	100	0.0982456140350877	28	0	10	0	244	271	3326146	3326173	Cyanothece sp. PCC 7822, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
15741728	15741728	PRJNA450343_P_NODE_8353_length_188_cov_1.035971_g8285_i0	PRJNA450343	8353	188	1.035971	1.94762548	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	302	1.4500000000000001e-77	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g8285	i0	95.745	257.909574468085	188	7	100	1	1	188	3668071	3668257	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	48487	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
18290671	18290671	PRJNA450343_P_NODE_10575_length_167_cov_1.347458_g10507_i0	PRJNA450343	10575	167	1.347458	2.25025486	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	204	3.65e-48	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g10507	i0	89.222	113.586826347305	167	13	99	4	1	165	2865	3028	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	18969	204	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22115562	22115562	PRJNA450343_P_NODE_12338_length_164_cov_0.886957_g12270_i0	PRJNA450343	12338	164	0.886957	1.45460948	Anthocerotibacter panamensis	2857077	Bacteria	Bacteria	128	2.21e-25	NTclustered	gi\|2040348944\|gb\|CP062698.1\|	2778476	g12270	i0	82.667	116.865853658537	150	21	90	5	16	163	374778	374632	Anthocerotibacter panamensis C109 chromosome, complete genome	blastn	19166	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Anthocerotibacteraceae	Anthocerotibacter	Anthocerotibacter panamensis
24665278	24665278	PRJNA450343_P_NODE_3120_length_304_cov_2.737255_g3052_i0	PRJNA450343	3120	304	2.737255	8.3212552	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	551	2.289999999999999e-152	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g3052	i0	99.342	128.065789473684	304	2	100	0	1	304	1938	1635	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	38932	551	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);;