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

10 rows where analysis = "blastn", bioproject = "PRJNA695140" and tax_phylum = "Actinomycetota"

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
1952043	1952043	PRJNA695140_S_NODE_1442_length_445_cov_5.132353_g1263_i0	PRJNA695140	1442	445	5.132353	22.83897085	Pseudonocardia dioxanivorans	240495	Bacteria	Bacteria	505	2.749999999999999e-138	NTclustered	gi\|326948588\|gb\|CP002593.1\|	675635	g1263	i0	91.076	315.624719101124	381	22	84	11	1	375	4087467	4087841	Pseudonocardia dioxanivorans CB1190, complete genome	blastn	140453	505	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia dioxanivorans
1952081	1952081	PRJNA695140_S_NODE_5162_length_231_cov_2.860825_g4981_i0	PRJNA695140	5162	231	2.860825	6.60850575	Pseudonocardia petroleophila	37331	Bacteria	Bacteria	315	2.38e-81	NTclustered	gi\|1893041651\|gb\|CP060131.1\|	37331	g4981	i0	91.703	290.458874458874	229	15	97	2	7	231	2311	2083	Pseudonocardia petroleophila strain CGMCC 4.1532 chromosome, complete genome	blastn	67096	315	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia petroleophila
2456815	2456815	PRJNA695140_S_NODE_7682_length_190_cov_3.686275_g7501_i0	PRJNA695140	7682	190	3.686275	7.0039225	Pseudonocardia	1847	Bacteria	Bacteria	296	6.83e-76	NTclustered	gi\|470488300\|ref\|NR_076861.1\|	240495	g7501	i0	95.213	303.163157894737	188	8	98	1	4	190	1602	1415	Pseudonocardia dioxanivorans strain CB1190 23S ribosomal RNA gene, complete sequence	blastn	57601	296	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia dioxanivorans
4504166	4504166	PRJNA695140_S_NODE_6004_length_214_cov_4.169492_g5823_i0	PRJNA695140	6004	214	4.169492	8.92271288	Pseudonocardia sp. DSM 110487	2865833	Bacteria	Bacteria	385	1.64e-102	NTclustered	gi\|2077468618\|gb\|CP080521.1\|	2865833	g5823	i0	99.065	279.766355140187	214	2	100	0	1	214	1891639	1891852	Pseudonocardia sp. DSM 110487 chromosome, complete genome	blastn	59870	385	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia sp. DSM 110487
12660943	12660943	PRJNA695140_S_NODE_3570_length_276_cov_5.054393_g3389_i0	PRJNA695140	3570	276	5.054393	13.95012468	Pseudonocardia	1847	Bacteria	Bacteria	394	3.66e-105	NTclustered	gi\|470488300\|ref\|NR_076861.1\|	240495	g3389	i0	98.222	232.11231884058	225	4	82	0	1	225	1327	1551	Pseudonocardia dioxanivorans strain CB1190 23S ribosomal RNA gene, complete sequence	blastn	64063	394	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia dioxanivorans
12660993	12660993	PRJNA695140_S_NODE_9450_length_173_cov_1.117647_g9269_i0	PRJNA695140	9450	173	1.117647	1.93352931	Nocardiaceae	85025	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g9269	i0	100	359.346820809249	173	0	100	0	1	173	1621602	1621430	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	62167	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
16484391	16484391	PRJNA695140_S_NODE_10553_length_165_cov_0.898438_g10372_i0	PRJNA695140	10553	165	0.898438	1.4824227	Cutibacterium	1912216	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10372	i0	100	252.842424242424	165	0	100	0	1	165	57027	57191	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	41719	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
19033357	19033357	PRJNA695140_S_NODE_7255_length_195_cov_7.183544_g7074_i0	PRJNA695140	7255	195	7.183544	14.0079108	Pseudonocardiaceae	2070	Bacteria	Bacteria	289	1.1799999999999998e-73	NTclustered	gi\|2174763227\|gb\|CP090063.1\|	715473	g7074	i0	94.652	271.876923076923	187	8	95	2	1	186	818560	818375	Amycolatopsis acidiphila strain KCTC 39523 chromosome, complete genome	blastn	53016	291	0.993127147766323	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis acidiphila
25408040	25408040	PRJNA695140_S_NODE_2320_length_343_cov_4.905229_g2139_i0	PRJNA695140	2320	343	4.905229	16.82493547	Pseudonocardia	1847	Bacteria	Bacteria	551	2.619999999999999e-152	NTclustered	gi\|470488300\|ref\|NR_076861.1\|	240495	g2139	i0	95.627	249.201166180758	343	15	100	0	1	343	1153	811	Pseudonocardia dioxanivorans strain CB1190 23S ribosomal RNA gene, complete sequence	blastn	85476	556	0.991007194244604	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia dioxanivorans
25408071	25408071	PRJNA695140_S_NODE_5740_length_219_cov_4.384615_g5559_i0	PRJNA695140	5740	219	4.384615	9.60230685	Pseudonocardia	1847	Bacteria	Bacteria	361	2.83e-95	NTclustered	gi\|1464106963\|dbj\|AP018920.1\|	2074	g5559	i0	96.347	361.680365296804	219	8	100	0	1	219	646288	646506	Pseudonocardia autotrophica NBRC 12743 DNA, complete genome	blastn	79208	363	0.994490358126722	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia autotrophica

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