metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA797475" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA797475" and tax_kingdom = "Thermotogati"

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
781396	781396	PRJNA797475_P_NODE_24161_length_248_cov_0.880000_g24062_i0	PRJNA797475	24161	248	0.88	2.1824	Thermus sp. PS18	2849039	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g24062	i0	98.79	11.0161290322581	248	3	100	0	1	248	1383830	1383583	Thermus sp. PS18 chromosome, complete genome	blastn	2732	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
5045091	5045091	PRJNA797475_P_NODE_26384_length_245_cov_1.790698_g26285_i0	PRJNA797475	26384	245	1.790698	4.3872101	Thermus	270	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g26285	i0	100	5.95102040816327	245	0	100	0	1	245	876398	876154	Thermus scotoductus SA-01, complete genome	blastn	1458	453	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
5885044	5885044	PRJNA797475_P_NODE_29585_length_242_cov_0.911243_g29486_i0	PRJNA797475	29585	242	0.911243	2.20520806	Thermus sp. PS18	2849039	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g29486	i0	100	41.5082644628099	242	0	100	0	1	242	1612759	1613000	Thermus sp. PS18 chromosome, complete genome	blastn	10045	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
5885049	5885049	PRJNA797475_P_NODE_29885_length_241_cov_1.220238_g29786_i0	PRJNA797475	29885	241	1.220238	2.94077358	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g29786	i0	100	274.157676348548	241	0	100	0	1	241	1637725	1637485	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	66072	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
7159756	7159756	PRJNA797475_P_NODE_21146_length_251_cov_2.258427_g21047_i0	PRJNA797475	21146	251	2.258427	5.66865177	Thermus scotoductus	37636	Bacteria	Bacteria	285	2.06e-72	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g21047	i0	99.363	56.5816733067729	157	1	100	0	1	157	431162	431006	Thermus scotoductus SA-01, complete genome	blastn	14202	285	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
7595096	7595096	PRJNA797475_P_NODE_5746_length_420_cov_1.778098_g5648_i0	PRJNA797475	5746	420	1.778098	7.4680116	Deinococcus	1298	Bacteria	Bacteria	760	0	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g5648	i0	99.52	195.004761904762	417	2	99	0	1	417	1454876	1454460	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	81902	760	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
10145499	10145499	PRJNA797475_P_NODE_6908_length_386_cov_2.597444_g6809_i0	PRJNA797475	6908	386	2.597444	10.02613384	Deinococcus	1298	Bacteria	Bacteria	662	0	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g6809	i0	97.662	105.715025906736	385	9	99	0	2	386	814	430	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	40806	662	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
13535037	13535037	PRJNA797475_P_NODE_19271_length_261_cov_2.808511_g19172_i0	PRJNA797475	19271	261	2.808511	7.33021371	Thermus scotoductus	37636	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g19172	i0	100	6.77777777777778	261	0	100	0	1	261	1163564	1163304	Thermus scotoductus SA-01, complete genome	blastn	1769	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
14809873	14809873	PRJNA797475_P_NODE_16332_length_277_cov_1.073529_g16233_i0	PRJNA797475	16332	277	1.073529	2.97367533	Fervidobacterium nodosum	2424	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g16233	i0	99.639	1	277	1	100	0	1	277	490432	490708	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	277	507	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
14809911	14809911	PRJNA797475_P_NODE_19932_length_258_cov_1.286486_g19833_i0	PRJNA797475	19932	258	1.286486	3.31913388	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	466	7.08e-127	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g19833	i0	99.225	93.8565891472868	258	2	100	0	1	258	565599	565342	Thermus sp. NEB1569 chromosome, complete genome	blastn	24215	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
16519850	16519850	PRJNA797475_P_NODE_22813_length_250_cov_0.870056_g22714_i0	PRJNA797475	22813	250	0.870056	2.17514	Thermus	270	Bacteria	Bacteria	401	1.9499999999999994e-107	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g22714	i0	95.6	3.988	250	11	100	0	1	250	561679	561928	Thermus scotoductus SA-01, complete genome	blastn	997	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
17359781	17359781	PRJNA797475_P_NODE_21034_length_252_cov_1.715084_g20935_i0	PRJNA797475	21034	252	1.715084	4.32201168	Deinococcus metallilatus	1211322	Bacteria	Bacteria	148	2.83e-31	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g20935	i0	79.524	0.833333333333333	210	41	83	2	6	214	2240502	2240710	Deinococcus metallilatus strain MA1002 chromosome	blastn	210	148	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
17359920	17359920	PRJNA797475_P_NODE_30314_length_241_cov_0.916667_g30215_i0	PRJNA797475	30314	241	0.916667	2.20916747	Thermus scotoductus	37636	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g30215	i0	97.925	11.0829875518672	241	5	100	0	1	241	147965	148205	Thermus scotoductus SA-01, complete genome	blastn	2671	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
17794613	17794613	PRJNA797475_P_NODE_10454_length_326_cov_0.913043_g10355_i0	PRJNA797475	10454	326	0.913043	2.97652018	Thermus	270	Bacteria	Bacteria	575	1.4699999999999996e-159	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g10355	i0	98.466	47.0950920245399	326	5	100	0	1	326	2234032	2233707	Thermus scotoductus SA-01, complete genome	blastn	15353	580	0.991379310344828	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
17794672	17794672	PRJNA797475_P_NODE_24894_length_247_cov_0.885057_g24795_i0	PRJNA797475	24894	247	0.885057	2.18609079	Thermus	270	Bacteria	Bacteria	429	8.83e-116	NTclustered	gi\|2440484278\|gb\|CP046617.1\|	88190	g24795	i0	97.976	44.1983805668016	247	5	100	0	1	247	516661	516907	Thermus antranikianii strain JCM 19900 chromosome, complete genome	blastn	10917	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
17794675	17794675	PRJNA797475_P_NODE_25794_length_246_cov_0.890173_g25695_i0	PRJNA797475	25794	246	0.890173	2.18982558	Thermus	270	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g25695	i0	99.593	28.3658536585366	246	1	100	0	1	246	111655	111900	Thermus scotoductus SA-01, complete genome	blastn	6978	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
18632768	18632768	PRJNA797475_P_NODE_10375_length_327_cov_0.952756_g10276_i0	PRJNA797475	10375	327	0.952756	3.11551212	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	588	1.8999999999999994e-163	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g10276	i0	99.083	30.1253822629969	327	3	100	0	1	327	369410	369736	Thermus sp. NEB1569 chromosome, complete genome	blastn	9851	588	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
18632950	18632950	PRJNA797475_P_NODE_25715_length_246_cov_0.890173_g25616_i0	PRJNA797475	25715	246	0.890173	2.18982558	Thermus parvatiensis	456163	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|982540758\|gb\|CP014142.1\|	456163	g25616	i0	98.374	1	246	4	100	0	1	246	68815	68570	Thermus parvatiensis strain RL plasmid pTP143, complete sequence	blastn	246	433	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
21619059	21619059	PRJNA797475_P_NODE_20517_length_255_cov_1.313187_g20418_i0	PRJNA797475	20517	255	1.313187	3.34862685	Thermus	270	Bacteria	Bacteria	460	3.25e-125	NTclustered	gi\|2440484278\|gb\|CP046617.1\|	88190	g20418	i0	99.216	13.2	255	2	100	0	1	255	1720163	1719909	Thermus antranikianii strain JCM 19900 chromosome, complete genome	blastn	3366	460	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
22458515	22458515	PRJNA797475_P_NODE_21258_length_251_cov_1.511236_g21159_i0	PRJNA797475	21258	251	1.511236	3.79320236	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g21159	i0	98.008	20.2749003984064	251	5	100	0	1	251	1528888	1529138	Thermus sp. NEB1569 chromosome, complete genome	blastn	5089	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
22458541	22458541	PRJNA797475_P_NODE_23118_length_249_cov_0.982955_g23019_i0	PRJNA797475	23118	249	0.982955	2.44755795	Thermus antranikianii	88190	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g23019	i0	99.598	1	249	1	100	0	1	249	2300948	2301196	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	249	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
22894564	22894564	PRJNA797475_P_NODE_22918_length_249_cov_2.238636_g22819_i0	PRJNA797475	22918	249	2.238636	5.57420364	Thermus	270	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g22819	i0	99.197	45.6305220883534	249	2	100	0	1	249	2065879	2066127	Thermus scotoductus SA-01, complete genome	blastn	11362	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
25007719	25007719	PRJNA797475_P_NODE_15040_length_283_cov_1.566667_g14941_i0	PRJNA797475	15040	283	1.566667	4.43366761	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	440	4.769999999999998e-119	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g14941	i0	94.718	6.02120141342756	284	13	100	2	1	283	478973	479255	Thermus sp. NEB1569 chromosome, complete genome	blastn	1704	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
25007786	25007786	PRJNA797475_P_NODE_21160_length_251_cov_2.033708_g21061_i0	PRJNA797475	21160	251	2.033708	5.10460708	Thermus thermophilus	274	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2074862828\|dbj\|AP024932.1\|	274	g21061	i0	99.602	22.3426294820717	251	1	100	0	1	251	5998	6248	Thermus thermophilus AA2-2 plasmid pAA2-2d DNA, complete sequence	blastn	5608	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
25007933	25007933	PRJNA797475_P_NODE_30720_length_237_cov_2.506098_g30621_i0	PRJNA797475	30720	237	2.506098	5.93945226	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	433	6.5e-117	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g30621	i0	99.578	8.88185654008439	237	1	100	0	1	237	1663816	1663580	Thermus sp. NEB1569 chromosome, complete genome	blastn	2105	433	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569

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