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

12 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax_kingdom = "Orthornavirae"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
776713	776713	PRJNA792582_P_NODE_121_length_3159_cov_207.757291_g73_i0	PRJNA792582	121	3159	207.757291	6563.05282269	Rocky Mountain birnavirus	3077841	Viruses	Viruses	5461	0	NTclustered	gi\|2583625428\|gb\|OR427289.1\|	3077841	g73	i0	97.998	0.996201329534663	3147	62	99	1	3	3148	1	3147	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment A, complete sequence	blastn	3147	5461	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
777191	777191	PRJNA792582_P_NODE_81_length_3511_cov_72.853112_g31_i3	PRJNA792582	81	3511	72.853112	2557.87276232	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2588	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g31	i3	92.877	0.859014525776132	1783	122	86	5	6	1786	7108	5329	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	3016	2588	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
2052697	2052697	PRJNA792582_P_NODE_122_length_3158_cov_230.482658_g73_i1	PRJNA792582	122	3158	230.482658	7278.64233964	Rocky Mountain birnavirus	3077841	Viruses	Viruses	4037	0	NTclustered	gi\|2583625428\|gb\|OR427289.1\|	3077841	g73	i1	89.844	0.997783407219759	3151	310	99	10	12	3156	3147	1	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment A, complete sequence	blastn	3151	4037	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
2053058	2053058	PRJNA792582_P_NODE_53082_length_248_cov_0.880000_g52268_i0	PRJNA792582	53082	248	0.88	2.1824	Zebrafish picornavirus 1	2304617	Viruses	Viruses	436	5.3e-118	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g52268	i0	98.394	4.69354838709677	249	2	100	2	1	248	8180	7933	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1164	436	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4605132	4605132	PRJNA792582_P_NODE_184_length_2652_cov_192.750679_g112_i0	PRJNA792582	184	2652	192.750679	5111.74800708	Rocky Mountain birnavirus	3077841	Viruses	Viruses	3116	0	NTclustered	gi\|2582975581\|gb\|OR427290.1\|	3077841	g112	i0	88.05	0.993966817496229	2636	307	99	8	17	2648	2632	1	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment B, complete sequence	blastn	2636	3116	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
5880218	5880218	PRJNA792582_P_NODE_11165_length_509_cov_6.298165_g10356_i0	PRJNA792582	11165	509	6.298165	32.05765985	Goose orthorubulavirus 5	3384030	Viruses	Viruses	163	2.21e-35	NTclustered	gi\|2839303692\|gb\|PQ456202.1\|	3384030	g10356	i0	98.901	0.717092337917485	91	1	18	0	272	362	1	91	Goose orthorubulavirus 5 isolate YN01/PIV5, complete genome	blastn	365	163	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Goose orthorubulavirus 5
5880267	5880267	PRJNA792582_P_NODE_185_length_2652_cov_184.264444_g113_i0	PRJNA792582	185	2652	184.264444	4886.69305488	Rocky Mountain birnavirus	3077841	Viruses	Viruses	4612	0	NTclustered	gi\|2582975581\|gb\|OR427290.1\|	3077841	g113	i0	98.29	1.04524886877828	2632	45	99	0	18	2649	2632	1	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment B, complete sequence	blastn	2772	4612	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
5880658	5880658	PRJNA792582_P_NODE_54745_length_246_cov_0.890173_g53931_i0	PRJNA792582	54745	246	0.890173	2.18982558	Ripafren virus	3130475	Viruses	Viruses	340	4.2299999999999996e-89	NTclustered	gi\|2717319844\|gb\|PP172777.1\|	3130475	g53931	i0	91.903	154.565040650407	247	15	100	4	1	246	816	1058	MAG: Ripafren virus isolate KCAP1_k141_546482 genomic sequence	blastn	38023	340	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Ripafren virus
12256746	12256746	PRJNA792582_P_NODE_54710_length_246_cov_0.890173_g53896_i0	PRJNA792582	54710	246	0.890173	2.18982558	Pumpkin alphaendornavirus	2861712	Viruses	Viruses	444	3.14e-120	NTclustered	gi\|2072437000\|gb\|MW018478.1\|	2861712	g53896	i0	99.187	8.64227642276423	246	2	100	0	1	246	14757	14512	Pumpkin alphaendornavirus isolate Anhui, complete genome	blastn	2126	444	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Endornaviridae	Alphaendornavirus	Pumpkin alphaendornavirus
23730087	23730087	PRJNA792582_P_NODE_56379_length_244_cov_0.900585_g55565_i0	PRJNA792582	56379	244	0.900585	2.1974274	Zebrafish picornavirus 1	2304617	Viruses	Viruses	435	1.87e-117	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g55565	i0	98.77	3	244	3	100	0	1	244	5828	6071	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	732	435	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
25003652	25003652	PRJNA792582_P_NODE_57440_length_243_cov_0.905882_g56626_i0	PRJNA792582	57440	243	0.905882	2.20129326	Cucurbit chlorotic yellows virus	558690	Viruses	Viruses	444	3.09e-120	NTclustered	gi\|2899224146\|gb\|PQ686549.1\|	558690	g56626	i0	99.588	64.761316872428	243	1	100	0	1	243	4815	5057	Cucurbit chlorotic yellows virus isolate CCYV-M-NJ1 segment RNA2, complete sequence	blastn	15737	444	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Closteroviridae	Crinivirus	Cucurbit chlorotic yellows virus
25003702	25003702	PRJNA792582_P_NODE_80_length_3514_cov_99.854112_g31_i2	PRJNA792582	80	3514	99.854112	3508.87349568	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2854	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g31	i2	95.569	0.858281161070006	1783	74	86	5	1726	3506	5329	7108	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	3016	2854	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2

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