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

13 rows where analysis = "blastn", bioproject = "PRJNA770826" 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
746905	746905	PRJNA770826_P_NODE_3401_length_470_cov_2.095012_g3230_i0	PRJNA770826	3401	470	2.095012	9.8465564	Caenorhabditis briggsae	6238	Nematoda	Nematoda	287	1.15e-72	NTclustered	gi\|268536293\|ref\|XM_002633236.1\|	6238	g3230	i0	79.949	90.2744680851064	389	78	83	0	22	410	633	245	Caenorhabditis briggsae Protein CBR-RPS-5 (Cbr-rps-5), partial mRNA	blastn	42429	287	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
2022956	2022956	PRJNA770826_P_NODE_5162_length_374_cov_1.880000_g4991_i0	PRJNA770826	5162	374	1.88	7.0312	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	204	9.28e-48	NTclustered	gi\|150982261\|gb\|EF634719.1\|	452809	g4991	i0	86.096	9.48128342245989	187	26	50	0	188	374	303	117	Pristionchus sp. 15 RS5229 large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	3546	204	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
3298115	3298115	PRJNA770826_P_NODE_34383_length_165_cov_0.896552_g34212_i0	PRJNA770826	34383	165	0.896552	1.4793108	Caenorhabditis elegans	6239	Nematoda	Nematoda	139	1.03e-28	NTclustered	gi\|3217630\|emb\|AL023815.1\|	6239	g34212	i0	81.928	64.7454545454545	166	28	100	2	1	165	6124	6288	Caenorhabditis elegans Fosmid H28O16, complete sequence	blastn	10683	139	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
3298152	3298152	PRJNA770826_P_NODE_503_length_1115_cov_3.984991_g424_i0	PRJNA770826	503	1115	3.984991	44.43264965	Strongyloides ratti	34506	Nematoda	Nematoda	915	0	NTclustered	gi\|1376136641\|ref\|XM_024648415.1\|	34506	g424	i0	81.655	94.3605381165919	1112	194	99	8	9	1115	10	1116	Strongyloides ratti Actin, alpha cardiac muscle 1 (SRAE_1000145800), partial mRNA	blastn	105212	915	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
4575183	4575183	PRJNA770826_P_NODE_3084_length_494_cov_2.298876_g2914_i0	PRJNA770826	3084	494	2.298876	11.35644744	Rhabditolaimus sp. 1 VS-2014	1538706	Nematoda	Nematoda	292	2.61e-74	NTclustered	gi\|675118995\|gb\|KJ877377.1\|	1538706	g2914	i0	79.475	71.3400809716599	419	80	84	5	1	416	3	418	Rhabditolaimus sp. 1 VS-2014 strain RSA134 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	35242	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Rhabditolaimus	Rhabditolaimus sp. 1 VS-2014
8400106	8400106	PRJNA770826_P_NODE_25627_length_168_cov_0.873950_g25456_i0	PRJNA770826	25627	168	0.87395	1.468236	Bursaphelenchus ussuriensis	3375378	Nematoda	Nematoda	69.4	1.4e-7	NTclustered	gi\|2838470513\|gb\|PQ500562.1\|	3375378	g25456	i0	75.309	20.2083333333333	162	30	90	7	1	152	4229	4390	Bursaphelenchus ussuriensis isolate CD4139 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	3395	69.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus ussuriensis
11410544	11410544	PRJNA770826_P_NODE_6109_length_339_cov_1.613793_g5938_i0	PRJNA770826	6109	339	1.613793	5.47075827	Opisthokonta	33154	Nematoda	Nematoda	54.7	0.009	NTclustered	gi\|1831517864\|ref\|NM_001136422.4\|	6239	g5938	i0	100	0.896755162241888	29	0	9	0	285	313	36	8	Caenorhabditis elegans FIP (Fungus-Induced Protein) Related (fipr-2), partial mRNA	blastn	304	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
12226534	12226534	PRJNA770826_P_NODE_12730_length_225_cov_2.971591_g12559_i0	PRJNA770826	12730	225	2.971591	6.68607975	Caenorhabditis elegans	6239	Nematoda	Nematoda	202	1.88e-47	NTclustered	gi\|156481\|gb\|M23433.1\|CELUBIA	6239	g12559	i0	83.182	150.395555555556	220	37	98	0	1	220	2798	2579	C.elegans polyubiquitin (UbiA) gene, complete cds	blastn	33839	202	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
17325252	17325252	PRJNA770826_P_NODE_34674_length_165_cov_0.896552_g34503_i0	PRJNA770826	34674	165	0.896552	1.4793108	Caenorhabditis elegans	6239	Nematoda	Nematoda	67.6	4.93e-7	NTclustered	gi\|392889729\|ref\|NM_001267159.1\|	6239	g34503	i0	93.478	1.39393939393939	46	1	27	2	61	105	650	606	Caenorhabditis elegans Guanine nucleotide-binding protein alpha-11 subunit (gpa-11), partial mRNA	blastn	230	67.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
17784318	17784318	PRJNA770826_P_NODE_14294_length_213_cov_1.573171_g14123_i0	PRJNA770826	14294	213	1.573171	3.35085423	Pristionchus	54125	Nematoda	Nematoda	110	1.1e-19	NTclustered	gi\|150984629\|gb\|EF634976.1\|	358043	g14123	i0	89.773	34.1830985915493	88	6	40	3	129	213	44	131	Pristionchus sp. 6 RS5101 small subunit ribosomal protein 27 (rps-27) mRNA, complete cds	blastn	7281	110	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 6 RS5101
18598726	18598726	PRJNA770826_P_NODE_6395_length_330_cov_1.978648_g6224_i0	PRJNA770826	6395	330	1.978648	6.5295384	Koerneria sp. RS1982	358044	Nematoda	Nematoda	211	4.84e-50	NTclustered	gi\|150982035\|gb\|EF634606.1\|	358044	g6224	i0	78.313	3.86363636363636	332	68	100	4	1	330	374	45	Koerneria sp. RS1982 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	1275	211	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Koerneria	Koerneria sp. RS1982
18598756	18598756	PRJNA770826_P_NODE_9935_length_256_cov_1.256039_g9764_i0	PRJNA770826	9935	256	1.256039	3.21545984	Aphelenchoides besseyi	269767	Nematoda	Nematoda	163	1.03e-35	NTclustered	gi\|1229082393\|gb\|KY992856.1\|	269767	g9764	i0	78.431	88.49609375	255	51	99	4	1	253	488	740	Aphelenchoides besseyi actin mRNA, partial cds	blastn	22655	163	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
21149537	21149537	PRJNA770826_P_NODE_4377_length_412_cov_7.531680_g4206_i0	PRJNA770826	4377	412	7.53168	31.0305216	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	159	2.27e-34	NTclustered	gi\|524845304\|gb\|KC819362.1\|	1355913	g4206	i0	79.556	5.01456310679612	225	44	54	2	102	325	260	37	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 35 (rpl-35) mRNA, partial cds	blastn	2066	159	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus

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