metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB30004" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB30004" 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
50178	50178	PRJEB30004_P_NODE_597681_length_167_cov_1.859375_g582054_i0	PRJEB30004	597681	167	1.859375	3.10515625	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g582054	i0	100	130.389221556886	167	0	100	0	1	167	56168	56002	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	21775	309	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
2593863	2593863	PRJEB30004_P_NODE_46863_length_1087_cov_34.078244_g35411_i0	PRJEB30004	46863	1087	34.078244	370.43051228	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	1703	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g35411	i0	95.041	315.162833486661	1089	44	99	10	1	1084	3085869	3086952	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	342582	1703	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
3861927	3861927	PRJEB30004_P_NODE_297764_length_283_cov_2.114754_g282137_i0	PRJEB30004	297764	283	2.114754	5.98475382	Deinococcus altitudinis	468914	Bacteria	Bacteria	176	1.49e-39	NTclustered	gi\|2865407847\|gb\|CP129416.1\|	468914	g282137	i0	80.603	7.14840989399293	232	41	81	3	53	282	548012	547783	Deinococcus altitudinis strain LMG 24022 plasmid unnamed1, complete sequence	blastn	2023	176	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
12799670	12799670	PRJEB30004_P_NODE_51431_length_1018_cov_35.306435_g35411_i2	PRJEB30004	51431	1018	35.306435	359.4195083	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	1709	0	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g35411	i2	96.955	316.212180746562	1018	31	100	0	1	1018	57154	58171	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	321904	1709	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
13742101	13742101	PRJEB30004_P_NODE_46991_length_1085_cov_43.152008_g35411_i1	PRJEB30004	46991	1085	43.152008	468.1992868	Deinococcus	1298	Bacteria	Bacteria	1836	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g35411	i1	97.32	277.488479262673	1082	28	99	1	5	1085	1	1082	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	301075	1836	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
18840322	18840322	PRJEB30004_P_NODE_523175_length_185_cov_1.465753_g507548_i0	PRJEB30004	523175	185	1.465753	2.71164305	Deinococcus	1298	Bacteria	Bacteria	267	5.18e-67	NTclustered	gi\|2865404944\|gb\|CP129415.1\|	468914	g507548	i0	92.935	170.162162162162	184	12	99	1	2	185	413094	413276	Deinococcus altitudinis strain LMG 24022 chromosome, complete genome	blastn	31480	268	0.996268656716418	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
18840430	18840430	PRJEB30004_P_NODE_685655_length_151_cov_1.053571_g670028_i0	PRJEB30004	685655	151	1.053571	1.59089221	Deinococcus	1298	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g670028	i0	100	12.046357615894	151	0	100	0	1	151	1446	1596	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	1819	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
19153798	19153798	PRJEB30004_P_NODE_132516_length_511_cov_36.845339_g35411_i3	PRJEB30004	132516	511	36.845339	188.27968229	Deinococcus taeanensis	2737050	Bacteria	Bacteria	795	0	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g35411	i3	94.757	220.530332681018	515	20	100	7	1	511	687	1198	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	112691	795	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
22998064	22998064	PRJEB30004_P_NODE_513559_length_188_cov_0.791946_g497932_i0	PRJEB30004	513559	188	0.791946	1.48885848	Deinococcus geothermalis	68909	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g497932	i0	100	294.776595744681	188	0	100	0	1	188	328537	328724	Deinococcus geothermalis DSM 11300, complete genome	blastn	55418	348	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis

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