metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA608660" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA608660" 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
1146946	1146946	PRJNA608660_P_NODE_1921_length_916_cov_23.884660_g1736_i0	PRJNA608660	1921	916	23.88466	218.7834856	Deinococcus	1298	Bacteria	Bacteria	1327	0	NTclustered	gi\|1189908037\|gb\|MF062563.1\|	57497	g1736	i0	93.444	104.319868995633	900	50	98	8	14	910	897	4	Deinococcus radiopugnans strain PYGV-1 16S ribosomal RNA gene, partial sequence	blastn	95557	1327	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
2422242	2422242	PRJNA608660_P_NODE_50642_length_156_cov_2.317757_g50285_i0	PRJNA608660	50642	156	2.317757	3.61570092	Deinococcus	1298	Bacteria	Bacteria	278	1.95e-70	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g50285	i0	99.346	201.608974358974	153	1	98	0	4	156	850	698	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	31451	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
3135351	3135351	PRJNA608660_P_NODE_11603_length_437_cov_2.149485_g11256_i0	PRJNA608660	11603	437	2.149485	9.39324945	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	579	1.5699999999999995e-160	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g11256	i0	97.626	198.295194508009	337	8	100	0	1	337	99088	98752	Deinococcus sp. AJ005 chromosome, complete genome	blastn	86655	579	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
4975154	4975154	PRJNA608660_P_NODE_9884_length_474_cov_4.905882_g9539_i0	PRJNA608660	9884	474	4.905882	23.25388068	Thermus	270	Bacteria	Bacteria	440	8.419999999999996e-119	NTclustered	gi\|359289533\|gb\|CP003126.1\|	1111069	g9539	i0	95.636	134.215189873418	275	11	95	1	12	286	1888226	1887953	Thermus sp. CCB_US3_UF1, complete genome	blastn	63618	442	0.995475113122172	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. CCB_US3_UF1
8237843	8237843	PRJNA608660_P_NODE_37167_length_199_cov_3.673333_g36811_i0	PRJNA608660	37167	199	3.673333	7.30993267	Trueperaceae bacterium	2026798	Bacteria	Bacteria	274	3.3899999999999997e-69	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g36811	i0	93.514	612.643216080402	185	11	92	1	9	192	2561011	2560827	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	121916	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
12064044	12064044	PRJNA608660_P_NODE_26190_length_260_cov_1.981043_g25834_i0	PRJNA608660	26190	260	1.981043	5.1507118	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	241	4.71e-59	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g25834	i0	98.529	82.8461538461538	136	2	85	0	120	255	875594	875459	Thermus sp. NEB1569 chromosome, complete genome	blastn	21540	241	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
12064148	12064148	PRJNA608660_P_NODE_3910_length_715_cov_28.313814_g3648_i0	PRJNA608660	3910	715	28.313814	202.4437701	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	787	0	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g3648	i0	93.585	199.151048951049	530	30	97	3	11	539	1637214	1637740	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	142393	787	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
17162499	17162499	PRJNA608660_P_NODE_38094_length_195_cov_3.589041_g37738_i0	PRJNA608660	38094	195	3.589041	6.99862995	Trueperaceae bacterium	2026798	Bacteria	Bacteria	213	7.3e-51	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g37738	i0	92.568	8.92307692307692	148	11	76	0	48	195	9572	9425	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	1740	213	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
20273428	20273428	PRJNA608660_P_NODE_42116_length_180_cov_1.984733_g41759_i0	PRJNA608660	42116	180	1.984733	3.5725194	Thermus	270	Bacteria	Bacteria	313	6.34e-81	NTclustered	gi\|2090196584\|gb\|CP082323.1\|	274	g41759	i0	100	7.51111111111111	169	0	94	0	1	169	961394	961562	Thermus thermophilus strain N-1 chromosome, complete genome	blastn	1352	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
22824278	22824278	PRJNA608660_P_NODE_32738_length_220_cov_2.210526_g32382_i0	PRJNA608660	32738	220	2.210526	4.8631572	Thermus	270	Bacteria	Bacteria	219	1.82e-52	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g32382	i0	98.4	26.2227272727273	125	1	94	1	1	124	1221246	1221122	Thermus parvatiensis strain RL, complete genome	blastn	5769	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
23537218	23537218	PRJNA608660_P_NODE_36039_length_204_cov_2.374194_g35683_i0	PRJNA608660	36039	204	2.374194	4.84335576	Trueperaceae bacterium	2026798	Bacteria	Bacteria	300	5.76e-77	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g35683	i0	95.722	339.416666666667	187	6	91	2	8	193	7470	7285	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	69241	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium

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