metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA602115" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA602115" 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
2418174	2418174	PRJNA602115_P_NODE_11122_length_203_cov_0.901408_g11097_i0	PRJNA602115	11122	203	0.901408	1.82985824	Cutibacterium	1912216	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g11097	i0	100	51	203	0	100	0	1	203	1187493	1187695	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	10353	375	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2418177	2418177	PRJNA602115_P_NODE_2142_length_408_cov_1.023055_g2117_i0	PRJNA602115	2142	408	1.023055	4.1740644	Cutibacterium	1912216	Bacteria	Bacteria	754	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2117	i0	100	300.303921568627	408	0	100	0	1	408	55601	56008	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	122524	754	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2418179	2418179	PRJNA602115_P_NODE_2782_length_362_cov_1.684385_g2757_i0	PRJNA602115	2782	362	1.684385	6.0974737	Mycobacteriaceae	1762	Bacteria	Bacteria	664	0	NTclustered	gi\|1935556990\|gb\|CP062008.1\|	1226753	g2757	i0	99.724	187.055248618785	362	1	100	0	1	362	1387858	1387497	Mycolicibacterium mucogenicum DSM 44124 chromosome, complete genome	blastn	67714	669	0.992526158445441	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium mucogenicum
8229093	8229093	PRJNA602115_P_NODE_9887_length_206_cov_0.882759_g9862_i0	PRJNA602115	9887	206	0.882759	1.81848354	Williamsia herbipolensis	1603258	Bacteria	Bacteria	335	1.5999999999999997e-87	NTclustered	gi\|2658946156\|gb\|CP108021.1\|	1603258	g9862	i0	96.117	325.417475728155	206	7	100	1	1	206	3888	3684	Williamsia herbipolensis strain NBC_00319 chromosome, complete genome	blastn	67036	335	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Williamsia	Williamsia herbipolensis
9504244	9504244	PRJNA602115_P_NODE_9228_length_208_cov_0.870748_g9203_i0	PRJNA602115	9228	208	0.870748	1.81115584	Geodermatophilaceae bacterium NBWT11	2596920	Bacteria	Bacteria	219	1.7e-52	NTclustered	gi\|1891431189\|gb\|CP043652.1\|	2596920	g9203	i0	88.043	78.7596153846154	184	22	88	0	25	208	121409	121592	Geodermatophilaceae bacterium NBWT11 chromosome, complete genome	blastn	16382	219	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae		Geodermatophilaceae bacterium NBWT11
12621920	12621920	PRJNA602115_P_NODE_8770_length_209_cov_0.864865_g8745_i0	PRJNA602115	8770	209	0.864865	1.80756785	Actinomycetes	1760	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1021079766\|dbj\|AP017424.1\|	39478	g8745	i0	100	0.267942583732057	28	0	13	0	68	95	68121	68148	Streptomyces laurentii DNA, complete genome, strain: ATCC 31255	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces laurentii
17153300	17153300	PRJNA602115_P_NODE_10214_length_205_cov_0.888889_g10189_i0	PRJNA602115	10214	205	0.888889	1.82222245	Mycolicibacterium aubagnense	319707	Bacteria	Bacteria	350	5.669999999999999e-92	NTclustered	gi\|1806292234\|dbj\|AP022577.1\|	319707	g10189	i0	97.549	5.97073170731707	204	5	99	0	1	204	3328729	3328932	Mycolicibacterium aubagnense JCM 15296 DNA, complete genome	blastn	1224	350	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium aubagnense
21544792	21544792	PRJNA602115_P_NODE_8477_length_213_cov_2.572368_g8452_i0	PRJNA602115	8477	213	2.572368	5.47914384	Exiguobacterium	33986	Bacteria	Bacteria	394	2.7e-105	NTclustered	gi\|2452055134\|gb\|CP109617.1\|	307643	g8452	i0	100	494.018779342723	213	0	100	0	1	213	40915	40703	Exiguobacterium profundum strain TSS-3 chromosome, complete genome	blastn	105226	394	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium profundum
24801907	24801907	PRJNA602115_P_NODE_3500_length_327_cov_0.778195_g3475_i0	PRJNA602115	3500	327	0.778195	2.54469765	Corynebacterium matruchotii	43768	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1540233514\|emb\|LR134504.1\|	43768	g3475	i0	100	0.171253822629969	28	0	9	0	151	178	2042681	2042708	Corynebacterium matruchotii strain NCTC10206 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium matruchotii
25369198	25369198	PRJNA602115_P_NODE_4000_length_309_cov_1.161290_g3975_i0	PRJNA602115	4000	309	1.16129	3.5883861	Mycobacteriaceae	1762	Bacteria	Bacteria	449	8.76e-122	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g3975	i0	92.903	155.145631067961	310	20	100	2	1	309	1313246	1312938	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	47940	449	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum

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