metadata: contig_metadata: 17 rows where bioproject = "PRJEB28062", tax_clade = "FCB group" and tax

17 rows where bioproject = "PRJEB28062", tax_clade = "FCB group" and tax_phylum = "Rhodothermota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6402371	6402371	PRJEB28062_P_NODE_18266_length_883_cov_4.530864_g16281_i0	PRJEB28062	18266	883	4.530864	40.00752912	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	680	0	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g16281	i0	83.091	1.71913929784824	757	118	85	9	23	774	1910097	1910848	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	1518	680	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
8952129	8952129	PRJEB28062_P_NODE_59188_length_456_cov_1.759791_g56829_i0	PRJEB28062	59188	456	1.759791	8.02464696	Rhodothermales bacterium	2306054	Bacteria	Bacteria	100	2.58e-21	NR	MEP0546801.1	2306054	g56829	i0	64.9	0.486842105263158	74	26	48.7	0	455	234	767	840	MEP0546801.1 DUF5916 domain-containing protein [Rhodothermales bacterium]	diamond	222	100	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
10227905	10227905	PRJEB28062_P_NODE_60489_length_450_cov_2.883289_g58129_i0	PRJEB28062	60489	450	2.883289	12.9748005	Salinibacter ruber	146919	Bacteria	Bacteria	99.8	6.189999999999999e-23	NR	WP_251951793.1	146919	g58129	i0	82.8	1.54666666666667	58	10	38.7	0	450	277	140	197	WP_251951793.1 IS5 family transposase [Salinibacter ruber]	diamond	696	99.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
11190185	11190185	PRJEB28062_P_NODE_100649_length_313_cov_1.858333_g98286_i0	PRJEB28062	100649	313	1.858333	5.81658229	Rubrivirga	1434037	Bacteria	Bacteria	137	7.86e-28	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g98286	i0	100	26.7124600638978	74	0	24	0	22	95	2614979	2615052	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	8361	137	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
11503440	11503440	PRJEB28062_P_NODE_72770_length_401_cov_13.057927_g70408_i0	PRJEB28062	72770	401	13.057927	52.36228727	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	340	7.319999999999999e-89	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g70408	i0	86.392	6.7356608478803	316	37	78	4	26	338	3155422	3155110	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	2701	340	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
12778822	12778822	PRJEB28062_P_NODE_66151_length_426_cov_3.677054_g63790_i0	PRJEB28062	66151	426	3.677054	15.66425004	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	202	3.849999999999999e-47	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g63790	i0	82.278	4.36619718309859	237	38	55	4	179	413	2636111	2636345	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	1860	202	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
16290192	16290192	PRJEB28062_P_NODE_46393_length_527_cov_17.396476_g44050_i0	PRJEB28062	46393	527	17.396476	91.67942852	Rhodothermales	1853224	Bacteria	Bacteria	536	1.1699999999999999e-147	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g44050	i0	85.91	150.84440227704	511	63	96	9	24	527	2906829	2906321	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	79495	536	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
16602284	16602284	PRJEB28062_P_NODE_76014_length_390_cov_11.056782_g73652_i0	PRJEB28062	76014	390	11.056782	43.1214498	Rubrivirga sp. SAORIC476	1961794	Bacteria	Bacteria	204	7.81e-64	NR	WP_095516022.1	1961794	g73652	i0	80.8	0.961538461538462	125	22	94.6	1	1	369	125	249	WP_095516022.1 hypothetical protein [Rubrivirga sp. SAORIC476]	diamond	375	204	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. SAORIC476
17876587	17876587	PRJEB28062_P_NODE_51275_length_497_cov_2.511792_g48925_i0	PRJEB28062	51275	497	2.511792	12.48360624	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	286	2.81e-93	NR	HEX8385102.1	2838334	g48925	i0	86.3	1.93158953722334	160	22	96.6	0	480	1	67	226	HEX8385102.1 tyrosine--tRNA ligase [Rubricoccaceae bacterium]	diamond	960	286	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
21701067	21701067	PRJEB28062_P_NODE_23078_length_778_cov_1.434043_g20901_i0	PRJEB28062	23078	778	1.434043	11.15685454	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	832	0	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g20901	i0	87.33	49.4125964010283	734	83	94	10	28	756	3266654	3265926	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	38443	832	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
22976816	22976816	PRJEB28062_P_NODE_44999_length_536_cov_66.304536_g42660_i0	PRJEB28062	44999	536	66.304536	355.39231296	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	676	0	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g42660	i0	91.935	191.518656716418	496	21	92	7	24	515	1308870	1308390	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	102654	676	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
22976983	22976983	PRJEB28062_P_NODE_51899_length_493_cov_7.269048_g49548_i0	PRJEB28062	51899	493	7.269048	35.83640664	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	342	2.5499999999999993e-89	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g49548	i0	92.181	152.391480730223	243	17	94	2	231	472	806789	806548	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	75129	342	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
28896331	28896331	PRJEB28062_P_NODE_44268_length_542_cov_2.321962_g41929_i0	PRJEB28062	44268	542	2.321962	12.58503404	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	96.7	1.6000000000000002e-22	NR	HEX8299845.1	2838334	g41929	i0	76.4	0.398523985239852	72	16	39.3	1	328	540	1	72	HEX8299845.1 hypothetical protein [Rubricoccaceae bacterium]	diamond	216	96.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
29205940	29205940	PRJEB28062_P_NODE_105049_length_300_cov_1.916300_g102686_i0	PRJEB28062	105049	300	1.9163	5.7489	Pseudomonadati	3379134	Bacteria	Bacteria	124	1.74e-30	NR	ARA93127.1	1779382	g102686	i0	60.6	3.96	99	39	99	0	2	298	163	261	ARA93127.1 hypothetical protein AWN76_008120 [Rhodothermaceae bacterium RA]	diamond	1188	124	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
29811928	29811928	PRJEB28062_P_NODE_121971_length_256_cov_1.475410_g119607_i0	PRJEB28062	121971	256	1.47541	3.7770496	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	126	2.66e-32	NR	HEX8386808.1	2838334	g119607	i0	73.4	0.92578125	79	21	92.6	0	237	1	6	84	HEX8386808.1 T9SS type A sorting domain-containing protein [Rubricoccaceae bacterium]	diamond	237	126	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
30033343	30033343	PRJEB28062_P_NODE_78851_length_381_cov_0.987013_g76489_i0	PRJEB28062	78851	381	0.987013	3.76051953	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	107	2e-24	NR	HEX9952756.1	2838334	g76489	i0	62.8	0.677165354330709	86	32	67.7	0	11	268	432	517	HEX9952756.1 NrfD/PsrC family molybdoenzyme membrane anchor subunit [Rubricoccaceae bacterium]	diamond	258	107	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
31708271	31708271	PRJEB28062_P_NODE_10837_length_1171_cov_25.673042_g9180_i0	PRJEB28062	10837	1171	25.673042	300.63132182	Rhodothermales bacterium	2306054	Bacteria	Bacteria	556	7.229999999999999e-191	NR	MEP0547300.1	2306054	g9180	i0	73	1.95217762596072	381	103	97.6	0	1149	7	70	450	MEP0547300.1 carboxypeptidase regulatory-like domain-containing protein [Rhodothermales bacterium]	diamond	2286	556	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium

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