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

19 rows where analysis = "blastn", bioproject = "PRJNA290839" and tax_kingdom = "Metazoa"

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
5476364	5476364	PRJNA290839_P_NODE_585_length_335_cov_1.187023_g564_i0	PRJNA290839	585	335	1.187023	3.97652705	Lottia gigantea	225164	Mollusca	Mollusca	220	8.18e-53	NTclustered	gi\|676488530\|ref\|XM_009066399.1\|	225164	g564	i0	81.387	4.42089552238806	274	48	81	3	1	273	441	170	Lottia gigantea hypothetical protein mRNA	blastn	1481	220	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
6750611	6750611	PRJNA290839_P_NODE_766_length_292_cov_1.036530_g745_i0	PRJNA290839	766	292	1.03653	3.0266676	Drosophila busckii	30019	Arthropoda	Arthropoda	54.7	0.008	NTclustered	gi\|1829323352\|ref\|XM_017991740.2\|	30019	g745	i0	96.97	0.339041095890411	33	0	11	1	165	197	321	352	PREDICTED: Drosophila busckii shootin-1 (LOC108603182), transcript variant X1, mRNA	blastn	99	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila busckii
9987627	9987627	PRJNA290839_P_NODE_1188_length_250_cov_0.870056_g1167_i0	PRJNA290839	1188	250	0.870056	2.17514	Diptera	7147	Arthropoda	Arthropoda	460	3.17e-125	NTclustered	gi\|422898859\|gb\|JQ613602.1\|	335710	g1167	i0	100	99.6	249	0	99	0	2	250	1020	772	Bradysia difformis voucher 122 18S ribosomal RNA gene, partial sequence	blastn	24900	460	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Bradysia	Bradysia impatiens
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
15087093	15087093	PRJNA290839_P_NODE_1332_length_247_cov_0.896552_g1311_i0	PRJNA290839	1332	247	0.896552	2.21448344	Elephantidae	9780	Chordata	Chordata	241	4.44e-59	NTclustered	gi\|2710901988\|ref\|XM_064293858.1\|	9785	g1311	i0	84.874	46.1336032388664	238	36	96	0	2	239	155	392	PREDICTED: Loxodonta africana calmodulin 3 (CALM3), mRNA	blastn	11395	241	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Proboscidea	Elephantidae	Loxodonta	Loxodonta africana
15675632	15675632	PRJNA290839_P_NODE_1653_length_242_cov_0.899408_g1632_i0	PRJNA290839	1653	242	0.899408	2.17656736	Phenacoccus solenopsis	483260	Arthropoda	Arthropoda	161	3.47e-35	NTclustered	gi\|675275138\|gb\|KJ909511.1\|	483260	g1632	i0	81.407	42.5247933884297	199	35	82	2	1	198	498	301	Phenacoccus solenopsis putative tubulin beta-1 chain mRNA, partial cds	blastn	10291	161	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Pseudococcidae	Phenacoccus	Phenacoccus solenopsis
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
16950292	16950292	PRJNA290839_P_NODE_1554_length_243_cov_0.917647_g1533_i0	PRJNA290839	1554	243	0.917647	2.22988221	Vespula pensylvanica	30213	Arthropoda	Arthropoda	191	4.45e-44	NTclustered	gi\|2098661466\|ref\|XM_043811691.1\|	30213	g1533	i0	83.744	97.1481481481482	203	31	83	2	42	243	339	138	PREDICTED: Vespula pensylvanica ubiquitin-40S ribosomal protein S27a (LOC122628880), mRNA	blastn	23607	191	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Vespidae	Vespula	Vespula pensylvanica
16950300	16950300	PRJNA290839_P_NODE_654_length_317_cov_1.036885_g633_i0	PRJNA290839	654	317	1.036885	3.28692545	Papilio polytes	76194	Arthropoda	Arthropoda	431	3.26e-116	NTclustered	gi\|389615034\|dbj\|AK405121.1\|	76194	g633	i0	99.574	0.741324921135647	235	1	74	0	1	235	235	1	Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis	blastn	235	431	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
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
22049325	22049325	PRJNA290839_P_NODE_1138_length_251_cov_0.865169_g1117_i0	PRJNA290839	1138	251	0.865169	2.17157419	Chrysoperla carnea	189513	Arthropoda	Arthropoda	254	5.81e-63	NTclustered	gi\|2125146824\|ref\|XM_044885461.1\|	189513	g1117	i0	87.615	84.7171314741036	218	27	87	0	19	236	568	785	PREDICTED: Chrysoperla carnea ATP synthase subunit beta, mitochondrial (LOC123302507), mRNA	blastn	21264	254	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Neuroptera	Chrysopidae	Chrysoperla	Chrysoperla carnea
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
23324954	23324954	PRJNA290839_P_NODE_1479_length_245_cov_0.901163_g1458_i0	PRJNA290839	1479	245	0.901163	2.20784935	Mus musculus	10090	Chordata	Chordata	453	5.1900000000000006e-123	NTclustered	gi\|18606171\|gb\|BC022986.1\|	10090	g1458	i0	100	66.9755102040816	245	0	100	0	1	245	2	246	Mus musculus transferrin, mRNA (cDNA clone MGC:29918 IMAGE:5123741), complete cds	blastn	16409	453	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
24599004	24599004	PRJNA290839_P_NODE_1480_length_245_cov_0.901163_g1459_i0	PRJNA290839	1480	245	0.901163	2.20784935	Queda youngi	1458196	Arthropoda	Arthropoda	128	3.57e-25	NTclustered	gi\|751960357\|gb\|KJ548853.1\|	1458196	g1459	i0	92.308	30.0897959183673	91	6	37	1	11	101	502	413	Queda youngi voucher UNM KBMQuyo455 RNA polymerase II (RNA Pol II) gene, partial cds	blastn	7372	128	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Dytiscidae	Queda	Queda youngi

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