RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB2333" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB2333 · 8 ✖

analysis 1

  • diamond · 8 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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
12776454 12776454 PRJEB2333_P_NODE_2491_length_592_cov_2.181982_g1724_i0 PRJEB2333 2491 592 2.181982 12.91733344 Dicistroviridae sp. 1955144 Viruses Viruses 102 2.64e-21   NR ULF99782.1 1955144 g1724 i0 51 3.46621621621622 96 47 48.6 0 590 303 1810 1905 ULF99782.1 MAG: putative replicase [Dicistroviridae sp.] diamond 2052 102 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
27381034 27381034 PRJEB2333_P_NODE_2543_length_568_cov_1.173258_g1775_i0 PRJEB2333 2543 568 1.173258 6.66410544 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 51.6 7.25e-4   NR XCM67734.1 3003959 g1775 i0 35.7 0.903169014084507 84 45 42.3 2 7 246 777 855 XCM67734.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 513 51.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28479585 28479585 PRJEB2333_P_NODE_1226_length_1988_cov_2.393644_g729_i0 PRJEB2333 1226 1988 2.393644 47.58564272 Cripavirus 144051 Viruses Viruses 191 1.34e-47   NR ULF99842.1 1955141 g729 i0 47.4 2.74496981891348 228 108 32.7 5 1486 836 245 471 ULF99842.1 MAG: hypothetical protein 2 [Cripavirus sp.] diamond 5457 191 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
29938508 29938508 PRJEB2333_P_NODE_1951_length_948_cov_1.939627_g1245_i0 PRJEB2333 1951 948 1.939627 18.38766396 Vespula vulgaris Picorna-like virus 1 2874401 Viruses Viruses 274 2.19e-79   NR QZZ63310.1 2874401 g1245 i0 46.1 2.00632911392405 317 160 97.5 6 924 1 1160 1474 QZZ63310.1 hypothetical protein [Vespula vulgaris Picorna-like virus 1] diamond 1902 274 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Vespula vulgaris Picorna-like virus 1
30127688 30127688 PRJEB2333_P_NODE_1972_length_932_cov_1.818994_g1245_i1 PRJEB2333 1972 932 1.818994 16.95302408 Flumine dicistrovirus 2 2940683 Viruses Viruses 171 2.24e-44   NR UQB76003.1 2940684 g1245 i1 54.3 1.58047210300429 164 72 51.8 3 450 932 204 367 UQB76003.1 non-structural polyprotein [Flumine dicistrovirus 20] diamond 1473 171 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Flumine dicistrovirus 20
32056232 32056232 PRJEB2333_P_NODE_1278_length_1902_cov_2.560322_g729_i1 PRJEB2333 1278 1902 2.560322 48.69732444 Cripavirus sp. 1955141 Viruses Viruses 299 8.86e-87   NR ULF99858.1 1955141 g729 i1 44.9 3.5993690851735 381 182 56 8 3 1067 93 471 ULF99858.1 MAG: hypothetical protein 2 [Cripavirus sp.] diamond 6846 299 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
32839390 32839390 PRJEB2333_P_NODE_1280_length_1895_cov_2.568353_g729_i2 PRJEB2333 1280 1895 2.568353 48.67028935 Cripavirus 144051 Viruses Viruses 191 8.149999999999998e-48   NR ULF99842.1 1955141 g729 i2 47.4 2.87968337730871 228 108 34.4 5 413 1063 245 471 ULF99842.1 MAG: hypothetical protein 2 [Cripavirus sp.] diamond 5457 191 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
32902353 32902353 PRJEB2333_P_NODE_2380_length_658_cov_3.428341_g1623_i0 PRJEB2333 2380 658 3.428341 22.55848378 Picornavirales 464095 Viruses Viruses 87 9.9e-16   NR QXV86620.1 1955144 g1623 i0 42.7 1.4726443768997 96 54 43.8 1 487 200 741 835 QXV86620.1 capsid protein [Dicistroviridae sp.] diamond 969 87.8 0.990888382687927 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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