metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA854078" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA854078" and tax_kingdom = "Bacillati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
841657	841657	PRJNA854078_P_NODE_13341_length_257_cov_1.673913_g13129_i0	PRJNA854078	13341	257	1.673913	4.30195641	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	128	3.78e-25	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g13129	i0	85.714	0.490272373540856	126	12	48	4	52	174	2122126	2122004	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	126	128	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
2117075	2117075	PRJNA854078_P_NODE_15742_length_244_cov_0.900585_g15530_i0	PRJNA854078	15742	244	0.900585	2.1974274	Abyssicoccus albus	1817405	Bacteria	Bacteria	407	4.08e-109	NTclustered	gi\|1142909432\|gb\|CP019573.1\|	1817405	g15530	i0	96.721	1	244	8	100	0	1	244	750843	751086	Abyssicoccus albus strain S31 chromosome, complete genome	blastn	244	407	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Abyssicoccaceae	Abyssicoccus	Abyssicoccus albus
2510325	2510325	PRJNA854078_P_NODE_16802_length_238_cov_2.836364_g16590_i0	PRJNA854078	16802	238	2.836364	6.75054632	Corynebacterium	1716	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|1540233514\|emb\|LR134504.1\|	43768	g16590	i0	100	103	238	0	100	0	1	238	522341	522104	Corynebacterium matruchotii strain NCTC10206 genome assembly, chromosome: 1	blastn	24514	440	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium matruchotii
3392376	3392376	PRJNA854078_P_NODE_16683_length_241_cov_0.916667_g16471_i0	PRJNA854078	16683	241	0.916667	2.20916747	Corynebacterium marquesiae	2913503	Bacteria	Bacteria	412	8.64e-111	NTclustered	gi\|2869847307\|gb\|CP175787.1\|	2913503	g16471	i0	97.51	13.0580912863071	241	6	100	0	1	241	372995	372755	Corynebacterium marquesiae strain YSMAA1_1_H4 chromosome, complete genome	blastn	3147	412	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium marquesiae
3392395	3392395	PRJNA854078_P_NODE_3583_length_503_cov_1.330233_g3371_i0	PRJNA854078	3583	503	1.330233	6.69107199	Acholeplasma oculi	35623	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|644983578\|emb\|LK028559.1\|	35623	g3371	i0	100	0.0556660039761431	28	0	6	0	87	114	1297736	1297709	Acholeplasma oculi genome assembly Acholeplasma oculi strain 19L ,chromosome : 1	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma oculi
5062818	5062818	PRJNA854078_P_NODE_10524_length_290_cov_1.373272_g10312_i0	PRJNA854078	10524	290	1.373272	3.9824888	Bacillaceae	186817	Bacteria	Bacteria	536	6.079999999999999e-148	NTclustered	gi\|1893059056\|gb\|CP060137.1\|	2760090	g10312	i0	100	935.641379310345	290	0	100	0	1	290	915390	915679	Bacillus sp. PAMC26568 chromosome, complete genome	blastn	271336	536	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. PAMC26568
5944962	5944962	PRJNA854078_P_NODE_9885_length_299_cov_1.831858_g9673_i0	PRJNA854078	9885	299	1.831858	5.47725542	Corynebacterium matruchotii	43768	Bacteria	Bacteria	553	6.25e-153	NTclustered	gi\|1540233514\|emb\|LR134504.1\|	43768	g9673	i0	100	389.501672240803	299	0	100	0	1	299	519491	519193	Corynebacterium matruchotii strain NCTC10206 genome assembly, chromosome: 1	blastn	116461	553	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium matruchotii
7612778	7612778	PRJNA854078_P_NODE_10226_length_294_cov_1.393665_g10014_i0	PRJNA854078	10226	294	1.393665	4.0973751	Actinomyces	1654	Bacteria	Bacteria	481	2.94e-131	NTclustered	gi\|2219514734\|dbj\|AP025697.1\|	1655	g10014	i0	96.271	249.119047619048	295	8	100	3	1	294	486949	486657	Actinomyces naeslundii ATCC 27039 DNA, complete genome	blastn	73241	481	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces naeslundii
12714349	12714349	PRJNA854078_P_NODE_16390_length_242_cov_0.911243_g16178_i0	PRJNA854078	16390	242	0.911243	2.20520806	Cutibacterium	1912216	Bacteria	Bacteria	436	5.1499999999999985e-118	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g16178	i0	99.174	51	242	2	100	0	1	242	617633	617392	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12342	436	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
19086305	19086305	PRJNA854078_P_NODE_15815_length_244_cov_0.900585_g15603_i0	PRJNA854078	15815	244	0.900585	2.1974274	Cutibacterium	1912216	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g15603	i0	100	53.9631147540984	244	0	100	0	1	244	1634685	1634928	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13167	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
19086306	19086306	PRJNA854078_P_NODE_16595_length_241_cov_0.916667_g16383_i0	PRJNA854078	16595	241	0.916667	2.20916747	Rothia	32207	Bacteria	Bacteria	313	9.01e-81	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g16383	i0	90.083	5.79668049792531	242	22	100	2	1	241	1722642	1722882	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	1397	313	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
20361111	20361111	PRJNA854078_P_NODE_4396_length_453_cov_1.784211_g4184_i0	PRJNA854078	4396	453	1.784211	8.08247583	Pseudarthrobacter	1742993	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|1695528078\|gb\|CP041187.1\|	2590774	g4184	i0	100	0.1280353200883	29	0	6	0	381	409	1838926	1838954	Pseudarthrobacter sp. NIBRBAC000502771 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter sp. NIBRBAC000502771
23793923	23793923	PRJNA854078_P_NODE_3899_length_482_cov_1.264059_g3687_i0	PRJNA854078	3899	482	1.264059	6.09276438	Floricoccus penangensis	1859475	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|2252512656\|gb\|CP075561.1\|	1859475	g3687	i0	100	0.0622406639004149	30	0	6	0	20	49	1589670	1589699	Floricoccus penangensis strain ML061-4 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Floricoccus	Floricoccus penangensis

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