metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA290839" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA290839" 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
372906	372906	PRJNA290839_P_NODE_1541_length_243_cov_0.917647_g1520_i0	PRJNA290839	1541	243	0.917647	2.22988221	Caenorhabditis briggsae	6238	Nematoda	Nematoda	274	4.29e-69	NTclustered	gi\|2158425340\|ref\|XM_045242542.1\|	6238	g1520	i0	91.089	0.831275720164609	202	18	83	0	30	231	396	195	Caenorhabditis briggsae Protein CBG15099 (CBG15099), partial mRNA	blastn	202	274	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
10576830	10576830	PRJNA290839_P_NODE_1389_length_246_cov_0.901734_g1368_i0	PRJNA290839	1389	246	0.901734	2.21826564	Caenorhabditis briggsae	6238	Nematoda	Nematoda	244	3.42e-60	NTclustered	gi\|2158425965\|ref\|XM_045244938.1\|	6238	g1368	i0	93.827	0.776422764227642	162	10	78	0	85	246	1234	1073	Caenorhabditis briggsae Protein CBG03843 (CBG03843), partial mRNA	blastn	191	244	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
10576831	10576831	PRJNA290839_P_NODE_1589_length_243_cov_0.900000_g1568_i0	PRJNA290839	1589	243	0.9	2.187	Caenorhabditis briggsae	6238	Nematoda	Nematoda	154	5.84e-33	NTclustered	gi\|12958081\|gb\|AC090416.1\|AC090416	6238	g1568	i0	86.62	13.5473251028807	142	16	58	3	103	242	8310	8170	Caenorhabditis briggsae cosmid CB042D07, complete sequence	blastn	3292	154	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
16950284	16950284	PRJNA290839_P_NODE_1114_length_251_cov_0.870787_g1093_i0	PRJNA290839	1114	251	0.870787	2.18567537	Caenorhabditis briggsae	6238	Nematoda	Nematoda	420	5.41e-113	NTclustered	gi\|268561065\|ref\|XM_002646310.1\|	6238	g1093	i0	96.813	21	251	8	100	0	1	251	19135	19385	Caenorhabditis briggsae Protein CBR-UNC-89 (Cbr-unc-89), partial mRNA	blastn	5271	420	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
16950288	16950288	PRJNA290839_P_NODE_1254_length_249_cov_0.863636_g1233_i0	PRJNA290839	1254	249	0.863636	2.15045364	Caenorhabditis briggsae	6238	Nematoda	Nematoda	316	7.239999999999998e-82	NTclustered	gi\|2158430986\|ref\|XM_045244195.1\|	6238	g1233	i0	95.025	0.807228915662651	201	10	81	0	1	201	87	287	Caenorhabditis briggsae Protein CBG09910 (CBG09910), partial mRNA	blastn	201	316	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
16950290	16950290	PRJNA290839_P_NODE_1354_length_247_cov_0.890805_g1333_i0	PRJNA290839	1354	247	0.890805	2.20028835	Caenorhabditis briggsae	6238	Nematoda	Nematoda	76.8	1.32e-9	NTclustered	gi\|13129527\|gb\|AC090524.1\|AC090524	6238	g1333	i0	91.228	1.08906882591093	57	4	23	1	89	144	85127	85071	Caenorhabditis briggsae cosmid CB019H23, complete sequence	blastn	269	76.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
19498814	19498814	PRJNA290839_P_NODE_1176_length_250_cov_0.875706_g1155_i0	PRJNA290839	1176	250	0.875706	2.189265	Caenorhabditis briggsae	6238	Nematoda	Nematoda	148	2.8099999999999993e-31	NTclustered	gi\|2158426460\|ref\|XM_045236905.1\|	6238	g1155	i0	95.652	0.368	92	4	37	0	86	177	709	800	Caenorhabditis briggsae Protein CBR-UNC-14 (Cbr-unc-14), partial mRNA	blastn	92	148	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
22049331	22049331	PRJNA290839_P_NODE_1538_length_243_cov_0.917647_g1517_i0	PRJNA290839	1538	243	0.917647	2.22988221	Caenorhabditis briggsae	6238	Nematoda	Nematoda	303	5.48e-78	NTclustered	gi\|11545986\|gb\|AC087075.1\|AC087075	6238	g1517	i0	95.288	1.50205761316872	191	9	79	0	52	242	1588	1398	Caenorhabditis briggsae cosmid CB023K10, complete sequence	blastn	365	303	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
23324951	23324951	PRJNA290839_P_NODE_1239_length_249_cov_0.875000_g1218_i0	PRJNA290839	1239	249	0.875	2.17875	Caenorhabditis briggsae	6238	Nematoda	Nematoda	250	7.4499999999999995e-62	NTclustered	gi\|95831921\|gb\|DQ498827.1\|	6238	g1218	i0	86.441	1.51004016064257	236	22	94	7	1	235	59674	59448	Caenorhabditis briggsae clone BAC RP94-13P22, complete sequence	blastn	376	250	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae

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