metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1113956" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1113956" and tax_phylum = "Deinococcota"

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
221896	221896	PRJNA1113956_P_NODE_20061_length_250_cov_0.870056_g19721_i0	PRJNA1113956	20061	250	0.870056	2.17514	Allomeiothermus silvanus	52022	Bacteria	Bacteria	377	3.29e-100	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g19721	i0	94	1	250	14	100	1	1	250	776785	777033	Meiothermus silvanus DSM 9946, complete genome	blastn	250	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
221902	221902	PRJNA1113956_P_NODE_20361_length_249_cov_0.875000_g20021_i0	PRJNA1113956	20361	249	0.875	2.17875	Allomeiothermus silvanus	52022	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g20021	i0	99.197	1	249	2	100	0	1	249	1731018	1730770	Meiothermus silvanus DSM 9946, complete genome	blastn	249	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
1496707	1496707	PRJNA1113956_P_NODE_20662_length_248_cov_0.880000_g20322_i0	PRJNA1113956	20662	248	0.88	2.1824	Allomeiothermus silvanus	52022	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g20322	i0	99.597	1	248	1	100	0	1	248	3043776	3043529	Meiothermus silvanus DSM 9946, complete genome	blastn	248	453	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
2772613	2772613	PRJNA1113956_P_NODE_21263_length_246_cov_0.890173_g20923_i0	PRJNA1113956	21263	246	0.890173	2.18982558	Allomeiothermus silvanus	52022	Bacteria	Bacteria	407	4.12e-109	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g20923	i0	96.721	3.61382113821138	244	8	99	0	3	246	1502207	1502450	Meiothermus silvanus DSM 9946, complete genome	blastn	889	407	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
2772632	2772632	PRJNA1113956_P_NODE_22863_length_241_cov_0.916667_g22523_i0	PRJNA1113956	22863	241	0.916667	2.20916747	Allomeiothermus silvanus	52022	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g22523	i0	97.925	1	241	5	100	0	1	241	2748096	2747856	Meiothermus silvanus DSM 9946, complete genome	blastn	241	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
5324901	5324901	PRJNA1113956_P_NODE_20445_length_249_cov_0.875000_g20105_i0	PRJNA1113956	20445	249	0.875	2.17875	Allomeiothermus silvanus	52022	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g20105	i0	100	1	249	0	100	0	1	249	818269	818517	Meiothermus silvanus DSM 9946, complete genome	blastn	249	460	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
5324932	5324932	PRJNA1113956_P_NODE_22385_length_242_cov_0.911243_g22045_i0	PRJNA1113956	22385	242	0.911243	2.20520806	Allomeiothermus silvanus	52022	Bacteria	Bacteria	388	1.46e-103	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g22045	i0	95.492	1.00826446280992	244	9	100	2	1	242	1290940	1290697	Meiothermus silvanus DSM 9946, complete genome	blastn	244	388	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
6600041	6600041	PRJNA1113956_P_NODE_16286_length_297_cov_1.080357_g15946_i0	PRJNA1113956	16286	297	1.080357	3.20866029	Meiothermus taiwanensis	172827	Bacteria	Bacteria	532	8.08e-147	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g15946	i0	98.99	73.6666666666667	297	3	100	0	1	297	1270381	1270085	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	21879	532	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
7874799	7874799	PRJNA1113956_P_NODE_17487_length_280_cov_0.753623_g17147_i0	PRJNA1113956	17487	280	0.753623	2.1101444	Trueperaceae bacterium	2026798	Bacteria	Bacteria	257	5.09e-64	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g17147	i0	83.942	350.010714285714	274	39	96	2	7	275	7779	7506	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	98003	257	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
7874846	7874846	PRJNA1113956_P_NODE_20607_length_248_cov_0.880000_g20267_i0	PRJNA1113956	20607	248	0.88	2.1824	Allomeiothermus silvanus	52022	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g20267	i0	99.194	15.6774193548387	248	2	100	0	1	248	1473631	1473878	Meiothermus silvanus DSM 9946, complete genome	blastn	3888	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
9149722	9149722	PRJNA1113956_P_NODE_21948_length_244_cov_0.871345_g21608_i0	PRJNA1113956	21948	244	0.871345	2.1260818	Allomeiothermus silvanus	52022	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|296852006\|gb\|CP002043.1\|	526227	g21608	i0	98.361	1.13114754098361	244	4	100	0	1	244	299542	299785	Meiothermus silvanus DSM 9946 plasmid pMESIL01, complete sequence	blastn	276	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
10425555	10425555	PRJNA1113956_P_NODE_21869_length_244_cov_0.900585_g21529_i0	PRJNA1113956	21869	244	0.900585	2.1974274	Allomeiothermus silvanus	52022	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g21529	i0	98.77	69.3852459016394	244	3	100	0	1	244	1357579	1357336	Meiothermus silvanus DSM 9946, complete genome	blastn	16930	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
11227173	11227173	PRJNA1113956_P_NODE_18169_length_270_cov_1.969543_g17829_i0	PRJNA1113956	18169	270	1.969543	5.3177661	Thermus	270	Bacteria	Bacteria	374	4.6499999999999986e-99	NTclustered	gi\|982540758\|gb\|CP014142.1\|	456163	g17829	i0	99.512	11.8851851851852	205	1	76	0	1	205	33747	33951	Thermus parvatiensis strain RL plasmid pTP143, complete sequence	blastn	3209	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
11700716	11700716	PRJNA1113956_P_NODE_19690_length_251_cov_0.865169_g19350_i0	PRJNA1113956	19690	251	0.865169	2.17157419	Thermus thermophilus	274	Bacteria	Bacteria	204	5.93e-48	NTclustered	gi\|2199613261\|dbj\|AP025596.1\|	274	g19350	i0	81.275	3	251	47	100	0	1	251	1097836	1097586	Thermus thermophilus SNM1-1 DNA, complete genome	blastn	753	204	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
12975817	12975817	PRJNA1113956_P_NODE_20931_length_247_cov_0.885057_g20591_i0	PRJNA1113956	20931	247	0.885057	2.18609079	Allomeiothermus silvanus	52022	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g20591	i0	98.381	1	247	4	100	0	1	247	3021201	3020955	Meiothermus silvanus DSM 9946, complete genome	blastn	247	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
14250936	14250936	PRJNA1113956_P_NODE_20992_length_247_cov_0.885057_g20652_i0	PRJNA1113956	20992	247	0.885057	2.18609079	Allomeiothermus silvanus	52022	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g20652	i0	98.381	1	247	4	100	0	1	247	2683296	2683050	Meiothermus silvanus DSM 9946, complete genome	blastn	247	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
14250967	14250967	PRJNA1113956_P_NODE_22792_length_241_cov_0.916667_g22452_i0	PRJNA1113956	22792	241	0.916667	2.20916747	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	368	1.9e-97	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g22452	i0	94.191	3.21161825726141	241	14	100	0	1	241	374716	374476	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	774	368	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
15051513	15051513	PRJNA1113956_P_NODE_21272_length_246_cov_0.890173_g20932_i0	PRJNA1113956	21272	246	0.890173	2.18982558	Deinococcus	1298	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g20932	i0	100	6.04471544715447	246	0	100	0	1	246	1668892	1668647	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	1487	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
18875533	18875533	PRJNA1113956_P_NODE_20435_length_249_cov_0.875000_g20095_i0	PRJNA1113956	20435	249	0.875	2.17875	Thermaceae	188786	Bacteria	Bacteria	431	2.4799999999999995e-116	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g20095	i0	97.984	98.8353413654618	248	5	99	0	2	249	137001	137248	Meiothermus silvanus DSM 9946, complete genome	blastn	24610	431	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
19347916	19347916	PRJNA1113956_P_NODE_22176_length_243_cov_0.905882_g21836_i0	PRJNA1113956	22176	243	0.905882	2.20129326	Allomeiothermus silvanus	52022	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g21836	i0	99.588	34.9547325102881	243	1	100	0	1	243	2666863	2667105	Meiothermus silvanus DSM 9946, complete genome	blastn	8494	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
20623021	20623021	PRJNA1113956_P_NODE_13377_length_347_cov_1.124088_g13037_i0	PRJNA1113956	13377	347	1.124088	3.90058536	Allomeiothermus silvanus	52022	Bacteria	Bacteria	388	2.2e-103	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g13037	i0	99.074	1.02017291066282	216	2	100	0	132	347	2870977	2870762	Meiothermus silvanus DSM 9946, complete genome	blastn	354	388	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
20623126	20623126	PRJNA1113956_P_NODE_22257_length_243_cov_0.905882_g21917_i0	PRJNA1113956	22257	243	0.905882	2.20129326	Allomeiothermus silvanus	52022	Bacteria	Bacteria	422	1.45e-113	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g21917	i0	97.942	1	243	5	100	0	1	243	1958685	1958443	Meiothermus silvanus DSM 9946, complete genome	blastn	243	422	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
21898899	21898899	PRJNA1113956_P_NODE_22618_length_241_cov_1.547619_g22278_i0	PRJNA1113956	22618	241	1.547619	3.72976179	Thermus thermophilus	274	Bacteria	Bacteria	58.4	4.66e-4	NTclustered	gi\|1955386990\|dbj\|AP024305.1\|	274	g22278	i0	89.583	0.672199170124481	48	1	19	3	184	229	1056030	1056075	Thermus thermophilus HB5008 DNA, complete genome	blastn	162	58.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
25250175	25250175	PRJNA1113956_P_NODE_21500_length_245_cov_0.895349_g21160_i0	PRJNA1113956	21500	245	0.895349	2.19360505	Deinococcus	1298	Bacteria	Bacteria	268	2.02e-67	NTclustered	gi\|2706840606\|gb\|CP149783.1\|	3112952	g21160	i0	86.585	10.3714285714286	246	30	100	3	1	245	443999	444242	Deinococcus sp. VB142 chromosome 2, complete sequence	blastn	2541	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142

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