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

13 rows where analysis = "blastn", bioproject = "PRJNA764222" 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
6309858	6309858	PRJNA764222_S_NODE_4545_length_317_cov_1.992593_g4387_i0	PRJNA764222	4545	317	1.992593	6.31651981	Cutibacterium	1912216	Bacteria	Bacteria	586	6.579999999999998e-163	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4387	i0	100	272.003154574133	317	0	100	0	1	317	56697	57013	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	86225	586	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10134404	10134404	PRJNA764222_S_NODE_4728_length_314_cov_1.955056_g4570_i0	PRJNA764222	4728	314	1.955056	6.13887584	Cutibacterium	1912216	Bacteria	Bacteria	575	1.4099999999999994e-159	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4570	i0	99.683	269.070063694268	315	0	100	1	1	314	56233	56547	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	84488	575	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11409574	11409574	PRJNA764222_S_NODE_18569_length_216_cov_1.538462_g18411_i0	PRJNA764222	18569	216	1.538462	3.32307792	Streptomyces	1883	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2656536241\|gb\|CP109419.1\|	2903888	g18411	i0	92.308	0.361111111111111	39	1	17	2	113	149	679940	679902	Streptomyces sp. NBC_01508 chromosome, complete genome	blastn	78	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01508
12224243	12224243	PRJNA764222_S_NODE_13890_length_239_cov_2.208333_g13732_i0	PRJNA764222	13890	239	2.208333	5.27791587	Rothia kristinae	37923	Bacteria	Bacteria	326	1.15e-84	NTclustered	gi\|1943322775\|gb\|CP065738.1\|	37923	g13732	i0	91.322	334.305439330544	242	16	100	5	1	239	984256	984017	Rothia kristinae strain FDAARGOS_864 chromosome, complete genome	blastn	79899	326	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia kristinae
13498450	13498450	PRJNA764222_S_NODE_24471_length_190_cov_2.706294_g24313_i0	PRJNA764222	24471	190	2.706294	5.1419586	Cutibacterium acnes	1747	Bacteria	Bacteria	302	1.47e-77	NTclustered	gi\|2415255273\|gb\|CP114143.1\|	1734925	g24313	i0	100	38.6052631578947	163	0	86	0	1	163	436264	436426	Cutibacterium acnes subsp. acnes strain CCSM0331 chromosome, complete genome	blastn	7335	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13959714	13959714	PRJNA764222_S_NODE_1431_length_491_cov_5.396396_g1278_i0	PRJNA764222	1431	491	5.396396	26.49630436	Cutibacterium	1912216	Bacteria	Bacteria	907	0	NTclustered	gi\|1755605466\|dbj\|AP019664.1\|	1747	g1278	i0	100	272.979633401222	491	0	100	0	1	491	775254	775744	Cutibacterium acnes TP-CU389 DNA, complete genome	blastn	134033	907	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13959770	13959770	PRJNA764222_S_NODE_24351_length_191_cov_1.465278_g24193_i0	PRJNA764222	24351	191	1.465278	2.79868098	Micrococcus	1269	Bacteria	Bacteria	348	1.87e-91	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g24193	i0	99.476	297.083769633508	191	1	100	0	1	191	346911	346721	Micrococcus luteus strain V017 chromosome, complete genome	blastn	56743	348	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
17322969	17322969	PRJNA764222_S_NODE_20314_length_208_cov_1.503106_g20156_i0	PRJNA764222	20314	208	1.503106	3.12646048	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	161	2.8999999999999997e-35	NTclustered	gi\|2874253834\|emb\|OY969884.1\|	3039803	g20156	i0	81.592	4.61057692307692	201	31	95	6	3	200	33434	33631	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.c.2 genome assembly, chromosome: 1	blastn	959	161	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
20332148	20332148	PRJNA764222_S_NODE_16376_length_226_cov_2.513966_g16218_i0	PRJNA764222	16376	226	2.513966	5.68156316	Cutibacterium	1912216	Bacteria	Bacteria	357	3.81e-94	NTclustered	gi\|1059945062\|gb\|CP016954.1\|	33010	g16218	i0	95.175	287.849557522124	228	7	100	3	1	226	22481	22256	Cutibacterium avidum strain DPC 6544, complete genome	blastn	65054	357	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium avidum
21147327	21147327	PRJNA764222_S_NODE_31597_length_164_cov_3.700855_g31439_i0	PRJNA764222	31597	164	3.700855	6.0694022	Kocuria palustris	71999	Bacteria	Bacteria	252	1.26e-62	NTclustered	gi\|923033569\|gb\|CP012507.1\|	71999	g31439	i0	95.031	274.841463414634	161	7	98	1	1	160	501399	501559	Kocuria palustris strain MU14/1, complete genome	blastn	45074	252	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria palustris
24157457	24157457	PRJNA764222_S_NODE_2719_length_366_cov_4.670846_g2561_i0	PRJNA764222	2719	366	4.670846	17.09529636	Corynebacterium	1716	Bacteria	Bacteria	632	9.759999999999998e-177	NTclustered	gi\|2869797333\|gb\|CP175765.1\|	38304	g2561	i0	97.814	369.136612021858	366	8	100	0	1	366	2560	2925	Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome	blastn	135104	638	0.990595611285266	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
24157476	24157476	PRJNA764222_S_NODE_30419_length_168_cov_1.652893_g30261_i0	PRJNA764222	30419	168	1.652893	2.77686024	Corynebacterium	1716	Bacteria	Bacteria	300	4.56e-77	NTclustered	gi\|2531251647\|gb\|CP046606.1\|	144183	g30261	i0	98.817	373.666666666667	169	1	100	1	1	168	1150374	1150206	Corynebacterium afermentans subsp. afermentans strain DSM 44280 chromosome, complete genome	blastn	62776	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium afermentans
25432405	25432405	PRJNA764222_S_NODE_2160_length_401_cov_1.985876_g2002_i0	PRJNA764222	2160	401	1.985876	7.96336276	Corynebacterium	1716	Bacteria	Bacteria	654	0	NTclustered	gi\|2869840509\|gb\|CP175798.1\|	38304	g2002	i0	96.259	393.69825436409	401	11	99	4	3	401	2217968	2217570	Corynebacterium tuberculostearicum strain YSMAA1_1_C1 chromosome, complete genome	blastn	157873	654	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum

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