metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1199330" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1199330" 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
2319198	2319198	PRJNA1199330_P_NODE_109102_length_247_cov_0.896552_g108403_i0	PRJNA1199330	109102	247	0.896552	2.21448344	Truepera	332248	Bacteria	Bacteria	390	4.1699999999999997e-104	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g108403	i0	95.142	756.461538461538	247	12	100	0	1	247	2694	2940	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	186846	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
5429032	5429032	PRJNA1199330_P_NODE_59825_length_291_cov_1.059633_g59126_i0	PRJNA1199330	59825	291	1.059633	3.08353203	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	532	7.9e-147	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g59126	i0	99.656	19.1958762886598	291	1	100	0	1	291	2785839	2786129	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	5586	532	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
6702789	6702789	PRJNA1199330_P_NODE_110206_length_246_cov_1.803468_g109507_i0	PRJNA1199330	110206	246	1.803468	4.43653128	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g109507	i0	99.593	112.260162601626	246	1	100	0	1	246	67426	67181	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	27616	449	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
7979810	7979810	PRJNA1199330_P_NODE_95107_length_258_cov_1.686486_g94408_i0	PRJNA1199330	95107	258	1.686486	4.35113388	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	472	1.52e-128	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g94408	i0	99.612	14.922480620155	258	1	100	0	1	258	1208229	1208486	Thermus sp. NEB1569 chromosome, complete genome	blastn	3850	472	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
8696795	8696795	PRJNA1199330_P_NODE_102587_length_251_cov_2.595506_g101888_i0	PRJNA1199330	102587	251	2.595506	6.51472006	Thermus	270	Bacteria	Bacteria	420	5.41e-113	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g101888	i0	96.813	7.9362549800796804	251	8	100	0	1	251	2071630	2071380	Thermus scotoductus SA-01, complete genome	blastn	1992	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
9252792	9252792	PRJNA1199330_P_NODE_100328_length_253_cov_0.866667_g99629_i0	PRJNA1199330	100328	253	0.866667	2.19266751	Thermus thermophilus	274	Bacteria	Bacteria	440	4.189999999999998e-119	NTclustered	gi\|333965676\|gb\|CP002777.1\|	762633	g99629	i0	98.024	16.6679841897233	253	5	100	0	1	253	1651295	1651043	Thermus thermophilus SG0.5JP17-16, complete genome	blastn	4217	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
9972340	9972340	PRJNA1199330_P_NODE_36488_length_342_cov_3.672862_g35789_i0	PRJNA1199330	36488	342	3.672862	12.56118804	Thermus	270	Bacteria	Bacteria	610	4.25e-170	NTclustered	gi\|470468782\|ref\|NR_076136.1\|	37636	g35789	i0	98.834	144.850877192982	343	3	100	1	1	342	179	521	Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence	blastn	49539	610	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
13079859	13079859	PRJNA1199330_P_NODE_88871_length_264_cov_2.167539_g88172_i0	PRJNA1199330	88871	264	2.167539	5.72230296	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	477	3.359999999999999e-130	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g88172	i0	99.242	39.8598484848485	264	2	100	0	1	264	609447	609184	Thermus sp. NEB1569 chromosome, complete genome	blastn	10523	477	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
13079904	13079904	PRJNA1199330_P_NODE_91711_length_261_cov_2.712766_g91012_i0	PRJNA1199330	91711	261	2.712766	7.08031926	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g91012	i0	100	6	261	0	100	0	1	261	1146083	1145823	Thermus sp. NEB1569 chromosome, complete genome	blastn	1566	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
16903245	16903245	PRJNA1199330_P_NODE_80514_length_272_cov_1.994975_g79815_i0	PRJNA1199330	80514	272	1.994975	5.426332	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g79815	i0	100	11.9926470588235	272	0	100	0	1	272	278254	278525	Thermus sp. NEB1569 chromosome, complete genome	blastn	3262	503	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);;