metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJEB2333" and tax

16 rows where analysis = "blastn", bioproject = "PRJEB2333" 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
22864	22864	PRJEB2333_P_NODE_3301_length_404_cov_2.754768_g2525_i0	PRJEB2333	3301	404	2.754768	11.12926272	Sanguibacter biliveldensis	3030830	Bacteria	Bacteria	525	1.8999999999999994e-144	NTclustered	gi\|2621750761\|gb\|CP138359.1\|	3030830	g2525	i0	91.601	306.44801980198	381	31	98	1	24	404	794920	794541	Sanguibacter biliveldensis strain 4.1 chromosome, complete genome	blastn	123805	525	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Sanguibacteraceae	Sanguibacter	Sanguibacter biliveldensis
2261424	2261424	PRJEB2333_P_NODE_2442_length_623_cov_2.129693_g1678_i1	PRJEB2333	2442	623	2.129693	13.26798739	Micrococcus	1269	Bacteria	Bacteria	606	1.0499999999999997e-168	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g1678	i1	96.237	143.337078651685	372	11	80	2	1	369	2260414	2260785	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	89299	606	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
6089282	6089282	PRJEB2333_P_NODE_4665_length_156_cov_3.016807_g3888_i0	PRJEB2333	4665	156	3.016807	4.70621892	Actinomyces	1654	Bacteria	Bacteria	226	7.149999999999997e-55	NTclustered	gi\|1948661326\|gb\|CP066049.1\|	1655	g3888	i0	93.96	225.525641025641	149	9	96	0	3	151	295683	295831	Actinomyces naeslundii strain FDAARGOS_1037 chromosome, complete genome	blastn	35182	228	0.991228070175439	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces naeslundii
7363893	7363893	PRJEB2333_P_NODE_4606_length_158_cov_2.198347_g3829_i0	PRJEB2333	4606	158	2.198347	3.47338826	root	1	Root_unresolved	Root_unresolved	292	7.07e-75	NTclustered	gi\|1226527082\|gb\|MF578812.1\|	1655	g3829	i0	100	100	158	0	100	0	1	158	325	482	Actinomyces naeslundii strain K55 16S ribosomal RNA gene, partial sequence	blastn	15800	292	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces naeslundii
8639258	8639258	PRJEB2333_P_NODE_3347_length_399_cov_1.848066_g2571_i0	PRJEB2333	3347	399	1.848066	7.37378334	Micrococcaceae	1268	Bacteria	Bacteria	248	4.54e-61	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g2571	i0	96.078	196.428571428571	153	4	70	1	1	153	562058	562208	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	78375	248	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
11189486	11189486	PRJEB2333_P_NODE_2769_length_489_cov_1.584071_g1998_i0	PRJEB2333	2769	489	1.584071	7.74610719	Corynebacterium	1716	Bacteria	Bacteria	318	4.259999999999999e-82	NTclustered	gi\|2869797333\|gb\|CP175765.1\|	38304	g1998	i0	100	250.298568507157	172	0	68	0	318	489	2720	2891	Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome	blastn	122396	318	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
16288860	16288860	PRJEB2333_P_NODE_3633_length_228_cov_2.251309_g2856_i0	PRJEB2333	3633	228	2.251309	5.13298452	Nocardioides	1839	Bacteria	Bacteria	392	1.0499999999999997e-104	NTclustered	gi\|1321370352\|gb\|CP025581.1\|	2045452	g2856	i0	97.807	255.486842105263	228	4	100	1	1	228	999333	999107	Nocardioides houyundeii strain 78 chromosome, complete genome	blastn	58251	392	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides houyundeii
17564022	17564022	PRJEB2333_P_NODE_3334_length_400_cov_2.476584_g2558_i0	PRJEB2333	3334	400	2.476584	9.906336	Micrococcus	1269	Bacteria	Bacteria	233	1.2799999999999998e-56	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g2558	i0	98.485	133.8675	132	2	33	0	2	133	345471	345602	Micrococcus luteus strain V017 chromosome, complete genome	blastn	53547	233	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
17564031	17564031	PRJEB2333_P_NODE_4094_length_180_cov_5.706294_g3317_i0	PRJEB2333	4094	180	5.706294	10.2713292	Rothia	32207	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g3317	i0	100	313.716666666667	180	0	100	0	1	180	651955	651776	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	56469	333	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
20112697	20112697	PRJEB2333_P_NODE_3856_length_198_cov_6.608696_g3079_i0	PRJEB2333	3856	198	6.608696	13.08521808	Micrococcaceae	1268	Bacteria	Bacteria	366	5.4e-97	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g3079	i0	100	408.752525252525	198	0	100	0	1	198	100856	100659	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	80933	366	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
21699594	21699594	PRJEB2333_P_NODE_4178_length_175_cov_2.420290_g3401_i0	PRJEB2333	4178	175	2.42029	4.2355075	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	274	2.89e-69	NTclustered	gi\|2694275225\|gb\|CP140010.1\|	1528099	g3401	i0	94.857	255.634285714286	175	9	100	0	1	175	1854078	1854252	MAG: Lawsonella clevelandensis isolate TECA_312545_bc_10 chromosome	blastn	44736	274	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
23938479	23938479	PRJEB2333_P_NODE_2339_length_686_cov_3.027735_g1583_i0	PRJEB2333	2339	686	3.027735	20.7702621	Rothia	32207	Bacteria	Bacteria	619	1.4999999999999996e-172	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g1583	i0	94.541	309.316326530612	403	18	92	4	287	686	1004404	1004003	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	212191	619	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
25212230	25212230	PRJEB2333_P_NODE_2440_length_623_cov_2.378840_g1678_i0	PRJEB2333	2440	623	2.37884	14.8201732	Micrococcus	1269	Bacteria	Bacteria	597	6.329999999999999e-166	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g1678	i0	96.185	143.199036918138	367	11	79	2	260	623	2260780	2260414	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	89213	597	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
25212236	25212236	PRJEB2333_P_NODE_2680_length_513_cov_1.861345_g1910_i0	PRJEB2333	2680	513	1.861345	9.54869985	Mycobacteriales	85007	Bacteria	Bacteria	390	9.37e-104	NTclustered	gi\|2663843834\|gb\|CP143053.1\|	321318	g1910	i0	95.528	137.884990253411	246	8	47	2	271	513	853464	853709	Dietzia cinnamea strain 55 chromosome	blastn	70735	390	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Dietziaceae	Dietzia	Dietzia cinnamea
25212248	25212248	PRJEB2333_P_NODE_3300_length_404_cov_3.160763_g2524_i0	PRJEB2333	3300	404	3.160763	12.76948252	Rothia	32207	Bacteria	Bacteria	640	6.5e-179	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g2524	i0	95.297	278.299504950495	404	17	99	2	1	403	651955	651553	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	112433	645	0.992248062015504	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
25212253	25212253	PRJEB2333_P_NODE_3580_length_240_cov_2.871921_g2803_i0	PRJEB2333	3580	240	2.871921	6.8926104	Micrococcus	1269	Bacteria	Bacteria	394	3.11e-105	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g2803	i0	96.25	260.1125	240	9	100	0	1	240	346591	346352	Micrococcus luteus strain V017 chromosome, complete genome	blastn	62427	394	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus

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