metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax_phylum = "Nematoda"

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
13475998	13475998	PRJNA743294_P_NODE_47051_length_252_cov_1.212291_g46595_i0	PRJNA743294	47051	252	1.212291	3.05497332	Strongyloides ratti	34506	Nematoda	Nematoda	91.6	4.84e-14	NTclustered	gi\|1376142707\|ref\|XM_024651685.1\|	34506	g46595	i0	80.833	2.80555555555556	120	19	47	4	59	176	1379	1496	Strongyloides ratti SWI/SNF-related matrix-associated actin-dependent regulator of chromatin subfamily A member 5 (SRAE_2000080800), partial mRNA	blastn	707	91.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
13952250	13952250	PRJNA743294_P_NODE_17711_length_383_cov_2.822581_g17255_i0	PRJNA743294	17711	383	2.822581	10.81048523	root	1	Root_unresolved	Root_unresolved	63.9	1.69e-5	NTclustered	gi\|2707583670\|ref\|XM_064197987.1\|	51031	g17255	i0	79.167	2.23237597911227	96	16	25	3	12	105	3655	3562	Necator americanus uncharacterized protein (RB195_001282), partial mRNA	blastn	855	63.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
17300354	17300354	PRJNA743294_P_NODE_54894_length_243_cov_2.935294_g54438_i0	PRJNA743294	54894	243	2.935294	7.13276442	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	180	9.63e-41	NTclustered	gi\|150982261\|gb\|EF634719.1\|	452809	g54438	i0	88.889	15.0905349794239	144	16	59	0	89	232	303	160	Pristionchus sp. 15 RS5229 large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	3667	180	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
19050076	19050076	PRJNA743294_P_NODE_33335_length_290_cov_2.046083_g32879_i0	PRJNA743294	33335	290	2.046083	5.9336407	Metazoa	33208	Nematoda	Nematoda	195	4.22e-45	NTclustered	gi\|23306675\|gb\|AY137471.1\|	6233	g32879	i0	81.481	72.2448275862069	243	40	83	3	6	247	839	601	Panagrellus redivivus heat shock protein 70-C mRNA, complete cds	blastn	20951	196	0.994897959183674	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Panagrellus	Panagrellus redivivus
19848912	19848912	PRJNA743294_P_NODE_14796_length_417_cov_1.360465_g14340_i0	PRJNA743294	14796	417	1.360465	5.67313905	Strongyloides ratti	34506	Nematoda	Nematoda	364	4.5399999999999985e-96	NTclustered	gi\|1376147725\|ref\|XM_024654528.1\|	34506	g14340	i0	82.968	99.052757793765	411	62	98	7	9	415	679	1085	Strongyloides ratti ATP synthase subunit alpha, mitochondrial (SRAE_2000334600), partial mRNA	blastn	41305	364	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
20324807	20324807	PRJNA743294_P_NODE_55476_length_243_cov_0.917647_g55020_i0	PRJNA743294	55476	243	0.917647	2.22988221	Metazoa	33208	Nematoda	Nematoda	54.7	0.006	NTclustered	gi\|268554987\|ref\|XM_002635436.1\|	6238	g55020	i0	92.105	0.390946502057613	38	3	16	0	24	61	335	298	Caenorhabditis briggsae Protein CBG08779 (CBG08779), partial mRNA	blastn	95	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
21124433	21124433	PRJNA743294_P_NODE_11577_length_466_cov_21.501272_g11121_i0	PRJNA743294	11577	466	21.501272	100.19592752	Pristionchus pauli	376545	Nematoda	Nematoda	292	2.4499999999999994e-74	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g11121	i0	81.492	5.57510729613734	362	61	77	6	63	421	37	395	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2598	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
21124531	21124531	PRJNA743294_P_NODE_23797_length_336_cov_3.311787_g23341_i0	PRJNA743294	23797	336	3.311787	11.12760432	Trichinella spiralis	6334	Nematoda	Nematoda	52.8	0.032	NTclustered	gi\|339245486\|ref\|XM_003378621.1\|	6334	g23341	i0	100	0.0833333333333333	28	0	8	0	297	324	278	251	Trichinella spiralis cysteine-rich hydrophobic domain 2 protein (Tsp_06601) mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
22875797	22875797	PRJNA743294_P_NODE_11878_length_461_cov_3.090206_g11422_i0	PRJNA743294	11878	461	3.090206	14.24584966	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	477	6.229999999999998e-130	NTclustered	gi\|1376144465\|ref\|XM_024652690.1\|	34506	g11422	i0	85.621	100.297180043384	459	60	99	5	6	461	488	33	Strongyloides ratti Actin, alpha cardiac muscle 1 (SRAE_2000170700), partial mRNA	blastn	46237	481	0.991683991683992	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
23675187	23675187	PRJNA743294_P_NODE_53239_length_245_cov_1.470930_g52783_i0	PRJNA743294	53239	245	1.47093	3.6037785	Strongyloides papillosus	174720	Nematoda	Nematoda	128	3.57e-25	NTclustered	gi\|687022647\|emb\|LM525561.1\|	174720	g52783	i0	83.571	12.2571428571429	140	19	56	4	31	168	124953	124816	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000006	blastn	3003	128	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
24948684	24948684	PRJNA743294_P_NODE_57120_length_240_cov_2.329341_g56664_i0	PRJNA743294	57120	240	2.329341	5.5904184	Bunonema sp. VS-2014	1538689	Nematoda	Nematoda	174	4.42e-39	NTclustered	gi\|675119005\|gb\|KJ877382.1\|	1538689	g56664	i0	82.828	2.35833333333333	198	30	82	4	45	240	145	340	Bunonema sp. VS-2014 strain RS9014 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	566	174	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Bunonematidae	Bunonema	Bunonema sp. VS-2014
24948696	24948696	PRJNA743294_P_NODE_58500_length_232_cov_3.383648_g58044_i0	PRJNA743294	58500	232	3.383648	7.85006336	Pristionchus maxplancki	1317128	Nematoda	Nematoda	135	2e-27	NTclustered	gi\|478487033\|gb\|KC491696.1\|	1317128	g58044	i0	81.065	1.40086206896552	169	32	73	0	48	216	177	9	Pristionchus maxplancki strain RS5594 small subunit ribosomal protein 1 (rps1) gene, partial cds	blastn	325	135	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus maxplancki

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