metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA683902" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA683902" 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
4493305	4493305	PRJNA683902_S_NODE_35524_length_160_cov_3.804878_g35080_i0	PRJNA683902	35524	160	3.804878	6.0878048	Deinococcus taeanensis	2737050	Bacteria	Bacteria	235	1.23e-57	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g35080	i0	93.125	3.54375	160	11	100	0	1	160	230941	231100	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	567	235	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
5003545	5003545	PRJNA683902_S_NODE_14464_length_316_cov_21.637993_g14020_i0	PRJNA683902	14464	316	21.637993	68.37605788	Deinococcus	1298	Bacteria	Bacteria	460	4.15e-125	NTclustered	gi\|2581867323\|gb\|OR600233.1\|	47478	g14020	i0	99.216	83.4556962025316	255	2	81	0	2	256	255	1	Deinococcus sp. strain RM 16S ribosomal RNA gene, partial sequence	blastn	26372	464	0.991379310344828	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
6279842	6279842	PRJNA683902_S_NODE_7445_length_639_cov_85.461794_g6970_i1	PRJNA683902	7445	639	85.461794	546.10086366	Deinococcus	1298	Bacteria	Bacteria	1061	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g6970	i1	96.714	306.787167449139	639	18	99	3	2	639	1049	1685	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	196037	1061	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
7043922	7043922	PRJNA683902_S_NODE_22886_length_215_cov_137.207865_g22442_i0	PRJNA683902	22886	215	137.207865	294.99690975	uncultured Deinococcus sp.	158789	Bacteria	Bacteria	268	1.73e-67	NTclustered	gi\|281313228\|gb\|GU214129.1\|	158789	g22442	i0	100	154.73488372093	145	0	67	0	71	215	1453	1309	Uncultured Deinococcus sp. clone IAFpp7118 16S ribosomal RNA gene, partial sequence	blastn	33268	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
8318605	8318605	PRJNA683902_S_NODE_6427_length_745_cov_44.381356_g6031_i1	PRJNA683902	6427	745	44.381356	330.6411022	Deinococcus sp. KNUC1210	2917691	Bacteria	Bacteria	865	0	NTclustered	gi\|2197029603\|gb\|CP092190.1\|	2917691	g6031	i1	87.682	288.045637583893	755	78	100	11	1	745	1426842	1427591	Deinococcus sp. KNUC1210 chromosome, complete genome	blastn	214594	865	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. KNUC1210
8318640	8318640	PRJNA683902_S_NODE_8847_length_527_cov_52.373469_g8424_i0	PRJNA683902	8847	527	52.373469	276.00818163	Deinococcus grandis	57498	Bacteria	Bacteria	723	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g8424	i0	91.477	216.628083491461	528	42	100	3	1	527	423935	423410	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	114163	723	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
12144631	12144631	PRJNA683902_S_NODE_20290_length_235_cov_56.449495_g19846_i0	PRJNA683902	20290	235	56.449495	132.65631325	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	429	8.33e-116	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g19846	i0	99.574	177.255319148936	235	1	100	0	1	235	1636292	1636058	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	41655	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
17753530	17753530	PRJNA683902_S_NODE_39934_length_150_cov_2.035398_g39490_i0	PRJNA683902	39934	150	2.035398	3.053097	Deinococcus	1298	Bacteria	Bacteria	252	1.12e-62	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g39490	i0	97.297	13.5533333333333	148	4	99	0	1	148	514278	514131	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	2033	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
17753718	17753718	PRJNA683902_S_NODE_9694_length_477_cov_71.300000_g9257_i0	PRJNA683902	9694	477	71.3	340.101	Deinococcus	1298	Bacteria	Bacteria	675	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g9257	i0	95.105	270.660377358491	429	19	90	2	1	429	73076	72650	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	129105	680	0.992647058823529	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
18517555	18517555	PRJNA683902_S_NODE_7355_length_648_cov_83.867430_g6970_i0	PRJNA683902	7355	648	83.86743	543.4609464	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	1007	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g6970	i0	94.785	243.578703703704	652	24	100	10	1	648	74912	74267	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	157839	1007	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
19027614	19027614	PRJNA683902_S_NODE_9695_length_477_cov_44.072727_g9258_i0	PRJNA683902	9695	477	44.072727	210.22690779	Deinococcus	1298	Bacteria	Bacteria	529	1.7599999999999993e-145	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g9258	i0	89.044	286.654088050314	429	44	90	3	49	477	423258	423683	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	136734	529	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
19792183	19792183	PRJNA683902_S_NODE_17836_length_261_cov_101.361607_g17392_i0	PRJNA683902	17836	261	101.361607	264.55379427	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	460	3.3399999999999995e-125	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g17392	i0	98.473	531.954022988506	262	3	100	1	1	261	1637947	1637686	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	138840	460	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
19792432	19792432	PRJNA683902_S_NODE_6376_length_752_cov_61.739860_g6031_i0	PRJNA683902	6376	752	61.73986	464.2837472	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	929	0	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g6031	i0	88.991	353.4375	763	68	100	14	1	752	1637686	1638443	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	265785	929	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
20301532	20301532	PRJNA683902_S_NODE_11676_length_389_cov_164.369318_g11232_i0	PRJNA683902	11676	389	164.369318	639.39664702	Deinococcus	1298	Bacteria	Bacteria	612	1.36e-170	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g11232	i0	95.337	322.969151670951	386	17	99	1	1	386	73076	72692	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	125635	617	0.991896272285251	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
21577275	21577275	PRJNA683902_S_NODE_11677_length_389_cov_130.335227_g11233_i0	PRJNA683902	11677	389	130.335227	507.00403303	Deinococcus	1298	Bacteria	Bacteria	490	6.649999999999998e-134	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g11233	i0	89.637	211.928020565553	386	38	99	2	4	389	423300	423683	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	82440	490	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
21577400	21577400	PRJNA683902_S_NODE_16417_length_281_cov_45.512295_g15973_i0	PRJNA683902	16417	281	45.512295	127.88954895	Deinococcus	1298	Bacteria	Bacteria	364	2.929999999999999e-96	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g15973	i0	90.323	215.23487544484	279	26	99	1	3	281	564	841	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	60481	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
21577745	21577745	PRJNA683902_S_NODE_30197_length_177_cov_185.371429_g29753_i0	PRJNA683902	30197	177	185.371429	328.10742933	Deinococcus	1298	Bacteria	Bacteria	320	3.71e-83	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g29753	i0	100	227.09604519774	173	0	98	0	5	177	73221	73393	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	40196	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
21578064	21578064	PRJNA683902_S_NODE_7937_length_596_cov_80.799642_g7532_i0	PRJNA683902	7937	596	80.799642	481.56586632	Deinococcus	1298	Bacteria	Bacteria	974	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g7532	i0	96.147	342.562080536913	597	21	100	2	1	596	73393	72798	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	204167	979	0.994892747701736	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
22342680	22342680	PRJNA683902_S_NODE_39198_length_152_cov_1.017391_g38754_i0	PRJNA683902	39198	152	1.017391	1.54643432	Deinococcus sonorensis	309891	Bacteria	Bacteria	134	4.31e-27	NTclustered	gi\|2745307249\|gb\|CP158299.1\|	694439	g38754	i0	96.341	7.92763157894737	82	2	54	1	51	132	1501850	1501770	Deinococcus sonorensis KR-87 chromosome, complete genome	blastn	1205	134	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
23618024	23618024	PRJNA683902_S_NODE_10819_length_421_cov_114.013021_g6970_i2	PRJNA683902	10819	421	114.013021	479.99481841	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	739	0	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g6970	i2	98.337	234.209026128266	421	7	100	0	1	421	1637307	1637727	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	98602	739	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
23618025	23618025	PRJNA683902_S_NODE_11019_length_413_cov_50.138298_g10575_i0	PRJNA683902	11019	413	50.138298	207.07117074	Deinococcus maricopensis	309887	Bacteria	Bacteria	318	3.54e-82	NTclustered	gi\|319753907\|gb\|CP002454.1\|	709986	g10575	i0	81.119	92.4794188861985	429	53	99	24	1	412	640161	640578	Deinococcus maricopensis DSM 21211, complete genome	blastn	38194	318	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
23618218	23618218	PRJNA683902_S_NODE_32299_length_170_cov_2.879699_g31855_i0	PRJNA683902	32299	170	2.879699	4.8954883	Deinococcus ficus	317577	Bacteria	Bacteria	265	1.68e-66	NTclustered	gi\|1220364820\|gb\|CP021082.1\|	317577	g31855	i0	95.21	4.01764705882353	167	8	98	0	1	167	383771	383937	Deinococcus ficus strain CC-FR2-10 plasmid pDFI1, complete sequence	blastn	683	265	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus

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