metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA509429" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA509429" 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
1760526	1760526	PRJNA509429_P_NODE_46662_length_162_cov_0.881890_g45834_i0	PRJNA509429	46662	162	0.88189	1.4286618	Petrotoga mobilis	69499	Bacteria	Bacteria	102	1.32e-17	NTclustered	gi\|160359135\|gb\|CP000879.1\|	403833	g45834	i0	81.967	2.48765432098765	122	20	75	2	39	159	580645	580765	Petrotoga mobilis SJ95, complete genome	blastn	403	102	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga mobilis
3662036	3662036	PRJNA509429_P_NODE_37983_length_188_cov_1.830065_g37155_i0	PRJNA509429	37983	188	1.830065	3.4405222	Truepera	332248	Bacteria	Bacteria	255	1.14e-63	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g37155	i0	91.444	108.627659574468	187	14	99	2	3	188	316	501	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	20422	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
3662060	3662060	PRJNA509429_P_NODE_883_length_1379_cov_12.246280_g648_i0	PRJNA509429	883	1379	12.24628	168.8762012	Deinococcus	1298	Bacteria	Bacteria	1496	0	NTclustered	gi\|16975048\|pdb\|1JZX\|A	1299	g648	i0	91.387	179.883248730964	1103	80	80	12	280	1377	412	1504	Chain A, 23S rRNA	blastn	248059	1496	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
4939054	4939054	PRJNA509429_P_NODE_884_length_1379_cov_12.017857_g648_i1	PRJNA509429	884	1379	12.017857	165.72624803	Deinococcus	1298	Bacteria	Bacteria	1530	0	NTclustered	gi\|16975048\|pdb\|1JZX\|A	1299	g648	i1	91.931	186.978245105149	1103	74	80	12	3	1100	1504	412	Chain A, 23S rRNA	blastn	257843	1530	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
6863016	6863016	PRJNA509429_P_NODE_35566_length_197_cov_3.265432_g34738_i0	PRJNA509429	35566	197	3.265432	6.43290104	Deinococcus rubellus	1889240	Bacteria	Bacteria	244	2.62e-60	NTclustered	gi\|2304456361\|gb\|CP104213.1\|	1889240	g34738	i0	89.637	333.324873096447	193	19	98	1	5	197	319864	320055	Deinococcus rubellus strain Ant6 chromosome, complete genome	blastn	65665	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus rubellus
7488820	7488820	PRJNA509429_P_NODE_11426_length_426_cov_2.360614_g10608_i0	PRJNA509429	11426	426	2.360614	10.05621564	Bacteria	2	Bacteria	Bacteria	156	3.04e-33	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g10608	i0	75.272	136.415492957746	368	70	83	18	1	354	715352	714992	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	58113	156	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
12589687	12589687	PRJNA509429_P_NODE_12970_length_396_cov_4.426593_g12149_i0	PRJNA509429	12970	396	4.4265930000000004	17.52930828	Deinococcus	1298	Bacteria	Bacteria	704	0	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g12149	i0	98.737	128.065656565657	396	5	100	0	1	396	920293	919898	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	50714	704	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
13864532	13864532	PRJNA509429_P_NODE_17751_length_326_cov_6.783505_g16923_i0	PRJNA509429	17751	326	6.783505	22.1142263	Deinococcus	1298	Bacteria	Bacteria	499	9.11e-137	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g16923	i0	94.495	190.570552147239	327	13	99	5	1	324	3060799	3061123	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	62126	501	0.996007984031936	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
16413449	16413449	PRJNA509429_P_NODE_1933_length_997_cov_12.888773_g648_i3	PRJNA509429	1933	997	12.888773	128.50106681	Deinococcus	1298	Bacteria	Bacteria	1557	0	NTclustered	gi\|16975048\|pdb\|1JZX\|A	1299	g648	i3	94.89	316.880641925777	998	47	99	4	1	995	508	1504	Chain A, 23S rRNA	blastn	315930	1557	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
18962390	18962390	PRJNA509429_P_NODE_39155_length_184_cov_1.342282_g38327_i0	PRJNA509429	39155	184	1.342282	2.46979888	Truepera	332248	Bacteria	Bacteria	239	1.12e-58	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g38327	i0	92.727	6.20652173913043	165	12	90	0	1	165	1736	1572	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	1142	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
19611319	19611319	PRJNA509429_P_NODE_47696_length_159_cov_1.645161_g46868_i0	PRJNA509429	47696	159	1.645161	2.61580599	Deinococcus sp. KNUC1210	2917691	Bacteria	Bacteria	228	2.0399999999999996e-55	NTclustered	gi\|2197029603\|gb\|CP092190.1\|	2917691	g46868	i0	92.453	213.339622641509	159	12	100	0	1	159	1427368	1427526	Deinococcus sp. KNUC1210 chromosome, complete genome	blastn	33921	228	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. KNUC1210
20237215	20237215	PRJNA509429_P_NODE_37676_length_189_cov_2.714286_g36848_i0	PRJNA509429	37676	189	2.714286	5.13000054	Truepera	332248	Bacteria	Bacteria	174	3.32e-39	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g36848	i0	91.406	737.931216931217	128	9	68	2	62	189	2842	2717	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	139469	174	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
22787787	22787787	PRJNA509429_P_NODE_11998_length_414_cov_41.680739_g11179_i0	PRJNA509429	11998	414	41.680739	172.55825946	Deinococcus	1298	Bacteria	Bacteria	621	2.4199999999999997e-173	NTclustered	gi\|145033\|gb\|M21413.1\|DEIRGDA	1299	g11179	i0	93.72	112.149758454106	414	26	100	0	1	414	493	906	D.radiodurans 16S ribosomal RNA gene	blastn	46430	627	0.990430622009569	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans

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