metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA896758" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA896758" 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
3795825	3795825	PRJNA896758_P_NODE_15263_length_292_cov_1.520548_g14873_i0	PRJNA896758	15263	292	1.520548	4.44000016	Deinococcus	1298	Bacteria	Bacteria	512	1.03e-140	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g14873	i0	98.288	210.359589041096	292	5	100	0	1	292	2672026	2672317	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	61425	512	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
4701435	4701435	PRJNA896758_P_NODE_26024_length_242_cov_0.911243_g25634_i0	PRJNA896758	26024	242	0.911243	2.20520806	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	237	5.61e-58	NTclustered	gi\|1868564649\|gb\|CP058536.1\|	2755035	g25634	i0	84.426	2.63223140495868	244	35	100	3	1	242	305605	305847	Deinococcus sp. D7000 plasmid p_2, complete sequence	blastn	637	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
7250989	7250989	PRJNA896758_P_NODE_25586_length_243_cov_0.905882_g25196_i0	PRJNA896758	25586	243	0.905882	2.20129326	Deinococcus geothermalis	68909	Bacteria	Bacteria	348	2.4900000000000003e-91	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g25196	i0	93.913	30.9753086419753	230	14	95	0	1	230	953933	954162	Deinococcus geothermalis DSM 11300, complete genome	blastn	7527	348	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
8525556	8525556	PRJNA896758_P_NODE_10987_length_346_cov_1.681319_g10597_i0	PRJNA896758	10987	346	1.681319	5.81736374	Petrotoga mobilis	69499	Bacteria	Bacteria	102	3.21e-17	NTclustered	gi\|160359135\|gb\|CP000879.1\|	403833	g10597	i0	81.967	1.60982658959538	122	20	35	2	88	208	580645	580765	Petrotoga mobilis SJ95, complete genome	blastn	557	102	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga mobilis
10172550	10172550	PRJNA896758_P_NODE_7488_length_414_cov_2.334311_g7098_i0	PRJNA896758	7488	414	2.334311	9.66404754	Truepera	332248	Bacteria	Bacteria	494	5.5e-135	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g7098	i0	88.164	403.306763285024	414	49	100	0	1	414	17	430	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	166969	494	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
12351831	12351831	PRJNA896758_P_NODE_26090_length_242_cov_0.911243_g25700_i0	PRJNA896758	26090	242	0.911243	2.20520806	Thermus scotoductus	37636	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g25700	i0	99.587	2.06611570247934	242	1	100	0	1	242	2032708	2032949	Thermus scotoductus SA-01, complete genome	blastn	500	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
14900773	14900773	PRJNA896758_P_NODE_21812_length_250_cov_0.870056_g21422_i0	PRJNA896758	21812	250	0.870056	2.17514	Thermus thermophilus	274	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|2199618452\|dbj\|AP025604.1\|	274	g21422	i0	98.8	2.408	250	3	100	0	1	250	161716	161467	Thermus thermophilus SNM1-7 plasmid pTthSNM1-7b DNA, complete sequence	blastn	602	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
16546452	16546452	PRJNA896758_P_NODE_21893_length_250_cov_0.870056_g21503_i0	PRJNA896758	21893	250	0.870056	2.17514	Deinococcus	1298	Bacteria	Bacteria	448	2.4699999999999996e-121	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g21503	i0	98.81	198.912	252	1	100	1	1	250	1455180	1455431	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	49728	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142

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