metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA478247" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA478247" and tax_superkingdom = "Bacteria"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
447836	447836	PRJNA478247_P_NODE_881_length_442_cov_3.670702_g776_i0	PRJNA478247	881	442	3.670702	16.22450284	Caldimonas aquatica	376175	Bacteria	Bacteria	412	1.6999999999999998e-110	NTclustered	gi\|2325778792\|gb\|CP110257.1\|	376175	g776	i0	96.761	206.692307692308	247	8	98	0	1	247	2127141	2127387	Caldimonas aquatica strain LMG 23380 chromosome, complete genome	blastn	91358	412	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Caldimonas	Caldimonas aquatica
1097152	1097152	PRJNA478247_P_NODE_3241_length_165_cov_2.536765_g3135_i0	PRJNA478247	3241	165	2.536765	4.18566225	Blastococcus	38501	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|507148190\|ref\|NR_102997.1\|	138336	g3135	i0	100	391.236363636364	165	0	100	0	1	165	2345	2509	Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence	blastn	64554	305	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
1722519	1722519	PRJNA478247_P_NODE_1162_length_366_cov_3.163205_g1056_i0	PRJNA478247	1162	366	3.163205	11.5773303	Ehrlichia ruminantium	779	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|58416339\|emb\|CR925677.1\|	302409	g1056	i0	100	0.0765027322404372	28	0	8	0	82	109	1307643	1307670	Ehrlichia ruminantium str. Gardel, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Anaplasmataceae	Ehrlichia	Ehrlichia ruminantium
3648284	3648284	PRJNA478247_P_NODE_1603_length_290_cov_2.900383_g1497_i0	PRJNA478247	1603	290	2.900383	8.4111107	Arthrobacter	1663	Bacteria	Bacteria	433	8.21e-117	NTclustered	gi\|2921126289\|gb\|CP102608.1\|	619291	g1497	i0	95.273	311.662068965517	275	10	94	3	1	274	459350	459078	Arthrobacter sp. N1 chromosome, complete genome	blastn	90382	433	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. N1
10025457	10025457	PRJNA478247_P_NODE_3508_length_154_cov_5.672000_g3402_i0	PRJNA478247	3508	154	5.672	8.73488	Bacillati	1783272	Bacteria	Bacteria	270	3.2099999999999992e-68	NTclustered	gi\|1883577788\|gb\|CP059343.1\|	1272	g3402	i0	100	124.038961038961	146	0	95	0	1	146	1048593	1048448	Kocuria varians strain 80 chromosome, complete genome	blastn	19102	272	0.992647058823529	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria varians
10651463	10651463	PRJNA478247_P_NODE_3129_length_171_cov_1.922535_g3023_i0	PRJNA478247	3129	171	1.922535	3.28753485	Temperatibacter marinus	1456591	Bacteria	Bacteria	193	8.089999999999999e-45	NTclustered	gi\|2578886475\|gb\|CP123872.1\|	1456591	g3023	i0	95.082	480.426900584795	122	6	71	0	50	171	1655784	1655663	Temperatibacter marinus strain NBRC 110045 chromosome, complete genome	blastn	82153	193	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Kordiimonadales	Temperatibacteraceae	Temperatibacter	Temperatibacter marinus
11300378	11300378	PRJNA478247_P_NODE_2449_length_211_cov_3.626374_g2343_i0	PRJNA478247	2449	211	3.626374	7.65164914	Massilia	149698	Bacteria	Bacteria	300	5.99e-77	NTclustered	gi\|1888689060\|gb\|CP050454.1\|	2709302	g2343	i0	96.667	235.672985781991	180	6	85	0	1	180	362599	362778	Massilia sp. Dwa41.01b chromosome, complete genome	blastn	49727	300	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia sp. Dwa41.01b
15125104	15125104	PRJNA478247_P_NODE_3212_length_166_cov_2.649635_g3106_i0	PRJNA478247	3212	166	2.649635	4.3983941	Burkholderiaceae	119060	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|532578729\|gb\|KC188318.1\|	305	g3106	i0	100	209	166	0	100	0	1	166	764	929	Ralstonia solanacearum strain CFBP 3059 23S ribosomal RNA gene, partial sequence	blastn	34694	307	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia solanacearum
18299347	18299347	PRJNA478247_P_NODE_2955_length_180_cov_2.066225_g2849_i0	PRJNA478247	2955	180	2.066225	3.719205	Friedmanniella luteola	546871	Bacteria	Bacteria	300	4.94e-77	NTclustered	gi\|1085823321\|emb\|LT629749.1\|	546871	g2849	i0	96.667	350.127777777778	180	6	100	0	1	180	1464051	1463872	Friedmanniella luteola strain DSM 21741 genome assembly, chromosome: I	blastn	63023	300	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Friedmanniella	Friedmanniella luteola
18948640	18948640	PRJNA478247_P_NODE_1175_length_364_cov_3.570149_g1069_i0	PRJNA478247	1175	364	3.570149	12.99534236	Gordonia	2053	Bacteria	Bacteria	516	1.02e-141	NTclustered	gi\|2714293900\|gb\|CP136137.1\|	40516	g1069	i0	95.107	372.656593406593	327	16	91	0	38	364	3354	3028	Gordonia hydrophobica strain 1610/1b chromosome	blastn	135647	516	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia hydrophobica
20223497	20223497	PRJNA478247_P_NODE_2716_length_195_cov_2.867470_g2610_i0	PRJNA478247	2716	195	2.86747	5.5915665	Burkholderiales	80840	Bacteria	Bacteria	339	1.15e-88	NTclustered	gi\|937187091\|gb\|KT786085.1\|	77133	g2610	i0	97.949	100	195	4	100	0	1	195	225	419	Uncultured bacterium clone OTU1706 16S ribosomal RNA gene, partial sequence	blastn	19500	339	1	Bacteria								uncultured bacterium
20223501	20223501	PRJNA478247_P_NODE_976_length_415_cov_2.562176_g870_i0	PRJNA478247	976	415	2.562176	10.6330304	Hymenobacter	89966	Bacteria	Bacteria	593	5.289999999999998e-165	NTclustered	gi\|2423912131\|gb\|CP115396.1\|	748197	g870	i0	92.548	372.865060240964	416	28	100	3	1	415	2575073	2575486	Hymenobacter yonginensis strain KCTC 22745 chromosome, complete genome	blastn	154739	593	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter yonginensis
20849381	20849381	PRJNA478247_P_NODE_3277_length_164_cov_1.503704_g3171_i0	PRJNA478247	3277	164	1.503704	2.46607456	Kocuria palustris	71999	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|923033569\|gb\|CP012507.1\|	71999	g3171	i0	98.78	321.609756097561	164	2	100	0	1	164	218430	218267	Kocuria palustris strain MU14/1, complete genome	blastn	52744	292	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria palustris
22774130	22774130	PRJNA478247_P_NODE_1558_length_296_cov_4.734082_g1452_i0	PRJNA478247	1558	296	4.734082	14.01288272	Acidovorax	12916	Bacteria	Bacteria	279	1.16e-70	NTclustered	gi\|290661199\|gb\|GU768194.1\|	77133	g1452	i0	98.125	83.5405405405405	160	3	89	0	137	296	40	199	Uncultured bacterium clone F776O8Q01BAA74 16S ribosomal RNA gene, partial sequence	blastn	24728	279	1	Bacteria								uncultured bacterium
24673862	24673862	PRJNA478247_P_NODE_1800_length_265_cov_2.580508_g1694_i0	PRJNA478247	1800	265	2.580508	6.8383462	Kocuria sp. KD4	2719588	Bacteria	Bacteria	442	1.2299999999999995e-119	NTclustered	gi\|1826585035\|gb\|CP050449.1\|	2719588	g1694	i0	98.79	353.449056603774	248	3	94	0	1	248	1836634	1836387	Kocuria sp. KD4 chromosome, complete genome	blastn	93664	442	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria sp. KD4
24673864	24673864	PRJNA478247_P_NODE_3440_length_157_cov_2.921875_g3334_i0	PRJNA478247	3440	157	2.921875	4.58734375	Caldimonas aquatica	376175	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|2325778792\|gb\|CP110257.1\|	376175	g3334	i0	100	205.152866242038	157	0	100	0	1	157	2127169	2127013	Caldimonas aquatica strain LMG 23380 chromosome, complete genome	blastn	32209	291	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Caldimonas	Caldimonas aquatica
24673869	24673869	PRJNA478247_P_NODE_500_length_640_cov_7.384615_g405_i0	PRJNA478247	500	640	7.384615	47.261536	Streptomyces sp. GQFP	2907545	Bacteria	Bacteria	63.9	2.94e-5	NTclustered	gi\|2181538142\|gb\|CP089312.1\|	2907545	g405	i0	95	0.2828125	40	2	6	0	25	64	7470618	7470579	Streptomyces sp. GQFP chromosome	blastn	181	63.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. GQFP

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