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

10 rows where analysis = "blastn", bioproject = "PRJNA287283" and tax_phylum = "Deinococcota"

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
2922857	2922857	PRJNA287283_P_NODE_8083_length_187_cov_1.805970_g7859_i0	PRJNA287283	8083	187	1.80597	3.3771639	Trueperaceae bacterium	2026798	Bacteria	Bacteria	231	1.92e-56	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g7859	i0	89.247	6.95187165775401	186	19	99	1	1	185	7941	8126	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	1300	231	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
3609731	3609731	PRJNA287283_P_NODE_7183_length_205_cov_1.236842_g6959_i0	PRJNA287283	7183	205	1.236842	2.5355261	Deinococcus	1298	Bacteria	Bacteria	311	2.68e-80	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g6959	i0	94.608	204.409756097561	204	6	99	5	1	203	1455431	1455232	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	41904	311	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
5475608	5475608	PRJNA287283_P_NODE_6065_length_234_cov_1.762431_g5841_i0	PRJNA287283	6065	234	1.762431	4.12408854	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	370	5.09e-98	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g5841	i0	95.671	208.448717948718	231	8	99	2	2	231	1637246	1637475	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	48777	370	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
12537694	12537694	PRJNA287283_P_NODE_3490_length_340_cov_3.017422_g3266_i0	PRJNA287283	3490	340	3.017422	10.2592348	Deinococcus	1298	Bacteria	Bacteria	628	1.1699999999999999e-175	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g3266	i0	100	190.576470588235	340	0	100	0	1	340	698	359	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	64796	628	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
16361653	16361653	PRJNA287283_P_NODE_10733_length_165_cov_2.517857_g10509_i0	PRJNA287283	10733	165	2.517857	4.15446405	Deinococcus	1298	Bacteria	Bacteria	283	4.4899999999999995e-72	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g10509	i0	97.576	158.509090909091	165	4	100	0	1	165	1519	1683	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	26154	283	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
16361656	16361656	PRJNA287283_P_NODE_3713_length_330_cov_1.451264_g3489_i0	PRJNA287283	3713	330	1.451264	4.7891712	Truepera	332248	Bacteria	Bacteria	416	9.559999999999998e-112	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g3489	i0	89.394	433.39696969697	330	35	100	0	1	330	11	340	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	143021	416	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
21460939	21460939	PRJNA287283_P_NODE_717_length_859_cov_2.903226_g553_i0	PRJNA287283	717	859	2.903226	24.93871134	Deinococcus	1298	Bacteria	Bacteria	1570	0	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g553	i0	99.651	216.151338766007	859	3	100	0	1	859	1496	638	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	185674	1570	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
22736008	22736008	PRJNA287283_P_NODE_3818_length_325_cov_1.852941_g3594_i0	PRJNA287283	3818	325	1.852941	6.02205825	Deinococcus	1298	Bacteria	Bacteria	595	1.1299999999999995e-165	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g3594	i0	99.692	382.224615384615	325	1	100	0	1	325	16	340	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	124223	601	0.990016638935108	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
24011111	24011111	PRJNA287283_P_NODE_9279_length_179_cov_2.285714_g9055_i0	PRJNA287283	9279	179	2.285714	4.09142806	Truepera	332248	Bacteria	Bacteria	315	1.75e-81	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g9055	i0	99.422	180.279329608939	173	1	97	0	1	173	2106	1934	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	32270	315	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
25285260	25285260	PRJNA287283_P_NODE_5900_length_239_cov_1.134409_g5676_i0	PRJNA287283	5900	239	1.134409	2.71123751	Truepera	332248	Bacteria	Bacteria	335	1.9e-87	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g5676	i0	94.091	793.497907949791	220	13	92	0	20	239	650	869	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	189646	335	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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