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

10 rows where analysis = "blastn", bioproject = "PRJNA929922" 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
906237	906237	PRJNA929922_P_NODE_142721_length_245_cov_0.872093_g142181_i0	PRJNA929922	142721	245	0.872093	2.13662785	Deinococcus gobiensis	502394	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g142181	i0	97.959	1	245	5	100	0	1	245	239844	240088	Deinococcus gobiensis I-0, complete genome	blastn	245	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
2181897	2181897	PRJNA929922_P_NODE_156522_length_242_cov_0.911243_g155982_i0	PRJNA929922	156522	242	0.911243	2.20520806	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	420	5.19e-113	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g155982	i0	97.934	3.88842975206612	242	5	100	0	1	242	832405	832646	Thermus sp. NEB1569 chromosome, complete genome	blastn	941	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
5082385	5082385	PRJNA929922_S_NODE_66204_length_245_cov_1.151163_g65980_i0	PRJNA929922	66204	245	1.151163	2.82034935	Deinococcus	1298	Bacteria	Bacteria	414	2.45e-111	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g65980	i0	100	279.363265306122	224	0	91	0	22	245	1791371	1791148	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	68444	414	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
6010422	6010422	PRJNA929922_P_NODE_58385_length_309_cov_1.254237_g57845_i0	PRJNA929922	58385	309	1.254237	3.87559233	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	270	7.32e-68	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g57845	i0	83.793	11.8705501618123	290	41	93	6	22	308	2670019	2670305	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	3668	270	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
6011557	6011557	PRJNA929922_S_NODE_41665_length_286_cov_1.446009_g41441_i0	PRJNA929922	41665	286	1.446009	4.13558574	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	512	1.01e-140	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g41441	i0	99.296	159.877622377622	284	1	100	1	4	286	73623	73340	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	45725	512	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
14007555	14007555	PRJNA929922_P_NODE_144691_length_244_cov_0.900585_g144151_i0	PRJNA929922	144691	244	0.900585	2.1974274	Thermus	270	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g144151	i0	99.18	5	244	2	100	0	1	244	88742	88985	Thermus scotoductus SA-01, complete genome	blastn	1220	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
14936260	14936260	PRJNA929922_S_NODE_42232_length_285_cov_0.905660_g42008_i0	PRJNA929922	42232	285	0.90566	2.581131	Deinococcus gobiensis	502394	Bacteria	Bacteria	385	2.29e-102	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g42008	i0	91.259	211.378947368421	286	19	99	6	2	285	111948	111667	Deinococcus gobiensis I-0, complete genome	blastn	60243	385	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
15281943	15281943	PRJNA929922_S_NODE_45592_length_278_cov_1.502439_g45368_i0	PRJNA929922	45592	278	1.502439	4.17678042	Thermotoga	2335	Bacteria	Bacteria	148	3.1699999999999998e-31	NTclustered	gi\|1374529454\|ref\|NR_076120.2\|	2337	g45368	i0	78.924	107.561151079137	223	43	79	3	53	272	338	559	Thermotoga neapolitana strain DSM 4359 23S ribosomal RNA, complete sequence	blastn	29902	148	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga neapolitana
19105062	19105062	PRJNA929922_P_NODE_156375_length_242_cov_0.911243_g155835_i0	PRJNA929922	156375	242	0.911243	2.20520806	Marinitoga	160798	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|372100556\|gb\|CP003257.1\|	443254	g155835	i0	100	0.231404958677686	28	0	12	0	148	175	1050291	1050318	Marinitoga piezophila KA3, complete genome	blastn	56	52.8	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga piezophila
20379983	20379983	PRJNA929922_P_NODE_161476_length_241_cov_0.916667_g160936_i0	PRJNA929922	161476	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	407	4.0199999999999995e-109	NTclustered	gi\|1953561895\|dbj\|AP024274.1\|	274	g160936	i0	97.872	11.6887966804979	235	5	98	0	7	241	10329	10563	Thermus thermophilus HB5018 plasmid pHB5018e DNA, complete sequence	blastn	2817	407	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus

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